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: € 495 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.
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.
What is Data Visualisation?
How can we use Microsoft Excel?
What is a Dashboard?
Model Design and Dashboard Best Practice
Efficient Spreadsheet Design
Tips and tricks
Using pre-defined scales and bars
Using pre-defined icons
Adding new rules
Conditional Formatting with Functions
Multiple Sheets / Files
Review Multiple Sheets
Review of Creating a Chart
Advanced Chart Options
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
Showing / Hiding Fields
Limiting Entries into a Cell
Creating a Dropdown List
Data Validation and Functions
Other tools available
Course Summary and Review