Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
If you have ever wondered how colleagues or friends create amazing looking graphs and charts in Excel, or how those dashboards and charts update automatically when new data is added, or how they included interactive elements so you can choose what you see, then this 1-hour Excel class is for you!
In this Excel masterclass on how to use Excel, Excel expert Deb Ashby will be looking at:
- Building dashboards using PivotTables and PivotCharts
- Creating a beautiful looking dashboard with some top, Excel design tips
- Adding interactive elements like Slicers
- How to make your Pivot Charts and graphs display exactly what you want using filters and slicers
- How to link your graphs and charts to a single slicer
Download the accompanying exercise files here
Once again this was a brilliant live session. Interactive dashboards in Excel are excellent ways of displaying your data. Not only do they bring to life the story you are trying to tell with your numbers but they also make you look amazing at Excel and they are not that hard.
We’d recommend that you watch these two Excel training classes before taking this one as this is an advanced Excel tutorial and assumes some prior knowledge:
Other Excel classes you might like:
- Introduction to Power Pivot & Power Query in Excel
- What-If Analysis in Excel
- Designing Better Spreadsheets in Excel
- VLOOKUP for Dummies
Take a look at more recorded live classes from Simon Sez IT.
Adam Lacey
Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats.When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.
