Excel – Advanced Dropdowns

When

November 15, 2023
2:00 pm - 2:45 pm
18 spaces left

Where

Online

Contact details: Paul Atwell @ paul.atwell1@nhs.net

Description

Understanding the use of advanced and dynamic dropdown lists using Data Validation techniques.

Prerequisites
A good to advanced working knowledge of Excel.
Ideally, previous attendance of “Introduction to Data Validation techniques” course or equivalent experience.

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

The session will take between 30-40 minutes to complete and is followed by a Q & A which is optional to attend.

Either the booking cut off time has passed, or you are unable to book a place on this event due to security restrictions, please contact NECSU.learning@nhs.net if you believe this to be incorrect.