Front Foot Microsoft workshop presenters are Microsoft Certified Trainers as well as Microsoft Certified Technology Specialists
Attendance on the Killer Excel Dashboard Reports workshop is a pre-requisite to this advanced session
ONE DAY WORKSHOP
Do you often get in trouble while presenting your reports?
Presenting your reports in an effective style is the key to success.
Reports and dashboards are the most splendid technique to present your data.
Take your analytical skills to the next level and design world-class dashboards and advanced reports. This highly practical, hands-on workshop is specifically designed to strengthen your techniques for extracting data from a data source and reviews the methods of preparing the data for the charting process.
Bring more insight to your Dashboards with the sought after Waterfall and Gauge charts.
Waterfall Charts are great for showing the contribution of parts to a whole.
Gauge Charts show much more than one value. It gives the minimum, the maximum, the current value and above all at lightning speed how far from the maximum you are (in milliseconds, without deciphering figures)
This workshop demonstrates what interactive dashboards are, and how you can use dashboards to communicate important information to your audience.
Learn how to design and use interactive dashboards as well as provide links to sample files and presentations.
Techniques for extracting data from a data source and then review’s the methods of preparing the data for the charting process.
Adding interactivity to your charts allows you to explore different scenarios while presenting the data. Three different methods of adding interactivity are explored.
The use of PivotTable Charts and Slicers in the Dashboard rounds the course off.
Slicers are easy-to-use filtering components that contain a set of buttons that enable you to quickly filter the data in a PivotTable report, without the need to open drop-down lists to find the items that you want to filter.