How to Create Drop Down Lists in Excel
What you'll 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
- Combine VLOOKUP function with drop down list in Excel
Requirements
- (Extreme) Basic Knowledge of MS Office Excel 2010, 2013, 2016 or Office 365 is required
- Access to MS Office Excel 2010, 2013, 2016 or Office 365
Description
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!
Who this course is for:
- Beginners of Excel who want to maximize the drop down list function in Excel
- Office Workers who uses Excel a lot and want to improve their productivity
Course content
- Preview02:57
Instructor
![Nicky Wong](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.1 Instructor Rating
- 1,143 Reviews
- 63,826 Students
- 15 Courses
Nicky Wong is an expert in translating data into market opportunities. Data is his passion, Excel, Databases and Big Data are truly wonderful topics. As an absolute data lover and he is always looking for ways to analyze it. It started with stock market facts and now quickly turned to everything that is unique and different.
However, all the information have one primairy goal and that is "How to use this information to gain a competitive advantage". As a Market Researcher with it roots in Marketing Nicky understands that knowledge is power. Whatever you do make sure you use data at your advantage.
=====================================================================
My vision of Data and the future
=====================================================================
Why Data visualization matters!
I truly belief that Big Data is giving us all a new obstacle to overcome! Information overload is a serious challenge and with Big Data it only multiplies the issue. If you are a data miner you will know that much data has no meaning if you cannot connect any meaningful dots.
Large chunks of data, reports and tables are not effective. It is impressive to get a huge database but it is demotivating for others to read data. The biggest data trend is increasing this issue! Big Data = Information Overload x 10.
From (Digital) Information Age to the (Digital) Understanding Age
A data analyst can analyze data but the most important skill is Data Visualization! These so called "data visualizers" will develop a new skill gathering meaningful information and present it in a very understandable and effective way.
The issue is not anymore the data but the way to give meaning and communicating meaning to others. The person who can do that will have a huge advantage in the so ever growing Big Data world.
Big Data is here! Data Visualizer is on it`s way! In all of my courses I use techniques to create understandable data and present it in an impactful manner.