Categories

Our Workshops

Killer Excel Dashboard Reports - Advanced

Microsoft Office Suite

Description

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.

Data Extraction

  • Advanced Filters
  • Database Functions
  • MATCH and INDEX

Advanced Charting Techniques

  • Waterfall Charts
  • Gauge Charts

Adding Interactivity to Charts

  • INDEX
  • VLOOKUP
  • OFFSET
  • Spin buttons and Scroll bars

PivotTable Components

  • PivotCharts
  • Slicers

________________________________________________________________________________________________________________________________________________________________

On-Site Workshops

  • All workshops are offered in-house at your offices to a minimum of 5 delegates
  • You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions

 Remote Workshops

  • All workshops are offered remotely to a minimum of 5 delegates
  • Front Foot supply all the electronic workshop material

________________________________________________________________________________________________________________________________________________________________

Workshop Dates