Excel Dashboards - Online Training Course - CPDUK Certified -

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.

Download Full Course Description (PDF

Excel Dashboards - Online Training Course - CPDUK Accredited.