Excel Dashboards - for sound business decisions
Leveraging Excel dashboards is a powerful way to consolidate vast amounts of data, findings and analysis into a condensed, executive summary view that will facilitate sound business decisions.
In this course, learn how to create an Excel dashboard that will illustrate how pay structures compare competitively to the market. Begin with an introduction to the concept of Excel dashboards, why they are useful and the basics needed to get started. Then, get hands-on experience in Excel as you follow along with the instructor to create the interactive executive dashboard. Hands-on tactical learning, relevant compensation scenarios, job aids and sample spreadsheets ensure you can use what you learn immediately at the office.
Improving the quality of decision making using Excel 2010
The biggest problem managers have is preparing monthly reports that assist in making better decisions.
We waste an inordinate amount of time preparing reports that provide very little usable information that will assist the organisation in making informed decisions.
This master class programme gives the attendees the knowledge to use the sophisticated features of Excel to generate reports that will inform the reader in a way that was not possible a few years ago
Microsoft has in its Excel application developed toolsets unmatched by any other application costing, many times more.
The course has been designed to give accountants, managers and persons, who have a monthly reporting responsibility,
the ability to develop professional reports that will assist in better decision making.
The course focuses on the advanced features of Microsoft Excel and Word 2010 to develop stunning reports that will inform the intended audience towards making better decisions.
What delegates will learn from this masterclass
The masterclass programme has been structured to provide the following benefits:
1. Understanding the taxonomy of how good decisions are made
2. How to determine the correct objects (which include tables, graphs and text) in structuring a good report
3. How we present information and numbers using Excels Chart Objects
4. How to import and clean large amounts of Data using Excel
5. How to develop an Excel GUI (Graphic User Interface) that will assist in simplifying
6. How to analyse large data sets using Pivot Tables
7. How to structure complex nested functions
8. How to develop a Dashboard using Excel
For more information Email: az.oc.gniniartsnoitulosrevlis@selas
Contact Details: Tel: (27) 11 051 8375 Fax + (27) 86 763 5620
Date: 9-10 March
Venue: Cape Town Lodge Cape Town
Contact Details: Tel: (27) 11 051 8375 Fax + (27) 86 763 5620
Email: az.oc.gniniartsnoitulosrevlis@selas
Time: 08:00 - 16:30
Venue: Cape Town Lodge, Cape Town
Cost: Enquire for investment