Excellent Excel Dashboards

Measuring change adoption validates the job you've done, and Excel is your friend. ​Most important! All this great stuff is taught from a change project perspective. It will be easier to understand as you'll be able to relate to the outcomes so much more easily.

​

Learn how to create interactive dashboards that dynamically updates. They must be clear, concise and visually attractive. Enhance them with infographics or link directly to your PowerPoint deck.

 PIVOT TABLES 

Need some quick stats? You need pivot tables.

​

If you've avoided these before our patient straight forward training will guide you through step-by-step and dig deeper.

​

We'll show you Pivot percentages, slicers and pivot table pages, you'll be producing powerful data summaries in minutes.

​You'll group, calculate, sort and sum. 

Slice, dice and present, inlcuding charts.

Plenty of "OMG how did I not know this before" moments.

nly what you need and present it where you need it.

AGGREGATING 

How many? How much?

​Go beyond basic pivot tables and learn how to pinpoint the figures you need to report with countifs and sumifs. Aggregate data across multiple columns with multiple criteria.

Here's how you find out exactly how many people from customer service department didn't attend which training on which day!

​

Essential for collating survey results.

 DASHBOARDS 

Add in some drop-down combo boxes and write one tiny macro.

​Add in your PowerPoint infographics skills and you have all the tools you need to create Powerful, attractive dashboard.

​

Giving you the skills, and the templates so you can quickly and easily produce change data magic!

This is a fast paced course, crammed with information, hacks and work-arounds. We'll send you the recording afterwards so you can go through step-by-step at your own pace.