+353 1 279 0020 and +353 86 2471404sales@olas.ie Olas: Professional, Direct, Clever & Helpful

Dashboards and Data Visualisation in Microsoft Excel


The objective of this course is to allow the attendee to acquire the necessary skills and knowledge to create engaging and visual summary sheets and dashboards using Microsoft Excel.

Full Day Course Price: €600 per person

Click here to view the upcoming Virtual Live Training 1.5 hour session schedule.

To book onto a Virtual Live Training 1.5 hour session, or series of sessions, please click here.


Book a place on this course and pay with your credit card.

  • 24 May 2023 – 1 Day
  • 18 October 2023 – 1 Day
  • 11 December 2023 – 1 Day


This course is aimed at experienced Excel users who need to create and manipulate complex data and convert it into professional, concise and visual dashboards.


Participants should be experienced users of Excel.  They should be able to create, edit and manipulate spreadsheets containing formulae and functions.  They should be able to create a basic chart and pivot table.  Ideally they will have completed an Excel Introduction and / or Excel Intermediate course.

Course Outline
Click here to download course oultline

What is Data Visualisation?
How can we use Microsoft Excel?
What is a Dashboard?

Model Design and Dashboard Best Practice
Efficient Spreadsheet Design
Design Dashboards
Tips and tricks

Conditional Formatting
Using pre-defined scales and bars
Using pre-defined icons
Adding new rules
Editing rules
Conditional Formatting with Functions

Multiple Sheets / Files
Review Multiple Sheets
Grouping Sheets
Linking Sheets

Advanced Charts
Review of Creating a Chart
Advanced Chart Options

Advanced Formatting
Adding Trend lines
User Defined Charts
Choosing the correct chart for your data

Spreadsheet Database Features
Advanced Filtering and Sorting
Database and Lookup Functions
Pivot Tables Review – Creating and Updating the Table, Changing the Table Structure,
Creating Grouping Options
Pivot Table Options
On / Off Subtotals
Calculated Items
Showing / Hiding Fields

Data Validation
Limiting Entries into a Cell
Creating a Dropdown List
Data Validation and Functions

Other tools available

Course Summary and Review

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.