Completed
What to do with spreadsheet errors
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 Introduction
- 2 Layout Design
- 3 Development Memory
- 4 Design Layout
- 5 Naming Conventions
- 6 Naming Convention Example
- 7 Model Layout
- 8 Why does this matter
- 9 Clean and organized layout
- 10 Bloat
- 11 Technology
- 12 Layout
- 13 Mechanics
- 14 Design for readability
- 15 Named ranges
- 16 Root out spreadsheet errors
- 17 What to do with spreadsheet errors
- 18 Volatile functions
- 19 Data visualization presentation
- 20 Pie charts
- 21 Data occlusion
- 22 Show relevant data
- 23 Sparklines
- 24 Dashboard
- 25 Data Visualization Principles
- 26 Organizational Problem
- 27 Canned Solution
- 28 Creative Solution
- 29 Avoid 3D Pie Charts
- 30 I Wish More People Would Say This
- 31 Understanding Complex Data
- 32 CostBenefit Analysis
