Skip to content
  1. Online
  2. Office skills
  3. Microsoft
  4. Microsoft Excel
Microsoft Excel Complete Course - Beginner To Professional (Updated 2025) cover image

Microsoft Excel Complete Course - Beginner To Professional (Updated 2025)
Janets

Updated in June 2025 | 5-in-1 CPD Approved Video Training | 60 CPD Points | FREE Certificates | Lifetime Access

Summary

Price
Save 17%
£19 inc VAT (was £23)
Offer ends 05 June 2026
Study method
Online, On Demand 
Duration
30.7 hours · Self-paced
Qualification
No formal qualification
CPD
50 CPD hours / points
CPD What's this?
Certificates
  • CPD Certified Hardcopy Certificate - Free
  • CPD Certified Certificate of Completion - Free
  • Reed Courses Certificate of Completion - Free
Additional info
  • Tutor is available to students
10,451 students purchased this course

Add to basket or enquire

Overview

(Updated in June 2025)

Over 1.2 billion people worldwide use Microsoft Excel across various industries. This just gets to show why you master MS Excel NOW!

Mastering Microsoft Excel is crucial in today’s data-driven world, where precision and efficiency can make all the difference. Without a firm grasp of Microsoft Excel capabilities, tasks become arduous, errors creep in, and productivity plummets. The importance of Microsoft Excel extends far beyond mere number crunching; it’s a powerful tool that can transform raw data into meaningful insights, streamline complex processes, and elevate your professional skill set.

If you don’t want the tangled web of numbers and data to leave you feeling frustrated and overwhelmed, then this Microsoft Excel course is what you need. Our Microsoft Excel course start with the basics, learning about the interface, values, references, and formulas. Progressing through customising worksheets, cell formatting, and creating data visualisations with charts, you'll also delve into managing datasets, using database functions, and data validation.

Advanced Microsoft Excel topics include PivotTables, PowerPivot, conditional and lookup functions, text-based functions, and formula auditing. You'll explore Excel's What If analysis tools, the fundamentals of VBA, writing code, creating loops, activating macros, and designing user forms. This extensive curriculum ensures you gain a thorough understanding and practical skills in Excel.

Take control of your data management skills and elevate your career prospects. Enrol today to master Microsoft Excel, Office Management, Administration, IT, Project Management and Leadership & Management which will make you an indispensable asset in any data-driven role!

Learning Outcomes:

By the end of this course, you will be able to:

  • Navigate and utilise the Microsoft Excel interface efficiently for diverse tasks.
  • Implement various values, references, and formulas to streamline Microsoft Excel tasks.
  • Apply different types of functions to enhance Microsoft Excel spreadsheet functionality.
  • Customise Microsoft Excel worksheets to suit specific data presentation needs.
  • Use advanced cell formatting techniques for better data visualisation.
  • Insert and manipulate images and shapes within Microsoft Excel worksheets.
  • Create compelling data visualisations using Microsoft Excel charting tools.
  • Manage Microsoft Excel datasets and employ database functions effectively.
  • Use Microsoft Excel PivotTables and PowerPivot to analyse large datasets.
  • Write and debug VBA code for automating Microsoft Excel tasks and processes.

What You Get Out Of Studying the Course:

  • Free PDF certificates upon successful completion of the course
  • Lifetime access to course materials
  • Study the course at your own pace
  • Accessible, informative modules taught by expert Microsoft Excel instructors
  • Get 24/7 help or advice from our email and live chat teams
  • Improve your chance of gaining valuable skills and better earning potential by completing the course

Certificates

CPD

50 CPD hours / points
Accredited by CPD Quality Standards

Curriculum

36
sections
192
lectures
30h 41m
total

    • 1: What is Microsoft Excel? 04:16
    • 2: Who This Course is For 03:30
    • 3: Microsoft Excel Marketplace 04:08
    • 4: Microsoft Excel Job Opportunities 02:43
    • 5: Microsoft Excel Job Types 03:51

    • 6: Resource Files 01:00

    • 7: Finding & Opening Microsoft Excel 01:04
    • 8: Excel's Start Screen 03:15
    • 9: Explaining the Excel Interface 02:43
    • 10: Excel Interface Continued 01:25
    • 11: Excel Workbook vs Excel Worksheet 02:12
    • 12: Customising the Excel Quick Access Toolbar 02:15
    • 13: Customising the Excel Ribbon 03:03
    • 14: Excel Shortcut Keys 01:43

    • 15: Creating Excel Labels 02:32
    • 16: Entering Numeric Values in Excel 03:25
    • 17: Formatting Date Values in Excel 05:19
    • 18: Building Basic Formulas in Excel 04:43
    • 19: Order of Operations 06:27
    • 20: Relative vs Absolute Cell References 07:23

    • 21: Excel Functions Explained 02:34
    • 22: The SUM() Function 07:31
    • 23: The MIN() & MAX() Function 03:43
    • 24: The AVERAGE() Function 02:00
    • 25: COUNT() Functions 04:57

    • 26: Moving & Copying Data 06:45
    • 27: Insert & Delete Rows/Columns 05:04
    • 28: Adjusting the Width & Height of Cells 04:34
    • 29: Hiding and Unhiding Excel Rows and Columns 04:28
    • 30: Renaming, Moving & Deleting Excel Worksheets 05:27
    • 31: Adding Protection to Specific Cells 04:23
    • 32: Protecting the Structure of a Workbook 02:11
    • 33: Adding a Workbook Password to Open File 02:09

    • 34: Formatting Fonts and Cell Background Color 04:54
    • 35: Adding Cell Borders 04:47
    • 36: Formatting Data Appropriately 05:20
    • 37: The Magic behind Excel's Format Painter 03:29
    • 38: Creating Styles for Formatting Efficiency 05:55
    • 39: Merging Cells for a Cleaner Look 03:26
    • 40: The Power of Conditional Formatting 06:09

    • 41: Grab User’s Attention using Illustrations 08:38
    • 42: Customising Icons 04:41
    • 43: Create Compelling Graphics with SmartArt 05:36

    • 44: The Commonly used Column Chart 02:45
    • 45: Changing the Chart Design 01:58
    • 46: Formatting Elements of a Chart 06:23
    • 47: Modifying the Data, Type & Location of a Chart 06:06
    • 48: Little Slice of Pie Charts 05:11

    • 49: Print Preview Options 04:25
    • 50: Excel's Page Layout View 06:36
    • 51: Printing a Specific Range of Cells 02:38
    • 52: Converting Spreadsheets to PDF Files 02:28

    • 53: Why Create an Excel Template 01:22
    • 54: How to Create an Excel Template 05:22

    • 55: How to Prepare Data for Analysis 04:00
    • 56: How to Sort Data in Excel 02:37
    • 57: Multi-Level Sorting 02:33
    • 58: Custom Sorting Datasets in Excel 02:26
    • 59: Applying Filters to Datasets 04:44
    • 60: Creating Subtotals within a Dataset 05:38
    • 61: Converting Datasets into Tables 05:55
    • 62: Finding & Removing Duplicate Values 07:29

    • 63: The SUMIF() Function 08:41
    • 64: The DSUM() Function 07:47
    • 65: DSUM() Function Continued 07:06
    • 66: The SUBTOTAL() Function 06:28

    • 67: What is Excel Data Validation? 01:55
    • 68: Creating a Drop Down List with Data Validation 07:08
    • 69: Different Types of Excel Data Validation 05:39
    • 70: Adding Custom Alerts to Data Validation 06:53
    • 71: Creating a Dynamic Drop Down List 03:09
    • 72: Complex Validation: Dependent Drop Down List 08:38

    • 73: Creating an Excel Pivot Table 05:30
    • 74: Modifying Excel PivotTables 05:38
    • 75: Grouping & Filtering PivotTable Data 06:29
    • 76: Drilling Down into PivotTable Data 01:59
    • 77: Creating Pivot Charts & Utilising Slicers 07:59

    • 78: What is PowerPivot? 03:45
    • 79: Activating the Excel PowerPivot Add-In 01:33
    • 80: Creating Relationships between Data Tables 06:22
    • 81: Using Data Models to Create PivotTables 04:30
    • 82: How to Create PowerPivot KPI’s 08:26

    • 83: Excel’s IF() Function 05:16
    • 84: IF() Function with AND() Criteria 05:23
    • 85: IF() Function with OR() Criteria 05:13
    • 86: Nesting Multiple IF() Functions 07:23
    • 87: The COUNTIF() Function 04:06
    • 88: Key Benefits of Named Ranges 04:10

    • 89: VLOOKUP() Function 08:59
    • 90: The Beauty of Excel’s IFERROR() Function 03:55
    • 91: HLOOKUP() Function 06:21
    • 92: INDEX() Function 04:42
    • 93: MATCH() Function 04:55
    • 94: INDEX() and MATCH() Combined 05:08
    • 95: Two-Way Lookup with INDEX() and MATCH() 04:09

    • 96: LEFT(), RIGHT() and MID() Function 07:08
    • 97: Extracting Specific Text using LEN() & SEARCH() 12:44
    • 98: Combining Text with CONCATENATE() 06:05
    • 99: Quick Tips & Other Text Based Functions 05:48

    • 100: Tracing Precedents & Dependents in Formulas 04:27
    • 101: Showing Formulas 01:53
    • 102: Grouping Data 02:42
    • 103: 3D Referencing in Formulas 05:04
    • 104: Utilising the Watch Window in Excel 02:44
    • 105: How to Freeze Panes in Excel 02:55

    • 106: Excel’s Scenario Manager Tool 05:55
    • 107: Goal Seek in Excel 06:15
    • 108: Compare Results with Excel Data Tables 04:23
    • 109: Solver Tool 10:59

    • 110: The Power Behind Excel VBA 02:35
    • 111: A Look Inside the Visual Basic Editor (VBE) 03:56
    • 112: Recording a Macro 09:11
    • 113: Saving & Opening a Macro-Enabled Workbook 02:13

    • 114: Modules and Procedures 06:33
    • 115: Objects, Methods and Properties 05:58
    • 116: Excel VBA Variables 04:38

    • 117: Referencing a Range 13:30
    • 118: InputBox & MsgBox 05:32
    • 119: Using Variables in VBA Code 04:32
    • 120: If Then Else Statement 10:22
    • 121: Worksheet Functions inside VBA 07:32
    • 122: Creating User Defined Functions 09:18
    • 123: User Defined Functions within VBA Scripts 06:08

    • 124: Find Last Row of Data 05:45
    • 125: Find Last Column of Data 03:12
    • 126: With Statement 04:51
    • 127: Debugging & Error Handling 06:36
    • 128: Debugging & Error Handling Continued 06:44

    • 129: For Next Loop 09:12
    • 130: Do Until Loop 06:03
    • 131: For Each Loop 03:36

    • 132: Assigning Macros to Shapes 03:32
    • 133: Form Controls vs ActiveX Controls 07:50
    • 134: Worksheet Events 03:43
    • 135: Workbook Events 02:54
    • 136: Fun with VBA Events 06:54

    • 137: Creating an Excel UserForm 03:15
    • 138: Adding Controls to UserForms 10:00
    • 139: How to Show an UserForm 03:01
    • 140: Passing TextBox Values to Desired Cells 06:36
    • 141: Passing Option Buttons to Desired Cells 06:50
    • 142: UserForm ComboBoxes 08:08
    • 143: Clearing Values from UserForm Controls 03:06
    • 144: How to Close an UserForm 01:33
    • 145: UserForms and Protected Sheets 04:40

    • 146: Creating an Excel Resume 04:51
    • 147: Getting Started with Freelancing 06:15
    • 148: How to Become an Excel Freelancer 05:12
    • 149: Top Freelance Websites 05:12
    • 150: How to Get Your First Client 07:45
    • 151: Personal Branding 06:47
    • 152: Networking Do's and Don'ts 04:21
    • 153: Importance of Having a Website 04:24

    • 154: Resource Files 01:00

    • 155: Module 01 - Personal Assistant / Executive Assistant 49:09
    • 156: Module 02 - Providing Administrative Support 37:58
    • 157: Module 03 - Using Organisational Skills 44:51
    • 158: Module 04 - Professional Telephone Etiquette 44:30
    • 159: Module 05 - Business Writing Skills 51:34
    • 160: Module 06 - Time Efficiency Strategies 49:36
    • 161: Module 07 - Body Language and Communication Skills 44:47
    • 162: Module 08 - Managing Meetings Efficiently 1:02:24

    • 163: Module 01 - An Overview of IT Support Technician 14:44
    • 164: Module 02 - Essentials of Computer Hardware and Software 10:24
    • 165: Module 03 - What are Networking Fundamentals 15:27
    • 166: Module 04 - Fundamentals of System Administration 36:05
    • 167: Module 05 - Resolving Software and Hardware Problems 29:17

    • 168: Module 01 - What is Leadership 30:52
    • 169: Module 02 - Leadership and Motivation 21:22
    • 170: Module 03 - Goal Setting and Time Management 48:36
    • 171: Module 04 - Effective Communication and Body Language 43:33
    • 172: Module 05 - Assertiveness and Self-Esteem 38:26
    • 173: Module 06 - Corporate Behaviour and Business Management 44:03
    • 174: Module 07 - Efficient Meeting Management 1:01:25
    • 175: Module 08 - Essentials of Project Management 45:01
    • 176: Module 09 - Principles of Risk Management 17:16
    • 177: Module 10 - Team Building and Collaboration 31:24
    • 178: Module 11 - Managing Performance 36:33
    • 179: Module 12 - Critical Thinking for Leaders 30:53

    • 180: Module 01 - Fundamentals of Accounting 08:38
    • 181: Module 02 - The Role and Functions of an Accountant 09:14
    • 182: Module 03 - Accounting Principles and Standards 12:36
    • 183: Module 04 - Double-Entry Accounting System 12:05
    • 184: Module 05 - Overview of the Balance Sheet 11:37
    • 185: Module 06 - Analysis of the Income Statement 10:38
    • 186: Module 07 - Dealing with Financial Statements 13:36
    • 187: Module 08 - Dealing with Cash Flow Statements 09:40
    • 188: Module 09 - Interpreting the Profit and Loss Statement 09:50
    • 189: Module 10 - Financial Planning and Budgeting 14:56
    • 190: Module 11 - Basics of Auditing 08:54

    • 191: Order Your Certificate 01:00

    • 192: Leave a Review 01:00

Description

The Microsoft Excel course is designed to equip learners with comprehensive skills in Microsoft Excel, starting from the basics and progressing to advanced functionalities. Participants will become proficient in navigating the Microsoft Excel interface, working with values, references, and formulas, and utilising various functions.

The course covers essential techniques such as customising worksheets, cell formatting, inserting images, and creating data visualisations with charts. Learners will master managing datasets, using database functions, data validation, and the powerful PivotTables and PowerPivot add-in.

Moreover, the Training covers advanced topics which include conditional functions, lookup functions, text-based functions, auditing formulas, and What If analysis tools. You will also be introduced to Excel VBA, teaching the basics of the VBA language, writing code, creating loops, and activating macros.

Lastly, learners will also design user forms and understand how to leverage Microsoft Excel skills for career advancement. This practical training ensures that participants can confidently apply Microsoft Excel capabilities to enhance productivity and efficiency in various professional settings!

Curriculum Breakdown

Microsoft Excel Practical Training from Beginner to Intermediate to Advanced

  • Section 01 - Introduction to Microsoft Excel
  • Section 02 - The Microsoft Excel Interface
  • Section 03 - Working with Values, References, and Formulas
  • Section 04 - The Different Types of Functions in Excel
  • Section 05 - Customising Excel Worksheets
  • Section 06 - Cell Formatting Techniques
  • Section 07 - Inserting Images and Shapes in Excel
  • Section 08 - Creating Data Visualisations with Charts
  • Section 09 - Excel Printing Settings and Options
  • Section 10 - Using Excel Templates
  • Section 11 - Managing Excel Datasets
  • Section 12 - Using Excel Database Functions
  • Section 13 - Using Excel Data Validation
  • Section 14 - Using Excel PivotTables
  • Section 15 - Using Excel PowerPivot Add-In
  • Section 16 - Using Excel Conditional Functions
  • Section 17 - Using Excel Lookup Functions
  • Section 18 - Text-Based Functions in Excel
  • Section 19 - Auditing Formulas & Custom Views in Excel
  • Section 20 - Exploring Excel “What If” Analysis Tools
  • Section 21 - What is Excel VBA
  • Section 22 - Understanding the VBA Language
  • Section 23 - Writing Code in VBA
  • Section 24 - Tools and Logic in VBA
  • Section 25 - Creating Loops in Excel VBA
  • Section 26 - Activating Macros in Excel
  • Section 27 - Designing User Forms in Excel
  • Section 28 - Building a Career with Excel Skills

Course 02: Office Management and Administration

  • Module 01 - Personal Assistant / Executive Assistant
  • Module 02 - Providing Administrative Support
  • Module 03 - Using Organisational Skills
  • Module 04 - Professional Telephone Etiquette
  • Module 05 - Business Writing Skills
  • Module 06 - Time Efficiency Strategies
  • Module 07 - Body Language and Communication Skills
  • Module 08 - Managing Meetings Efficiently

Course 03: IT Support Technician

  • Module 01 - An Overview of IT Support Technician
  • Module 02 - Essentials of Computer Hardware and Software
  • Module 03 - What are Networking Fundamentals
  • Module 04 - Fundamentals of System Administration
  • Module 05 - Resolving Software and Hardware Problems

Course 04: Leadership & Management

  • Module 01 - What is Leadership
  • Module 02 - Leadership and Motivation
  • Module 03 - Goal Setting and Time Management
  • Module 04 - Effective Communication and Body Language
  • Module 05 - Assertiveness and Self-Esteem
  • Module 06 - Corporate Behaviour and Business Management
  • Module 07 - Efficient Meeting Management
  • Module 08 - Essentials of Project Management
  • Module 09 - Principles of Risk Management
  • Module 10 - Team Building and Collaboration
  • Module 11 - Managing Performance
  • Module 12 - Critical Thinking for Leaders

Course 05: Accountancy/Accounting & Finance

  • Module 01 - Fundamentals of Accounting
  • Module 02 - The Role and Functions of an Accountant
  • Module 03 - Accounting Principles and Standards
  • Module 04 - Double-Entry Accounting System
  • Module 05 - Overview of the Balance Sheet
  • Module 06 - Analysis of the Income Statement
  • Module 07 - Dealing with Financial Statements
  • Module 08 - Dealing with Cash Flow Statements
  • Module 09 - Interpreting the Profit and Loss Statement
  • Module 10 - Financial Planning and Budgeting
  • Module 11 - Basics of Auditing

-------- Microsoft Excel Certification --------

How can you earn your Certification?

After successfully completing the Microsoft Excel course, you will get your Reed Certificate instantly! And to order your CPD QS Certificate, you will need to fill in the form given in the Curriculum Section. And by 24 hours, you will get your CPD QS Certificate.

Who is this course for?

This course is designed for:

  • Business professionals aiming to enhance their data management and analysis skills using Microsoft Excel.
  • Students looking to improve their proficiency in Microsoft Excel for academic projects.
  • Administrative staff seeking to streamline their daily tasks using Microsoft Excel.
  • Financial analysts who want to leverage Microsoft Excel for detailed financial modelling.
  • Entrepreneurs interested in using Microsoft Excel for better business planning and forecasting.

Requirements

The course is open to all students and has no formal entry requirements.

Career path

This course opens doors to many job and career opportunities. Here are a few career you can opt:

  • Data Analyst
  • Financial Analyst
  • Business Intelligence Analyst
  • Project Manager
  • Operations Manager
  • Administrative Assistant
  • Accountant

Questions and answers

Reviews

4.2
Course rating
85%
Service
82%
Content
86%
Value

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft 365 courses, Management courses, Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.