How to Create Drop Down Lists in Excel

How to Create Drop Down Lists in Excel

Create Drop Down Lists in Excel

In this course you will learn how to create drop down lists in Excel.

Why should I explore about Drop Down List in Excel?

Let me share my personal story: When I started out one of the things I learn was Drop Down Lists. This skills was not only essential but fun. A drop down list opens up many new possibilities. Because now instead of making 'boring' spreadsheets you start building a real dashboard or almost a system. User can now just click and select an option. That pretty trick is uncommon in Excel.

The moment you understand this a whole new world of possibilities opens up. Being able to connect formula`s with a drop down list is so much fun.

Is this course suitable for me?

This course is designed by doing. This means you will really have to follow along with the course and take action. Next, my courses are designed with an Action Exercise at the end of each part. When I started out to create courses I did that from the very beginning. One of the things I always love to hear is that the students like the  challenging exercises. The challenge forces you the make practical use of your learning so far.

Finally, it is build upon each other. Every section is connected in a way that you need the knowledge from each. This ensures that you really learn everything from top to bottom. And once you know this you can see how you can do even more with drop down lists by connect new formula`s and functions. It is a fun skill to learn.

Are you ready to start?

If you envision yourself making more advance Excel templates where users will have a nice and easy UI the drop down list skill is part of it. Then take action and let`s start!

Create a basic drop down list, a dynamic dropdown list and a dependent drop down list in Excel

Url: View Details

What you will learn

• Create a basic drop down list in Excel
• Create a dynamic drop down list in Excel
• Create a dependent / conditional drop down list in Excel

Rating: 3.4

Level: All Levels

Duration: 2 hours

Instructor: Nicky Wong