Excel Dashboards - Online Training Course - CPDUK Certified -
The Mandatory Training Group
Delivery Method: eLearning
Excel Dashboards – Online Training Course - CPDUK Accredited.
Welcome to The Mandatory Training Group's online Excel Dashboards training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).
Excel Dashboards
Teacher - Barbara Evers
Learner - Kayla Chase
Take your Excel skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data. This online Excel Dashboards training course will help you become the master of creating and managing dashboards that are very useful for any organisation.
Course content
This online Excel Dashboard training course covers the following:
Unit 1: Creating range names
Unit 2: Using defined names in a formula
Unit 3: Using specialised functions - Part 1
Unit 4: Using specialised functions - Part 2
Unit 5: Applying data validation
Unit 6: Using a data form
Unit 7: Adding form controls
Unit 8: Using lookup functions
Unit 9: Combining functions
Unit 10: Creating a chart
Unit 11: Formatting and modifying charts
Unit 12: Dual axis charts
Unit 13: Forecasting with trend lines
Unit 14: Creating chart templates
Unit 15: Creating sparklines
Unit 16: Inserting pivot tables
Unit 17: Analysing pivot table data - Part 1
Unit 18: Analysing pivot table data - Part 2
Unit 19: Presenting data with pivot charts
Unit 20: Filtering data with slicers.
Who is the course for?
This online Excel Dashboards training course is suitable for Excel users who want to use advanced Excel features to turn massive amounts of data into visual, customisable dashboards.
Our Excel Dashboards online course will show you how to use advanced Excel features to turn massive amounts of data into visual, customisable dashboards.
Course aims
This Excel Dashboards e-learning course aims to:
Help you acquire skills needed to use forms, lookup functions, charts, PivotTables, and slicers to turn data into answers
Demonstrate how to use advanced Excel features to turn massive amounts of data into visual, customisable dashboards.
Learning objectives
On completion of this Excel Dashboards eLearning course, the learner will be able to:
Use range names in formulas
Create nested functions
Work with forms, form controls, and data validation
Use lookup functions
Combine multiple functions
Create, modify, and format charts
Use sparklines, trendlines, and dual-axis charts
Create a PivotTable and analyse PivotTable data
Present data with PivotCharts
Filter data with slicers.
Learning outcomes
Once you have completed this online Excel Dashboards training course, the learner will be able to:
Describe how to use advanced Excel features to turn massive amounts of data into visual, customisable dashboards
Use sparklines, trendlines, and dual-axis charts
Work with forms, form controls, and data validation.