Click here to send this to a colleague or friend.

Killer Excel Dashboard Reports

For Microsoft Excel


Microsoft Office version 2010, 2013 and 2016


This isn't Excel - it's magic!

Do your reports take a lot of work for you to update each period? And a lot of work for your readers to understand? Your Excel reports don't have to be that way. Not only can you create reports that are easy to update, you can make them much easier to read.

Excel dashboard reports act like the dashboard of your car – they present business information in a way that's easy to read and easy to understand. If you want to know how to create Excel reports like these - or if you want standard reports that are easier to create, easier to update, and easier to read - then this is going to be one of the most valuable workshops you've attended.

With the help of just a few simple techniques, Excel offers significant power to generate high-quality, low-maintenance management reports, including dashboards. For example, it is possible to report sales, cash flow, headcounts, competitor performance, customer survey results and economic data…all in the same report.

Dashboard Reports serve as business intelligence; a business early warning system. Giving managers a high-level overview of the business and the ability to make quick decisions. Because we can change our Excel reports quickly, we can respond to managers' changing information needs.

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

Certiport MOS - Microsoft® Office Specialist

Front Foot will manage registration, purchase of exam and facilitate testing

FRONT FOOT IS AN EME

- 100% RECOGNITION

shadow
shadow
Register now for this workshop
WHAT WILL BE COVERED ON THIS ONE-DAY WORKSHOP?

The Excel Window Components

Advanced Chart Creation

  • Inserting a Chart
  • The Chart Formula
  • Changing the Chart Type
  • Adding and Removing Data
  • Changing Chart Options
  • Changing the Chart Location
  • Copy a Chart
  • Add a Secondary Axis
  • Accommodating extreme values
  • Chart alignment
Advanced Chart Formatting
  • Reformat the Chart
  • Changing Colours
  • Axis Formatting
  • Manage Chart Labels

Dashboard Reports

  • Creating the Dashboard
  • Keyboard shortcuts
shadow

Supporting Skills for Dashboard Creation

  • Absolute References
  • Working with Ranges
  • The MAX and MIN Functions
  • The NA Function
  • The IF Function
  • The ISERROR Function
  • The OFFSET Function
  • The CHOOSE Function
  • Importing Information
  • Linking Programs
The Excel Camera Tool
  • Add the Camera Tool to a Toolbar
  • Use the Camera Tool
  • Manipulate the Camera Object
  • Assign a Range to the Camera Object
  • Display a Dynamic List in a Camera Object
Creating Traffic Lights
shadow shadow

Who should attend?

  • Marketing Managers
  • Sales Managers
  • Financial Managers
  • Chief Information Officers
  • Business Analysts
  • Personal Assistants
  • Anyone who wants to produce more impressive and useful Excel charts

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.

shadow
Front Foot courses are compiled and presented by subject matter experts
and industry specialists to ensure the highest and most current standard of excellence in all our workshops and training.
Event Information:
Date: 16th May 2018 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

6th June 2018 at Benvenuto Conference Centre in Randburg

12th July 2018 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

6th August 2018 at Benvenuto Conference Centre in Randburg

06th August 2018 at Benvenuto Conference Centre in Randburg

6th September 2018 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

15th October 2018 at Benvenuto Conference Centre in Randburg

14th November 2018 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

5th December 2018 at Benvenuto Conference Centre in Randburg

Map: View map
Duration: 1 Day
Cost: R2 350.00 excl VAT
R2 705.50 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://www.frontfoot.co.za
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