Excel 2019 Intermediate

Overview

What You’ll Learn

Develop practical skills in linking worksheets and workbooks confidently

Apply advanced sorting, filtering, and conditional formatting techniques

Strengthen your ability to create and manage PivotTables and PivotCharts

Understand how to use tables for data organisation and analysis

Enhance decision-making through data visualisation and trend analysis

Use range names effectively to improve spreadsheet clarity

Apply ethical data handling and quality control in Excel projects

Build confidence in automating tasks with Excel features and tools

Overview

The Excel 2019 Intermediate course is a CPD-accredited, fully online programme designed for UK learners ready to enhance their Excel capabilities. It offers flexible study tailored to professionals seeking to deepen their data management and analysis skills. This course helps you progress beyond basics with practical knowledge relevant to UK workplaces.

As you advance through this course, you will develop greater responsibility and leadership in managing data efficiently. You will learn to apply Excel functions thoughtfully, improving your ability to make informed, ethical decisions within your role. The course aligns with sector expectations for quality and accuracy without implying regulatory compliance.

Learners typically include aspiring and practising professionals focused on improving their Excel skills for enhanced work effectiveness. The course supports you with flexible online study options and dedicated UK-based learner support, helping you build recognised, skills-focused credibility in your field.

Key Highlights:

Master intermediate Excel functions including PivotTables and conditional formatting
Enhance data analysis with expert use of charts, tables, and slicers
Flexible, self-paced online learning with 12 months’ access
CPD-accredited course valued by UK employers for skill development
Practical exercises that reinforce real-world Excel applications
Expert support from UK-based tutors experienced in workplace data use

Accreditation & Recognition

This Excel 2019 Intermediate is fully CPD-accredited, ensuring your qualification meets trusted professional standards for relevant fields. It is widely recognised by UK employers as a benchmark for continuing professional development and compliance training. Earn a CPD Accredited certificate to showcase your knowledge and skills

100% online, self-paced study with 12 months’ access
Includes online multiple-choice exam and optional reflective portfolio
Order a CPD-accredited digital certificate (optional printed version available for £24.99)
Recognised by UK employers and globally trusted certification

Assessment & Certification

Your progress in this Excel 2019 Intermediate is measured through an online multiple-choice assessment with a 60% pass mark and instant results. Learners can retake the exam for free, ensuring full understanding before completion. Upon passing, you can order a PDF version of the CPD Accredited certificate, verifying your learning achievement and continued professional development aligned with industry knowledge standards. You can also order a hardcopy certificate for £24.99 to boost your credibility and showcase your achievement. This qualification includes no hidden fees and is recognised by UK employers as evidence of structured learning and professional growth.

Who Is This Course For?

Aspiring professionals seeking to improve Excel data management skills
Office administrators and coordinators managing complex spreadsheets
Data analysts requiring enhanced Excel analytical techniques
Team leaders aiming to improve reporting and decision-making capabilities
Practising professionals wanting to develop practical Excel proficiency
Anyone responsible for data organisation and visualisation in the workplace

Career Opportunities & Progression

Data Analyst Assistant: £22,000 to £30,000 per year
Office Manager: £25,000 to £35,000 per year
Business Support Officer: £20,000 to £28,000 per year
Reporting Coordinator: £23,000 to £32,000 per year
Project Administrator: £24,000 to £34,000 per year
Junior Data Analyst: £21,000 to £29,000 per year

Key Skills You’ll Gain

Confidently linking and consolidating data across worksheets
Advanced sorting, filtering, and conditional formatting techniques
Creating and modifying PivotTables and PivotCharts effectively
Developing clear, actionable data visualisations and reports
Using range names and tables to improve spreadsheet clarity
Applying trend analysis and forecasting with Excel features
Managing data quality and ethical spreadsheet practices
Enhancing productivity through Excel automation tools

Why Study with Royal Open College

Royal Open College is a trusted CPD-accredited training provider dedicated to helping professionals build confidence, leadership, and compliance in the UK job sector. Our expert-led online courses are designed to fit around your lifestyle, giving you the flexibility to study anywhere, anytime. CPD-accredited and employer-recognised qualifications trusted across the UK

Expert tutors with essential real-world experience
100% online learning with UK-based learner support
Affordable, transparent pricing with no hidden fees
Trusted by thousands of UK learners and global professionals

Enrol today to build confidence and develop practical skills with the CPD-accredited Excel 2019 Intermediate, designed to strengthen your real-world understanding and data management capability.