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.
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.
Dates
- 24 May 2023 – 1 Day
- 18 October 2023 – 1 Day
- 11 December 2023 – 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.
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