ABOUT THIS EVENT

Event Category

Business & Technology

Event Overview

You have a lot of data in Excel and need summaries. Rows and columns of text and numbers isn't sufficient and they're meaningless in presentations. What do you do?

Build a summary page where you can see meaningful charts i.e., a dashboard. You're now in the world of data visualization!

Prior to Excel 2010 data visualization was a clumsy, formula-driven affair. In 2010 Excel developers gave us easy ways to create summaries and data visualization. Excel 2013 gave us a few more tools that promote ease and increased accuracy.

Check out the interactive dashboard that's embedded in this webpage: Sriracha Smackdown Results
The interactivity makes for even cleaner visualizations because users can adjust the controls for what they want to see; saving you from having to create multiple elements.

It's all Excel.
No coding.
No 3rd-party apps.
Easy to do! The greater challenge is in the collection and layout of the raw data. We will cover that in the workshop.

Unfortunately, the data visualization features in this workshop aren't available in Excel for Mac. But Mac users are invited to attend since this session is primarily a demo.

Prior to the workshop, students are invited to send requests, questions and sample data to ensure that your needs are integrated into the workshop.

Minimum age

All ages welcome

Prerequisites

An interest in building dashboards in Excel. This course is primarily a demonstration for those who spend a lot of time in Excel and want to see what's possible. You should have at least some familiarity with Excel.
Absolute beginners may be freaked out.

Location