The term “dashboard” is a buzzword in the world of Excel and in businesses today. A dashboard report is a management tool that measures and presents critical data on the key business performance areas in a summarised manner much like a car dashboard, so management can quickly respond with appropriate decisions.
Dashboards enable the reader to make sense of the raw numbers by presenting them in visually rich charts and tables and give valuable insights into the key performance indicators of the business.
The course covers an introduction into some of the lesser known charting techniques along with advanced tools and functions of Excel.
(The course will be of benefit to anyone using Excel 2007 onwards, however, it is recommended to be running at least Excel 2013 when following the course for optimum experience.)
By the end of this course, participants will obtain a greater understanding of:
- Creative techniques in overall design, functionality, and capability.
- Making vital areas of the dashboard dynamic and interactive using some of the more advanced Excel tools and functions.
- Organisation of the file data and its calculations
- Core design principles
- Making the best type choice
- Double-axis charts, enhancement tools
- Further charting techniques
- Speedometer chart
- Categories and labelling
Authored by: Pratish Sharma
With 20 years of experience in building information systems for businesses, Pratish Sharma helps organisations around Europe to improve their technical skills and streamline data processes. He also presents courses on a variety of technical subjects based on industry trends. This includes helping people to save time and resource in analysing large volumes of data and translate their findings into flexible dashboard solutions that anyone can use to gain data insight.
CPD Points: 1
CPD Duration (hours): 1
Access: 12 months from purchase date