Completed
On Using Nested IFS
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Creating Outstanding Spreadsheet Models
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Jordan Goldmeier
- 3 Overview
- 4 Layout and Design In Depth
- 5 Spreadsheet file naming styles
- 6 Filenames in practice
- 7 Worksheet Tabs Names in Practice
- 8 Proper Model Layout
- 9 Model Layout in Practice
- 10 Why does this even matter? Separation of concerns
- 11 Clean & Organized Layout
- 12 Keep Detailed Instructions Out!
- 13 Mechanics in Depth
- 14 Design for Readability
- 15 Root Out Spreadsheet Errors
- 16 Volatile Functions to Avoid
- 17 Use Natural Formulas
- 18 Natural Lookup Problem
- 19 Natural Ordinal Scale Problem
- 20 On Using Nested IFS
- 21 Data Visualization and Presentation in depth
- 22 Misleading charts
- 23 Which slice is greater?
- 24 Data Occlusion
- 25 Show Relevant Data Together
- 26 Learn Data Visualization Principles How many sevens can you count?
- 27 Data Visualization in Practice Using the table, what is the second highest month?
- 28 What else can we see from this chart?
- 29 Respect Audience Intelligence
- 30 Conclusions
