Microsoft Excel - An Introduction to Data Visualisation

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