Building Advanced Interactive Charts in Excel (Session 1)

Create the charts Microsoft forgot to add in. In this masterclass, I’ll show you step-by-step how to create awesome interactive charts by using Excel in counterintuitive ways. We’ll employ a mix of slicers, the camera tool, pivot tables, and a bug in Microsoft Excel (a.k.a the “rollover method”) to build the type of charts you might find online. Attendees will walk away with an appreciation for using Excel in creative ways. In addition, they’ll receive final versions of each chart built as well as online instructions to refer to after later on.

Topics for Session 1

  • Learn how to take your charting skills to the next level
  • Exploit a bug in Microsoft Excel to make Excel do things it’s not allowed
  • Use timelines, slicers, and pivot tables to create data visualizations that help decision-makers understand what’s going on

Topics for Session 2

  • Learn how to reuse the components of advanced charts in your own work
  • Tap into your creative juices to make Excel do the impossible
Data Visualization & Reporting