Date
October 28, 2021
COURSE DELIVERY
Virtual
START TIME
9.30am
PRINT-FRIENDLY VERSION
Download PDF

Course Description

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 a comprehensive course pack as a reference;gain valuable CPD points; 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

·     Pivot Tables

·     Tables

·     Charts

·     Functions

·     Conditional Formatting

·     Sparklines

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.

Certification

On completion of this one-day training course, you will receive your CMG MasterClass Certificate of Attendance. Please note certificates are issued at the close of the training course to participants on completion of the course. You will also receive a full course pack to refer back to at any time in the future. Please check directly with your association or awarding body to see how many points they will award

Cost

An ‘Early Bird’ discounted rate of €425 is currently available. This training course normal rate is€525. Places are limited and are allocated on a first come first served basis.

The course cost includes all course documentation, Training Course pack and Certificates.

Tutor

Kelly Meegan
KM Consultancy Services

Recommended for you

People who booked this course also attended: