ICAEW.com works better with JavaScript enabled.
Exclusive

Enhancing data display and entry with Excel Form Controls

Author:

Published: 13 Nov 2023

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.
Form Controls are objects that can be used to display data or make it easier for users to enter data, to perform an action or to make a selection.
Allow video content provided by StreamAMG

This video content is provided by StreamAMG. We ask for your permission before anything is loaded, as they are using cookies and other technologies. You may want to read StreamAMG owner's PA Media Group privacy policy before accepting. If you are happy to view this content, please choose Allow all cookies.

Examples are slider bars, drop down lists and option buttons. These objects are surprisingly simple to set up and use. They enable entered data to be validated and controlled.

The session will show you how to create Form Controls, use them in a range of practical examples and enhance the user experience of any spreadsheet.

Key benefits

  • How to build user friendly interfaces to a spreadsheet.
  • How to use Form Controls to restrict and validate data inputs.
  • How to add interactivity to your spreadsheets.

The event shows spreadsheet developers a range of tools to enhance their user interface. This allows less experienced people the ability to use spreadsheets in an engaging and controlled way, removing the fear that they might do something wrong.

First broadcast on 13 November 2023

Webinar resources

This webinar has closed captions enabled. In order to enable this feature, please click on the “CC” icon at the bottom of your screen. Please note that the transcript is automatically generated and errors may occur.

This webinar could contribute to up to 1 hour of verifiable CPD, so long as you can demonstrate that the content is relevant to your role. Find out more.