Главная
Study mode:
on
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
Description:
Dive into a comprehensive conference talk on creating exceptional spreadsheet models in this Business Analytics Marathon session. Learn essential techniques for layout design, development memory, naming conventions, and model organization. Explore strategies to enhance readability, utilize named ranges, and identify spreadsheet errors. Discover the impact of volatile functions and best practices for data visualization, including the effective use of sparklines and dashboards. Gain insights into solving organizational problems with creative solutions and understand the importance of cost-benefit analysis in complex data scenarios. Master the art of crafting outstanding spreadsheet models to elevate your business analytics skills.

Creating Outstanding Spreadsheet Models

PASS Data Community Summit
Add to list