Click here to send this to a colleague or friend.
Killer Excel Dashboard Reports - Advanced

Microsoft Office version 2010, 2013 and 2016

Attendance on the Killer Excel Dashboard Reports workshop is a pre-requisite to this advanced session.

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.


Register now for this workshop
shadow

Accreditation:

Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act.



Our Microsoft workshop presenters are Microsoft Certified Trainers and Microsoft Certified Technology Specialists


Front Foot is a Majority Black-Owned Level 2 EME – 125% Recognition

shadow
ONE DAY WORKSHOP OUTLINE
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.
We will design and use interactive dashboards as well as provide links to sample files and presentations.
We learn 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.
shadow 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
Event Information:
Date: 22nd January 2019 at Birchwood Hotel & OR Tambo Conference Centre

14th February 2019 at Benvenuto Conference Centre in Randburg

12th March 2019 at Birchwood Hotel & OR Tambo Conference Centre

Map: View map
Duration: 1 Day
Cost: R2 500.00 excl VAT
R2 875.00 incl VAT
Surcharge: Strict Halaal and Kosher meals carry an additional surcharge

Upcoming Events:
Visit our events calendar for more information.

Upcoming Workshops: Visit our workshops calendar for more information.
shadow
Discount:

10% discount for two or more delegates

10% discount if you attend two or more workshops

15% discount for four or more delegates


In-house at your offices
25%
discount for 5 or more delegates

30% discount for 8 or more delegates

35% discount for 10 or more delegates

We provide laptops for in-house computer-based training sessions

shadow

Bookings:

Contact Adele on
011 867 7299 or email

Bookings and Enquiries
Website | Email

Screenshot: http://images.frontfoot.com
shadow
Microsoft workshop presenters are Certified Microsoft Office Specialists
We offer on-going email support after attending any Microsoft workshop for an unlimited period of time

Workbooks and workshops are aligned to the prevailing Unit Standard;
Front Foot provide business training to business people;
Training is held at premium training venues
 
© Copyright Front Foot 2014. All rights reserved.
If you wouldn't like to receive any more news and information about Killer Excel Dashboard Reports - Advanced then please Click Here and we'll remove you from the send list immediately
Confidentiality Note: This message is for the sole use of the intended recipient(s) and may contain confidential and legally privileged information. Any unauthorised review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by replying and destroy all copies of the original message.