9,546 views
Dependent Dropdown List in Excel ???? Check out the full Excel Expert course: https://bit.ly/excelexpert_a In this class, you will learn how to create a dependent dropdown list, also known as cascading data validation. We will use the SUBSTITUTE and INDIRECT functions. -------------------------------------------------------------------------------------------------- Content of this class: 00:00 Introduction 00:40 What we will see in class 02:14 Explanation Data Validation 04:52 INDIRECT Function 06:22 Creating Tables 10:01 SUBSTITUTE Function 12:30 Create Dependent List 16:44 Personal Finance Dashboard This is a course for you who want to learn Excel from scratch. You will learn the main features and functions of Excel. If you want to go deeper and become an Excel expert and stand out in your company, I highly recommend my Complete Excel Course, find out more here: https://bit.ly/excelexpert_a -------------------------------------------------------------------------------------------------- ???? Subscribe to our channel: / minhasplanilhasbr ???? Turn on notifications (just click on the bell????)! ???? Leave your like! --------------------------------------------------------------------------------------------------- Follow everything about Power BI on other social networks: ???? Telegram: https://bit.ly/telegramdashexperience ???? Instagram: / gerson.mvp ???? LinkedIn: / gersonggv --------------------------------------------------------------------------------------------------- Free Excel Course Lesson - 1 • Lesson 1: Introduction to Excel - [Course ... Lesson - 2 • Lesson 2: First Steps in Excel [Cu... Lesson - 3 • Video Lesson - 4 • Lesson 4: Formulas and Functions in Excel ... Lesson - 5 • Lesson 5: Introduction to Charts in E... Lesson - 6 • Video Lesson - 7 • Lesson 7: How to Stand Out in the Company w... -------------------------------------------------------------------------------------------------- #dropdownlist #datavalidation #excel #excelcourse #excelonlinecourse Excel Course, Learn Excel, Excel, Data Validation, Dropdown List