← Back to All Courses
Online CPD Course

Microsoft Excel Advanced

Develop advanced Microsoft Excel skills for complex data analysis, reporting and improved spreadsheet productivity.

1 course 8 CPD hours 365 days access Verifiable certificate
Course Price
£19.99
Curriculum

Course Details

CPD212-IAA-012

Microsoft Excel Advanced

480 minutes 8 CPD hours Advanced English 80% pass mark
Course Description
This professional online CPD course develops advanced Microsoft Excel capability. It covers advanced formulas, lookup functions, PivotTables, PivotCharts, data analysis, dashboards, error handling, data protection and automation awareness. Learners will understand how advanced Excel features support informed decision-making and efficient business reporting.
Learning Outcomes
  • Use advanced formulas and lookup functions to analyse data.
  • Create and manage PivotTables and PivotCharts.
  • Build structured reports and dashboards from workplace data.
  • Apply error handling and data-quality controls appropriately.
  • Protect worksheets and sensitive spreadsheet information.
  • Recognise opportunities to improve efficiency through automation and advanced Excel tools.
  • Successfully complete the end-of-course knowledge assessment.
Study online Access course materials through your secure learner account and continue from your recorded progress.
Complete the assessment Your final score and completion result are retained within your learning record.
Record your achievement Successful completion is added to your CPD transcript with access to a verifiable certificate.