Spotlight: Data Visualization in Excel

Instructor: Shir Aviv, ExcelShir

The ability to effectively convey information visually is one of the most essential skills in a professional setting today. Period. Shir Aviv will not only share his best practices from 11+ years of visualizing data, but he will also pull back the curtain and teach you step by step how to create clear and compelling charts that leap off the screen. Maybe you’ve never created your own charts from scratch, or perhaps you got frustrated when Excel’s default settings didn’t suit your needs - either way, this Excel Spotlight class is for you.

What will you learn in this class?

In these two hours you will learn step by step how to create Pie, Column, Line, and Scatter Charts, while understanding how and why they work, and when to use each type. You will instantly set yourself apart from 99.9% of the population who either does not use charts at all, or simply uses the default settings. In short, leveraging charts correctly will help you communicate more effectively, influence stakeholders, and be seen as professional, polished, and promotable.

This class is PERFECT for you if:

  • You use Excel every day but have never created a chart on your own from scratch.
  • You have tried using charts before but felt intimidated and limited.
  • You find yourself using other people’s charts but are hesitant to make changes in fear that they might break.

This class is NOT for you if:

  • You have never touched a spreadsheet before or you rarely use Excel. If this is the case, you will not have a foundation on which to leverage charts.
  • You already consider yourself to be an expert with charts, and are looking for more advanced functionality (e.g. Waterfall Charts, dynamic data labels, automating charts using Macros, etc).

A Note Regarding Compatibility:

The class will be taught using Excel 2019 for PC, but the principles will also apply to Mac users. Menus, labels, and shortcuts may be different, but the concepts are universal and transferable across operating systems. IMPORTANT: Creating charts in Google Sheets will NOT be covered in this class.

** New! "Spotlight" Master Classes are one-session deep dives on a specific topic. Let us know your thoughts on this new format! ** 

A One-session “Spotlight” Master Class

Thursday, March 24
10:00 am – Noon Pacific
11:00 am – 1:00 pm Mountain
Noon – 2:00 pm Central
1:00 pm – 3:00 pm Eastern


JPro members – $50
Non-members – $100