Automatic Sorting in Excel - Unique RANK

Excel Charts (2010) - Visualization Secrets for Impressive Charts

Section 1: What You'll Learn in This Course

Section 2: Effectively Communicate & Present Data Trends

Effective Presentation of Quantitative Data - Overview (1:51)
Table Design - Best Practices (2:57)
Excel Chart Design - Best Practices (5:00)
Understanding the Chart Tools Environment (18:13)
Simple Shortcuts to Save Time (8:30)
QUIZ: Best Practice & Chart Options

Section 3: Behind-the-Scenes Secrets of Dynamic Charts

Section 4: Excel Chart Updates When New Data is Added

Excel Tables are a Time Saver (8:27)
When Tables fail Use this Function (10:58)
Excel Name Manager & OFFSET as a Great Team (9:15)
OFFSET without Name Manager to Update your Excel Chart (9:11)
Exercise - Dynamic Excel Charts

Section 5: Getting the Interactive Dashboard Effect

Index and Match for an Interactive Chart that shows Different Views (2:19)
Index & Match - The Index Part (4:36)
Index & Match - The Match Part (2:55)
The Dream Team - INDEX & MATCH (7:00)
Mix it all for Major Time Saving - It becomes a Dashboard! (12:53)
Exercise - Function for Interactive Charts

Section 6: Automatic Sorting of Bars in Excel Charts

Section 7: Automatic Legend Positioning

Perfect Positioning of Series Labels (2:03)
Excel Chart Series Label Positioning - Simple Line Series (7:39)
Excel Chart Series Label Positioning - Changing Line Series (6:20)
Excel Chart Series Label Positioning - Stacked Column Chart (8:46)
Exercise - Automatic Legend Positioning

Section 8: Secret Techniques that Bring Attention to Key Chart Elements

Highlight key Areas for Faster & Easier Readability (3:06)
Excel Conditional Format Column Colors for Best Impact (9:22)
Excel Conditional Format Bar Colors (3:06)
Conditionally Color Neg/Pos Columns & Data Labels (13:25)
Better Alternative for Variance Charts in Excel (11:59)
Vertical Lines to Create Dividers (9:05)
Error bars as Dividers (7:53)
Use Dynamic Annotations to Direct Reader Attention (19:32)
Exercise - Bring Attention to Key Excel Chart Elements

Section 9: Design Tables that Highlight & Impress

Conditional Formatting for Easy-to-Read Tables - Overview (2:30)
The Conditional-Formatting-Free method - Use Symbols (8:12)
Highlight Table Rows Based on Values (6:59)
Using Smart Color Coding in Tables (4:22)
Use Symbols or Bars for Easier Readability (4:55)
Exercise - Design Tables with Focus

Section 10: Measuring Performance - Actual Versus Budget/Target

Measuring Performance, doing Comparisons & predicting the Future (2:35)
Excel Column Chart Combinations (7:39)
Using Line Series in Excel - Make Sure you do this to Avoid Crashing Lines (8:01)
Variances With a Bar Chart - The Professional Method #1 (18:13)
Variances With Two Bar Charts - Professional Method #2 (21:53)
Measuring Performance - Bullet Charts Overview (1:47)
Vertical Bullet Chart with Percentages in Excel (9:53)
Vertical Bullet Chart with Absolute Values in Excel (6:31)
Horizontal Bullet Chart in Excel (11:22)
Horizontal Bullet Chart - The Easy Method (3:40)
Exercise - Effective Charts to Measure Actual to Budget Performance

Section 11: Effective Comparisons - Actual Versus Previous Year

Use Symbols in Excel Charts - The Simple Method (8:10)
Use symbols in Excel Charts - The Impressive Method (6:56)
Include a Reference Region (8:59)
Learn how to Create a Pin chart for Variances (9:43)
Exercise - Effective Excel Chart to Compare Actual to Previous Year

Section 12: Predictive Analysis - Showing Outlook Development

Section 13: Most Effective Chart Combinations to Enhance your Reports

Effective Chart Combinations - Overview (1:30)
Scatter & Bubble Charts (7:20)
KPI by Geography (8:08)
Comparing Distributions with Box Plots (10:38)
Parts-to-whole Chart - It's Not the Pie Chart (11:36)
Pareto Chart - 80-20 rule (3:25)
Panel Charts - Showing Many Variables at Once (11:13)
Sparklines for Compact Charts (5:03)
Gantt Charts in Excel
Exercise - Effective Chart Combinations

Section 14: Waterfall / Bridge Chart in Excel

Final Words

Lesson content locked

If you're already enrolled, you'll need to login.