Data Analytics and Dashboard Development using Excel Course
This course runs over 3 days, from 09:30-16:30 with 3 live interactive, instructor led training sessions.
This Masterclass programme gives the attendees the knowledge to use the advanced features of Excel to generate dynamic reports that will help inform the user make better informed business decisions. 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.
What this course covers:
- Understanding data and your audience
- Applying good Data Visualisation
- Extract, transform and load data
- How to analyse large data sets using Pivot Tables
- How to develop a dynamic dashboard using Excel
All topics are supported by hand-on exercises to reinforce learning and retention.
The course is aimed at:
- Management Accountants
- Marketing and Sales Managers
- Business Analysts
- Operational Managers
Request Registration Form: