Create a Dynamic Excel Dashboard using
· Pivot Charts
IF, TEXT, CHAR, GETPIVOTDATA, IFERROR
No Excel Add-ins or Visual Basic for Applications (VBA) used
This course would be ideal for those who need to analyse data and present key trends and comparisons graphically, in a user-friendly way. It will also provide you with the knowledge and skills to produce engaging and interactive reports.
Ideally delegates should have completed the ‘Excel Introduction – Level 1’ course or be comfortable in applying the features and functions associated with the Level 1 course content.
Participants need to have a good working knowledge of Excel(Intermediate level or above).
Participants need to have Excel 2013 or later.
Participants need to have 2 screens to be able to design and build a Dashboard in parallel with the tutor.
Participants will need access to Windows
Participants will have to fill in a Pre-Course Evaluation which the tutor will review to make sure requirements are met for attendance
On completion of this one-day training course, you will receive your Certificate of Attendance. Please note certificates are issued at the close of the training course to participants on completion of the course. Please check directly with your association or awarding body to see how many points they will award.
An ‘Early Bird’ discounted rate of €485 is currently available. This training course normal rate is €585. Places are limited and are allocated on a first come first served basis.
The course cost includes all course documentation and Certificate of Attendance.