Self-Paced Online learning
24/7 Online Support
14 days Money Back Guarantee
Fully Accredited Courses

Advanced Diploma in MS Excel

4.9

(572 students)
Last updated:May 19, 2025
Language:English

Advanced Diploma in MS Excel

4.9

(572 students)
qls-logo cpd-logo cpd-logo ukrlp-logo iphm-logo

Rated Excellent on

google-logo

This online course includes 21 sections and 42 concise video lessons. It focuses specifically on the updates introduced in Excel 2019—from advanced functions like TEXTJOIN, IFS, SWITCH, and MAXIFS to new chart types and enhanced pivot table features.

Throughout the course, you will:

  • Explore and apply new Excel 2019 formulas for smarter data analysis
  • Learn improved ways to join, compare, and conditionally summarise data
  • Use new visual tools like map charts, funnel charts, and better visuals
  • Discover updates to Power Pivot and pivot tables for deeper insights
  • Improve productivity and accuracy with Excel’s latest features

By the end of the Microsoft Excel 2019 New Features course, you will be able to:

  • Understand and apply new Excel 2019 functions: CONCAT, IFS, TEXTJOIN, SWITCH, MAXIFS, MINIFS
  • Create professional reports using new chart types including map and funnel charts
  • Leverage Power Pivot and pivot table enhancements for smarter data summaries
  • Improve visual appeal and clarity in spreadsheets with enhanced formatting tools
  • Gain a CPD-accredited certificate recognised by employers and organisations across the UK

The Microsoft Excel 2019 New Features course is built for busy professionals and learners who want to upgrade their spreadsheet skills with minimal time investment and maximum impact.

You’ll benefit from:

  • CPD-certified training focused on real Excel 2019 improvements
  • Bite-sized video tutorials for fast and effective learning
  • Lifetime access on mobile, tablet, and desktop
  • A competitive edge in data-driven roles and job applications

The Microsoft Excel 2019 New Features course is ideal for:

  • Office professionals and administrators
  • Data entry specialists and finance assistants
  • Managers and team leaders working with reports and KPIs
  • Business owners and freelancers improving data handling
  • Anyone who wants to stay up to date with Excel

There are no formal entry requirements for this course. It is suitable for:

  • Excel users looking to upgrade to the 2019 version
  • Professionals wanting to refresh and expand their spreadsheet knowledge
  • Admin, finance, marketing, and HR staff working with data
  • Students and jobseekers aiming to boost employability

     

Upon completing the course and passing the final exam, you will receive a CPD QS Accredited Certificate from Apex Learning. This certification demonstrates your knowledge and skills as a nursing assistant in the UK. The Digital version of the certificate is available for £9.99 only, and you can order a hard copy of the certificate for £14.99 only.

Apex - CPD QS Certificate Image

Mastering Excel 2019 gives you a significant edge in data and admin-heavy roles. This course prepares you for job functions such as:

  • Data Analyst – £30,000 to £55,000 per year
    Use Excel’s latest tools to extract, analyse, and present data effectively.
  • Office Administrator – £24,000 to £35,000 per year
    Manage spreadsheets, reports, and performance data with ease.
  • Finance Assistant – £26,000 to £40,000 per year
    Handle budgeting, forecasting, and reporting using Excel functions.
  • Project Coordinator – £28,000 to £45,000 per year
    Track milestones, budgets, and updates in structured Excel dashboards.
  • Marketing Analyst – £30,000 to £48,000 per year
    Use Excel charts and data tools to evaluate campaign performance.

Microsoft Excel 2019 New Features | CPD Accredited Excel Training Online – UK

Microsoft Excel is a staple in every modern workplace, and staying updated with the latest features is essential for productivity and professional growth. The Microsoft Excel 2019 New Features course is a CPD-accredited online training programme designed to help you quickly master the most powerful new tools, formulas, and data visualisation options introduced in Excel 2019.

Whether you’re a professional working with data, a business owner managing reports, or a student building skills, this course ensures you stay ahead with the latest version of Excel used across the UK and beyond.

Course Overview

This online course includes 21 sections and 42 concise video lessons. It focuses specifically on the updates introduced in Excel 2019—from advanced functions like TEXTJOIN, IFS, SWITCH, and MAXIFS to new chart types and enhanced pivot table features.

Throughout the course, you will:

  • Explore and apply new Excel 2019 formulas for smarter data analysis
  • Learn improved ways to join, compare, and conditionally summarise data
  • Use new visual tools like map charts, funnel charts, and better visuals
  • Discover updates to Power Pivot and pivot tables for deeper insights
  • Improve productivity and accuracy with Excel’s latest features

Learning Outcomes

By the end of the Microsoft Excel 2019 New Features course, you will be able to:

  • Understand and apply new Excel 2019 functions: CONCAT, IFS, TEXTJOIN, SWITCH, MAXIFS, MINIFS
  • Create professional reports using new chart types including map and funnel charts
  • Leverage Power Pivot and pivot table enhancements for smarter data summaries
  • Improve visual appeal and clarity in spreadsheets with enhanced formatting tools
  • Gain a CPD-accredited certificate recognised by employers and organisations across the UK

Why Enrol in This Course?

The Microsoft Excel 2019 New Features course is built for busy professionals and learners who want to upgrade their spreadsheet skills with minimal time investment and maximum impact.

You’ll benefit from:

  • CPD-certified training focused on real Excel 2019 improvements
  • Bite-sized video tutorials for fast and effective learning
  • Lifetime access on mobile, tablet, and desktop
  • A competitive edge in data-driven roles and job applications

Who is This Course for?

The Microsoft Excel 2019 New Features course is ideal for:

  • Office professionals and administrators
  • Data entry specialists and finance assistants
  • Managers and team leaders working with reports and KPIs
  • Business owners and freelancers improving data handling
  • Anyone who wants to stay up to date with Excel

Prerequisites

There are no formal entry requirements for this course. It is suitable for:

  • Excel users looking to upgrade to the 2019 version
  • Professionals wanting to refresh and expand their spreadsheet knowledge
  • Admin, finance, marketing, and HR staff working with data
  • Students and jobseekers aiming to boost employability

Assessment Method

Assessment for the course is conducted through an automated multiple-choice exam. A score of 60% is required to pass and earn the CPD Accredited Certificate. Reflective assignments are provided to enhance your learning, with expert tutor feedback available.

Certification

Upon completing the course and passing the final exam, you will receive a CPD QS Accredited Certificate from Apex Learning. This certification demonstrates your knowledge and skills as a nursing assistant in the UK. The Digital version of the certificate is available for £9.99 only, and you can order a hard copy of the certificate for £14.99 only.

Apex - CPD QS Certificate Image

Endorsed Certificate from the Quality Licence Scheme

After successfully completing the course, learners will be able to order an endorsed certificate as proof of their new achievement. QLS Endorsed certificates can be ordered and get delivered to your home by post for £139 only . There is an additional £10 postage charge for international students.

QLS Certificate Homepage Section

Career Path

Mastering Excel 2019 gives you a significant edge in data and admin-heavy roles. This course prepares you for job functions such as:

  • Data Analyst – £30,000 to £55,000 per year
    Use Excel’s latest tools to extract, analyse, and present data effectively.
  • Office Administrator – £24,000 to £35,000 per year
    Manage spreadsheets, reports, and performance data with ease.
  • Finance Assistant – £26,000 to £40,000 per year
    Handle budgeting, forecasting, and reporting using Excel functions.
  • Project Coordinator – £28,000 to £45,000 per year
    Track milestones, budgets, and updates in structured Excel dashboards.
  • Marketing Analyst – £30,000 to £48,000 per year
    Use Excel charts and data tools to evaluate campaign performance.

Frequestly Asked Questions

 It’s a CPD-accredited online course that teaches the newest Excel 2019 formulas, chart types, and visual tools for workplace efficiency.

 Basic Excel knowledge is recommended, but no advanced skills are required.

 Yes. The CPD QS Accredited Certificate is widely accepted across UK industries.

Yes. Excel skills are highly sought after, and knowing the latest features gives you a competitive advantage.

 Click the Enrol Now button on our website for instant access.

Course Curriculum

  • 21 sections
  • 42 lectures
  • 00:00:00 total length
Expand all sections
  • video Introduction to Microsoft Excel 2019 New Features
    00:07:00
  • video CONCAT
    00:02:00
  • video IFS
    00:01:00
  • video MAXIFS
    00:01:00
  • video MINIFS
    00:01:00
  • video SWITCH
    00:02:00
  • video TEXTJOIN
    00:01:00
  • video Map Chart
    00:02:00
  • video Funnel Chart
    00:01:00
  • video Better Visuals
    00:06:00
  • video Pivot Table Enhancements
    00:02:00
  • video Power Pivot Updates
    00:01:00

Advanced Diploma in MS Excel

Save 95% - Sale Ends in

14 Days Money Back Guarantee

Frequently Bought Together

avatar

Complete Teaching Assistant Diploma Level 3 (TA, SEN, Autism, ADHD & Dyslexia)

£21.99

4.8

(1794 students)
avatar

Level 5 Diploma in Health and Social Care Management

£21.99

5

(1010 students)

4.9 course rating - 9 reviews

Advanced Diploma in MS Excel

£19.99

Regular Price

£419

Save 95% - Sale Ends in

14 Days Money Back Guarantee

This course includes:

  • Duration:
    22 hours, 14 minutes
  • Access:
    1 year access
  • Level:
  • CPD Points:
    10
× How can I help you?