NOTICEWe're upgrading our learning platform. You may notice temporary changes or brief interruptions while the migration is completed. Thank you for your patience! For any urgent query, contact info@learndrive.org
NEWThe Complete AI Skills Bundle 2026 — 9 courses, 9 CPD certificates, one price. Explore the bundle →
IT

Microsoft Excel Complete Training 2026

Master the latest Excel 2026 features with our comprehensive online course. From basics to advanced charts, pivot tables, and data analysis, elevate your Excel skills for professional growth.

Learning time
81 lessons
Format
Online, self-paced
Short video lessons
Access period
Lifetime
Last audited
10th May 2026
Accreditation CPDQE-accredited CPD course

Overview

Step into the world of data mastery with our "Microsoft Excel Complete Training 2026" course. This comprehensive online program is tailored for both Excel novices and seasoned users looking to update their skills with the latest features of Excel 2026. The course is not just about learning functionalities; it’s a gateway to unlocking the full potential of Excel, turning data into insightful, actionable information. Whether for personal growth or professional development, mastering Excel with this course will elevate your analytical capabilities and productivity.

Begin your journey with the essentials of Excel, laying a strong foundation even if you're starting from scratch. Then, delve into the heart of Excel with its essential functions and the powerful XLOOKUP feature exclusive to Excel 2021 and Office 365. As you progress, you'll discover the art of data formatting, creating sophisticated tables, and managing large datasets with ease. Pivot Tables and Charts come next, where you'll learn to summarize and analyze data effectively, a crucial skill in any data-driven environment.

Suitable for

You will need

  • A device with an internet connection

Course content

81 lessons

Getting Started 6 lessons
  • Introduction
  • Course Curriculum
  • Getting started on Windows, macOS, Android, and IOS
  • How to ask great questions
  • FAQ’s
  • Starting Excel
Excel Basics 7 lessons
  • Introduction
  • Worksheet basics
  • Entering values and formulas
  • Data formats
  • Data handling basics – cut copy and paste
  • Save and print in excel
  • Excel Ranges
Excel essential functions 12 lessons
  • Introduction
  • Basic formula operations
  • Mathematical functions level1
  • Mathematical functions level2
  • Text functions level1
  • Text functions level2
  • Logical functions
  • V Lookup formula
  • HLookup formula
  • HLookup Match formula
  • Match Index formula
  • Care for a Feedback
XLOOKUP only for Excel 2021 and Office 365 4 lessons
  • Introduction
  • XLookup
  • Handling NA and Approximates match in XLookup
  • Wildcard matching in XLookup
Get Data and tools 7 lessons
  • Introduction
  • Split Text into columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Get – import Data from Text
  • Get – import Data from CSV
Formatting data and tables 6 lessons
  • Introduction
  • Formatting Font
  • Formatting Alignment
  • Formatting Number
  • Formatting Date
  • Formatting tables
Pivot Tables 7 lessons
  • Introduction
  • Creating Pivot Table
  • Value field settings
  • Number format
  • Pivot Table Design
  • Excel Exercise
  • Solution for Excel Exercise
Excel Charts 11 lessons
  • Introduction
  • Excel Charts – Categories
  • Elements of a chart
  • Easy way to create charts
  • Column or Bar charts
  • Formatting charts
  • Line charts
  • Area charts
  • Pie and Doughnut charts
  • Format Area Plot or XY chart
  • Scatter or bubble charts
Advanced Excel charts 6 lessons
  • Introduction
  • Frequency Distribution and Histograms
  • Waterfall charts
  • Hierarchy charts sunburst and tree map
  • Combination charts
  • Sparklines
Pivot Charts 1 lesson
  • Pivot charts
Maps Chart above 2019 2 lessons
  • Maps chart
  • 3D Maps chart
Business-Geo charts 5 lessons
  • Introduction
  • Stock charts
  • Radar charts
  • Surface charts
  • Heat maps
Named Ranges 2 lessons
  • Named ranges – dropdown
  • Indirect Name range Function
Import Data into Excel 2 lessons
  • Import Data table from PDF file – Excel 2021
  • Import Data from Website – Excel 2019 above
Advanced Excel 2 lessons
  • Project Sales forecast tracker
  • Product Sale Tax invoice Tax Calculations
Order Your Transcript 1 lesson
  • Order Your Transcript

How the course works

  1. Get access

    After payment, the course appears in your LearnDrive dashboard.

  2. Learn at your pace

    Work through 81 short video lessons in one sitting or several.

  3. Complete the assessment

    Attend the assessment and secure 70% to pass the assessment test.

  4. Get your documents

    Download the PDF document(s) included in your package.

Certificate and accreditation

Sample certificate

What you receive

A digital Certificate of Completion (PDF) for this CPDQE-accredited course.

What the accreditation means

CPDQE accredits this course for continuing professional development (CPD). CPD accreditation is not a regulated qualification and does not by itself confirm job competence.

Checking a certificate

Anyone can check a certificate code on the LearnDrive certificate verification page.

What each package includes

Document Package 1 · £20.00 Package 2 · £29.00
Course access Lifetime access Lifetime access
Certificate of Completion (PDF) Included Included
Transcript (PDF) Not included Included
Enrolment Letter (PDF) Not included Included

Course provider

LearnDrive Courses

LearnDrive is a UK-based online learning provider run by Edtech Learning Ltd. Courses are built by an in-house instructional design team using short video and audio modules.

About LearnDrive

Reviews

Reviews for this course

No reviews for this course yet

Reviews appear here when learners who completed this course leave one.

Reviews of LearnDrive

Rated 4.8/5 on Reed, Udemy & Google

See all LearnDrive reviews

Frequently asked questions

When can I start after paying?

Straight away. Access is given as soon as your payment is processed, and the course appears in your dashboard.

How long can I access the course?

For life. Once you have enrolled, the course stays in your dashboard and you can come back to it whenever you like.

Do I need any prior knowledge?

No. The course starts from the basics, so you can begin without any previous experience of the topic.

Is there an assessment, and can I retake it?

Yes. There is a short assessment at the end and you need 70% to pass. If you do not pass first time, you can retake it.

Which documents does each package include?

It depends on the package you choose. The "What each package includes" table on this page shows exactly which PDF documents come with each one.

Are there extra costs for printed documents or delivery?

Your package includes digital PDF documents. If you would like printed copies, contact us and we will tell you the options and any costs.

What is the refund policy?

You can request a refund within 14 days of purchase. We follow a no-questions-asked refund policy.

How do I use a voucher?

Go to the voucher redemption page, enter your details and paste your voucher code (do not type it manually), then click Send. Your login details arrive by email and the course will be waiting in your dashboard.

How do I get help?

Our support team is happy to help. Get in touch through the contact page or call +44 7897 721446.

View all FAQs

Training a team?

LearnDrive offers training for businesses. Ask about options for enrolling your staff.

Team training enquiry

Taking several courses?

A LearnDrive membership includes access to the full course library.

Compare memberships

Ready to start Microsoft Excel Complete Training 2026?

Selected: Course Access + Certificate of Completion (PDF) · £20.00

Change package