Download the exercise files and follow along here: ️https://www.simonsezit.com/article/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

Get a FREE 2.4 hour Excel 2019 Beginners course here:
️https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg

Pivot Table Tutorials for Beginners here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i80FzwXA86zJOK8dtlB-qt

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up ;-)