Excel Dropdown Lists for Improving Spreadsheet Layout

preview_player
Показать описание

This video takes you through spreadsheet layout using dropdown lists as a way to use ONE sheet where instincts would have us make 12 sheets.

The inspiration for this tutorial is many real-life situations where teeth stopped gnashing once we were able to reduce thousands of formulas and dozens of spreadsheets down to a single sheet that was easy to maintain. And dropdown lists were the key!

This video takes you through proper development before you get to the "AWWW HELL NAW!!!!" moment.

You will see: dropdown lists, tables, SUMIFS, COUNTIFS, and VLOOKUP

These concepts are also covered in my book:
Guerrilla Data Analysis 2nd Ed.

Your comments and feedback are welcome. Let me know if there's an Excel feature or a data management concept you'd like to know more about. I would love to help and make a video.
  1. Excel On Fire
  2. Dropdown list
  3. Excel
  4. Spreadsheet layout
  5. Oz du Soleil
  6. SUMIFS
Рекомендации по теме
Excel Dropdown Lists 0:14:50

Excel Dropdown Lists for Improving Spreadsheet Layout

Excel Drop Down 0:08:37

Excel Drop Down List Tutorial

No VBA needed! 0:02:15

No VBA needed! Improve drop-down list font size in Excel

Crazy Drop Down 0:09:17

Crazy Drop Down Lists for Excel

Creating Expanding Dropdown 0:03:18

Creating Expanding Dropdown Lists | Excel | Tutorial

Unique Drop Down 0:02:01

Unique Drop Down Lists that Automatically Update with New Values

Create Dynamic Dropdown 0:13:03

Create Dynamic Dropdown Lists in Excel

Excel Tips - 0:02:18

Excel Tips - Create Searchable Dropdown Lists | No VBA or Formulas Required | Latest Excel Versions

How to Build 2:42:13

How to Build a Leave Request App in Power Apps

How to increase 0:04:26

How to increase the size of drop down list in Excel

How to Increase 0:02:59

How to Increase Font Size In Excel Drop-Down List Using VBA | Drop-Down List Font Too Small

Advanced Excel - 0:13:08

Advanced Excel - Data Validation and Drop-Down Lists

Excel Create Dependent 0:03:50

Excel Create Dependent Drop Down List Tutorial

How to Create 0:06:09

How to Create Searchable Drop Down Lists in Excel with ZERO Effort!

Excel Tips - 0:03:44

Excel Tips - Best Way to Create Dropdowns that Dynamically Update

Make Multiple Dependent 0:10:59

Make Multiple Dependent Dropdown Lists in Excel (Easiest Method)

How to use 0:01:26

How to use an excel dropdown list and vlookup to auto-populate cells based on a selection

Searchable Drop Down 0:11:00

Searchable Drop Down List in Excel (Very Easy with FILTER Function)

Many SEARCHABLE Drop-Down 0:11:58

Many SEARCHABLE Drop-Down Lists in Excel (No VBA)

How to Create 0:10:49

How to Create Linked Drop-Down Lists in Excel

Create SMART Drop 0:15:42

Create SMART Drop Down Lists in Excel (with Data Validation)

How to increase 0:01:18

How to increase drop down list font size in Excel

How to use 0:09:36

How to use XLOOKUP to Create Dependent Drop-Down Lists in Microsoft Excel

Awesome Trick to 0:07:39

Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)

Комментарии
Автор

Good video Oz. I like the way you present the material. I've never used lists before and this got me going pretty well in my own dataset. Thanks!

IanFrantz
Автор

Thank you so much for this! it gave me awesome new ideas to sort an present my data.

invinity
Автор

Nice, thank you..I will be using this type of format for my data at work

daviscrt