Professional Development

Ultimate Microsoft Excel Course: Beginner to Excel Expert

From beginner to expert, this course will help you advance your career using Microsoft Excel skills.

Learning time
121 lessons
Format
Online, self-paced
Short video lessons
Access period
Lifetime
Last audited
26th April 2026
Accreditation CPDQE-accredited CPD course

Suitable for

You will need

  • A device with an internet connection

Course content

121 lessons

Section 1: Introduction 1 lesson
  • Introduction to the Ultimate Excel Course
Section 2: Working with Large Worksheets 5 lessons
  • Keeping your Headings Visible as you Scroll
  • Splitting a Worksheet to Reference Two Different Areas
  • Hiding and Unhiding Columns
  • Sorting a Large List – Including a Super Shortcut
  • Filtering a List – One of the Most Useful Excel Skills
Section 3: 5 Essential Tricks for Printing Spreadsheets 6 lessons
  • Scaling a Print to Fit onto Fewer Pages
  • Repeating your Headers Across Multiple P
  • Printing a Selected Range and Setting a
  • Aligning a Print on a Page
  • Using Page Breaks to Logically Break Up
  • Care for a Feedback
Section 4: Getting Started with Excel Formulas 8 lessons
  • Introduction to Formulas – Writing your First Exc
  • The Order Of Calculation-BODMAS
  • Calculating Percentages
  • Unleash the Power of Excel Functions
  • Referencing Other Sheets and Workbooks
  • Calculating Date Difference including Working Day
  • understand Absolute Cell Addresses
  • The COUNTIF Function-An Incredibly Useful Function
Section 5: Logical Functions: The Decision Making Formulas of Excel 7 lessons
  • IF Function 1
  • IF Function 2
  • IF Function 3
  • Nested IFS
  • AND and OR Functions
  • TNo More Nested IFS
  • The Switch Function
Section 6: Conditional Formatting – Make your Data Come to Life 8 lessons
  • Create your First Conditional Fo
  • Managing Multiple Rules
  • Highlight Expired And Due Dates
  • cc
  • Create a Heat Map
  • Using Icon Sets
  • Entire Row
  • Testing Multiple Conditions
Section 7: Dynamic Array Functions – Formulas Have Changed 6 lessons
  • Introduction to dynamic Arrays
  • The UNIQUE Function
  • The SORT Function
  • The SORTBY Function
  • The FILTER Function
  • The SEQUENCE Function
Section 8: Lookup Functions – The Powerful VLOOKUP Function and beyond 10 lessons
  • The VLOOKUP Function Expl
  • Using VLOOKUP for a Range
  • Advanced VLOOKUP
  • Handling Error Messages
  • The INDEX and MATCH Comb
  • INDEX and MATCH
  • Return Non Adjacent Column
  • XLOOKUP Function
  • Multi-Column Lookup
  • Two-Way Lookup
Section 9: Validating and Protecting Excel Data 8 lessons
  • Number Of Characters
  • Create Date Validation Rules
  • Drop Down Lists
  • Dependent Lists
  • Data Validation Messages
  • Encrypt a File
  • Protect Workbook
  • Protect Worksheet
Section 10: Advanced Formulas for Analysing Data 6 lessons
  • Using SUMIF, COUNTIF and AVERAGEIF
  • Summing the Values between Two Dates
  • Advanced Sum Formula with SUMPRODUCT
  • SUMPRODUCT Example 2
  • Secret AGGREGATE Function
  • Advanced AGGREGATE
Section 11: Charts – Simple and Effective Data Presentation 11 lessons
  • First-Charts
  • Chart-Elements
  • Formatting Charts
  • Modidy the Charts Axis
  • Chart Templates
  • Combo Charts
  • Chart-Filters
  • Interactive Charts
  • Using Cell Values for Chart Labels
  • Conditional-Formatting with Charts
  • Sparklines
Section 12: Manipulating Text in Excel 8 lessons
  • Splitting Text across Multiple Columns
  • Concat and Concatenate Functions
  • The TEXTJOIN Function
  • Extracting Text from a Cell
  • MID and FIND Functions
  • Value Function
  • Substitute Function
  • Flash Fill Tool
Section 13: Formatting your Data Ranges as Tables for Easier Management 5 lessons
  • Formatting as a Table
  • Benefits of Using Table
  • Creating Table Style
  • Formulas Using a Tables
  • Back to a Normal Range
Section 14: Master PivotTables for Powerful Analysis and Reporting 13 lessons
  • Creating a PivotTable
  • Values Function
  • Formatting Values
  • PivotTable Style
  • Sorting PivotTable
  • Grouping Data
  • Showing Values
  • Conditional Formatting
  • Filtering PivotTable Data
  • Refreshing a PivotTable
  • Creating a Pivotchart
  • Slicers
  • Timeline
Section 15: Getting and Transforming Data with Power Query 6 lessons
  • What is Power Query
  • Merge-Queries-2
  • Messy Data
  • Unpivot
  • Merge Queries-1
  • Combine and Append
Section 16: Working with the Data Model and PowerPivot 10 lessons
  • Introduction PowerPivot
  • Creating Relationships
  • Creating PivotTable
  • PowerPivot Adding
  • Setting Locales
  • PowerPivot Window
  • Calculated columns
  • Measures
  • Multiple Files From Folder
  • Importing Data From web
Bonus Materials 2 lessons
  • installing-power-query-add-in [Download]
  • ultimate-excel-course-exercises [Download]
Final Quiz: Ultimate Microsoft Excel Course: Beginner to Excel Expert 1 item
  • Final Quiz: Ultimate Microsoft Excel Course: Beginner to Excel Expert
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 121 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 · £9.99 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

How do I purchase a course?

To purchase a course, simply select the course you want, choose your plan from the top right side, and click on the ‘Take this course’ button to initiate the checkout process. You will receive access as soon as the payment is processed.

What payment methods do you accept?

We accept various payment methods, including credit/debit cards, PayPal, and bank transfer. If you don’t have a card or paypal, contact us for alternative payment methods.

What is your cancellation policy?

If you’re not satisfied with our course, you can request a refund within 14 days of purchase. We follow a no-questions-asked refund policy, and you will receive a full refund.

Will I receive a certificate after completing the course?

Yes, upon successful completion of the course and exam (if applicable), you will receive a free digital certificate that can be downloaded and printed.

Are your courses accredited?

Yes, our courses are CPDQE accredited. CPDQE is an independent body that accredits courses and events for continuous professional development, ensuring they meet high-quality standards.

How can I verify my certificate or certification code?

You can verify your certificate by visiting the Learndrive certificate verification page and entering your certification code. This will confirm the authenticity of your certificate.

How can I redeem a voucher or discount code?

To redeem your voucher, first visit the voucher redemption page. Enter your personal details and paste the voucher code into the designated field (do not type the code manually). After that, click the “Send” button. You will receive your login details via the email address you provided. Once you have received them, log in to our website and access your course from your dashboard.

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 Ultimate Microsoft Excel Course: Beginner to Excel Expert?

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

Change package