Completed
Intro
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
