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 for This Course

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

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.

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.

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

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

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.

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.