Creating Outstanding Spreadsheet Models

Creating Outstanding Spreadsheet Models

PASS Data Community Summit via YouTube Direct link

Data Visualization Principles

25 of 32

25 of 32

Data Visualization Principles

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.