Webinar – Excel Data Validation

Price: $25.00 incl GST

Duration: 1.5 hours

Excel has a built-in Data Validation feature that you can use to limit and control the entries that go into certain cells. You can use this to make sure users comply with your input requirements.

Unfortunately the feature has one failing. Learn what it is and how to handle it.

This session will take you through some useful techniques to create flexible data validations including in-cell drop down lists, as well as how to cope with the major failing of the system.

The session covers

  • setting upper and lower parameters – fixed and flexible
  • creating custom error messages
  • how to validate the validations and show the user when an error has been made
  • creating in-cell drop down lists
  • creating flexible lists that automatically expand and don’t require any complicated formulas
  • how to create dependent drop downs – one drop down affects the entries in a second drop down

As usual I will throw in some useful general tips along the way.

Date: October 22, 2020
Time: 1.00 PM (AEST)
Event: Excel Data Validation
Topic: Excel Data Validation
Public: Public
Registration: Click here to register.