Data Visualization & Data Storytelling-Mastering Charts in Excel

FULL COURSE DESCRIPTION:

  • Ask people what comes to mind when they think of Excel, and odds are they’ll say “spreadsheets“. The truth is, Excel is an incredibly powerful and dynamic data visualization platformfor those willing to think beyond rows, columns, and primitive pie charts — and I’m here to prove it.
  • This course gives you a deep, 100% comprehensive understanding of Excel’s latest data visualization tools and techniques. I’ll show you when, why, and how to use each Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercisesevery step of the way.

We’ll cover advanced Excel data viz topics that you won’t find anywhere else, including:

  • Custom image overlay charts
  • Automation with named ranges and OFFSET/COUNTA functions
  • Scroll & Zoom functionality with Excel form controls
  • Animated charts to visualize changes over time
  • Dynamic, custom Excel dashboards
  • Value-based chart formatting
  • Custom gauge charts & pacing charts
  • Grid visuals using Excel array formulas

 

WHAT YOU’LL LEARN

  • Understand WHEN, WHY, and HOW to use 20+ chart types in Excel 2016
  • Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, and more
  • Master unique tips, tools and case studies that you won’t find in ANY other Excel course, guaranteed
  • Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor

ENQUIRY form

    ORGANIZATION DETAILS





    PERSON-IN-CHARGE DETAILS



    FOR FURTHER INFORMATION, PLEASE CONTACT US!