Join us for a demonstration on the mechanics of using Pivot Tables as the basis for a dashboard.
Key topics-
Preparing the Data for the Dashboard
- Using an Excel Table as source data for a dashboard – how to configure the data.
- Build multiple pivot tables out of the raw data which will ‘feed’ the relevant information into the dashboard.
Building the Dashboard elements
- Create Pivot Charts from the Pivot Tables.
- Create textboxes to display key totals/metrics from the Pivot Tables.
- Create Slicers to enable the Dashboard to be filtered.
Finalising the Dashboard
- Tips on arranging the Dashboard.
- Formatting the Dashboard.
- Add a Refresh button.
Speaker- Niamh Loftus
https://www.linkedin.com/in/niamhloftus/
Niamh has over 22 years of training experience and in addition to training services, is a developer of bespoke Excel and Power BI solutions, working with clients to get the most out of their data.
Email: training@smartskills.ie