This one-day training course is for those with experience in Excel who want to create a visual display of their data using Dashboards. Consolidated and arranged on a single screen, Dashboards created in Excel can be interactive and dynamically updated as needed.

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.

All attendees will receive comprehensive course notes as a reference; and have a chance to engage in an informative Q&A on the day.

Places are limited to 12 delegates to ensure sufficient tutor/delegate interaction – Prompt booking is advised.

You will learn how to:

Create a Dynamic Excel Dashboard using:

• Tables
• PivotTables
• Pivot Charts
• Sparklines
• Functions
  • IF, TEXT, CHAR, GETPIVOTDATA, IFERROR‍‍

‍No Excel Add-ins or Visual Basic for Applications (VBA) used

Who Should Attend?

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.

Prerequisites

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

Certification

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.

This course may qualify for CPD points. Please check directly with your association or awarding body to see how many points they will award.

Cost

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. PLEASE NOTE THE EARLY BIRD RATE CLOSES 3 WEEKS PRIOR TO COURSE DATE. The course cost includes all course documentation and Certificate of Attendance.