Drop Down Lists in Excel - Dependent, Unique Lists and Other Data Validation Lists
Offered By: YouTube
Course Description
Overview
Syllabus
Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX & INDIRECT.
Excel Simple Dependent Drop down List based on numbers (Index without match).
Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List.
Excel Dependent Drop Down List with Tabular Data without Named Ranges.
Excel: Extract unique items for dynamic data validation drop down list.
Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set).
Create SMART Drop Down Lists in Excel (with Data Validation).
Excel Custom Data Validation (Use formulas to check for text, numbers & length).
Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank Cells.
Excel Dynamic Arrays (How they will change EVERYTHING!).
This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this).
Reset Dependent Drop-down in Excel (with a tiny bit of VBA).
Create Multiple Dependent Drop-Down Lists in Excel (on Every Row).
Taught by
Leila Gharani
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard