00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

Dashboards and Data Visualisation in Microsoft Excel

 

Description

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.

Price: € 395 per person

Dates

  • Book a place on this course and pay with your credit card.15 February 2018 , 1 Day
  • Book a place on this course and pay with your credit card.24 April 2018 , 1 Day
  • Book a place on this course and pay with your credit card.11 June 2018 , 1 Day
  • Book a place on this course and pay with your credit card.23 August 2018 , 1 Day
  • Book a place on this course and pay with your credit card.04 October 2018 , 1 Day
  • Book a place on this course and pay with your credit card.19 December 2018 , 1 Day

TARGET AUDIENCE

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.

PRE-REQUISITES

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
Protection

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.