How to Use Excel Data Forms

Live Online Learning (1 Hour)

If you manage, work with or enter data into a table, Excel Data Forms could be the best Excel feature that you are currently not using.

In this interactive live online training session, you will be introduced to the new possibilities of the Excel Data Forms tool – to transform the way you display and enter data, and make navigating information easier.

Your expert tutor will begin by giving you an overview of the feature, before walking you through the essentials of how to create data forms and use them effectively.

This How to Use Excel Data Forms training session is suitable for users of Excel 2013 and 2016.

What Will I Learn?

How Excel Data Forms will change the way you work - Learn about the power of Data Forms to transform the way you display and enter data.

How to create an Excel Data Form - Construct your own data form, and set up quick access to tools to make using it easier.

How to get the best from an Excel Data Form - Learn the superior table data-entry skills to take your capabilities and productivity higher.


You should have a basic understanding of creating and editing workbooks in Excel 2013 or 2016. For new users of Excel, taking the How to Create an Excel Spreadsheet training first would be beneficial.

What Are Live-Online Sessions?

Live Online gives you all the benefits of classroom training, but from the comfort of your home or office. Sessions take place on a shared online screen, where your friendly trainer will guide you and your class through the learning topic.

These interactive sessions also give you the opportunity to practice what you’ve learnt, as you take control and demonstrate your new skills to your trainer. Two-way text or voice chat is always available, for when you want to discuss a topic, need help, or want to ask any questions.


£95 per person, per session

Maximum Group Size:

6 people

Request Training

t: 0203 941 4100 | e:

Course Content

  • What is a Data Form
  • Why use a Data Form
  • How to construct a Data Form
  • How to add the Data Form button to the Quick Access Toolbar
  • How to add, find, change and delete rows in a range or table