Excel – Advanced Dropdowns

Date/Time: Monday, 25th October 2021 - 1:30 pm - 2:15 pm

Location: Online

Available Spaces: 17

Contact Details: Marc Watson: marc.watson@nhs.net


This course examines Advanced and dynamic dropdown lists using Data Validation techniques.

Please note, it is recommended that you have good knowledge of Data Validation and the use of Excel to attend this session.

Topics covered will be:

  • Creating & formatting the data for your dynamic dropdown(s)
  • Creating a dynamic dropdown list
    • To allow users to add values to a lookup list and have this reflected in the data validation
  • Creating conditional dropdown lists
    • To allow users to select a value (e.g. a CCG) and have a second Dropdown linked only to that CCG (e.g. GP Practices etc.)

Please be aware that the session is booked for 30 minutes and the extra 15 minutes are for any questions which may occur. You are not obligated to stay for the full 45 minutes.

You need to be logged in in order to be able to register for this event.
Please use the login form at the top of the page.