Step by Step Instructions for Easy EXCEL Dashboards

Step by Step Instructions for Easy EXCEL Dashboards
By David Wetton

x

Introduction to Pivot Tables, Charts, and Dashboards in Excel

By Jon Acampora of  ExcelCampus.com

Part 1
How to create an interactive dashboard using Pivot Tables and Pivot Charts.
Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac

Download file used in the video



Part 2
In this video I explain some of the different pivot table calculation types. Learn how to calculate the average, count, sum, and percentage of total. I explain how to update your pivot table with more data, and also how to refresh your pivot tables.

The video contains a lot of Excel tips, like how to quickly make a duplicate copy of a sheet, how to select the visible cells only, and a lot of useful keyboard shortcuts.

Download file used in the video




Part 3
This is part 3 in the series on Pivot Tables and Dashboards. In this video we bring it all together to create the interactive dashboard.

You will learn how to:
- Group dates into months and years to create a time series trend chart.
- Group amounts to create a distribution (histogram) chart.
- Add slicers to your pivot tables and charts to make them interactive.
- Lots of tips and shortcuts for formatting your charts.

Download file used in the video