Creating Awesome Charts in Excel: Process and Examples
Speaker(s):
Chandoo (Purna Duggirala)
Duration: 120 minutes
Track: Visualize & Inform
Learn how to create awesome charts using Microsoft Excel. Understand the principles behind chart selection, creation & formatting to impress & communicate. In this hands-on session we will be creating many Excel charts for common business analysis needs, understand why they work, how to improve them and what mistakes to avoid.
• 6 types of analytical needs
• 8 recommended chart types
• Data to ink ratio & maximizing it
• How to choose colors & fonts
• Formatting guidelines
• Charts for Budget vs. Actual analysis
• Charts for trends & forecasts
• Charts for comparing and highlighting best (worst) performers
Who can attend: Anyone familiar with Excel and already creating charts (doing analysis). Recommended for CXOs, Managers or Analysts or people who need to communicate often.