Description: Understanding the use of advanced and dynamic dropdown lists using Data Validation techniques.
Course outline:
- The pros and cons of a basic dropdown
- Creating a dynamic dropdown list
- Establishing an Excel Formatted table as a list
- Using the INDIRECT function
- The benefits of a dynamic list
- Creating a conditional dropdown list
- Naming the tables to be used
- The benefits of a conditional dropdown list
- Naming convention issues affecting conditional dropdowns
- What might present a problem?
- Using an XLOOKUP to remedy this issue
Not Enrolled
Course Includes
- 5 Lessons
- Course Certificate
Login
Accessing this course requires a login. Please enter your credentials below!