
Microsoft Excel Complete Course - for Beginner, Intermediate & Advanced (Updated 2025)
12 Courses Bundle + 12 Free CPD Certificates | 300+ Video Training | 120 CPD Points | Lifetime Access
Training Express Ltd
Summary
- Hard copy certificate - Free
- PDF Certificates - Free
- Reed Courses Certificate of Completion - Free
- QLS Endorsed Certificate - £89
- Tutor is available to students
Add to basket or enquire
Overview
[Updated 2025, Watch Free Preview]
Special Deal: Get 47% OFF + FREE PDF & Hardcopy Certificates + Free Microsoft Excel 2021 Course, MS Word, PowerPoint & Access, and more...
Microsoft Excel Complete Course - for Beginner, Intermediate & Advanced- CPD Certified and Quality Licence Scheme QLS Endorsed.
Did you know over 800 million people have Microsoft Excel on their computers, but most don't know how to use it! This might be because Microsoft Excel can come across as being a little awkward with first-time users. Enrol in this Level 3 CPD accredited course to use Microsoft Excel confidently and get to a point where using Excel will be as natural as rolling out of bed in the morning.
Microsoft Excel training is a must in the modern-day workplace. So many jobs require you to have Microsoft Excel skills, and proficiency in it will make you a better candidate for any job position. Our course will give you a complete grasp of Microsoft Excel to enhance your professional career.
Microsoft Excel is much more than just a simple tool for data management and calculation. It is a demanding business tool for most firms. Learning Microsoft Excel can open up a world of possibilities for you. Our course is designed by experts in such a way that it will benefit both beginners and advanced learners. You will learn from top to bottom about Microsoft Excel and get ahead of your competitors. If you are looking for a Microsoft Office Specialist Excel certification course, then all you need to know is entirely about Microsoft Excel from scratch. So what are you waiting for?
Enrol in the Microsoft Excel course today!
Working knowledge of Microsoft Excel is vital for most office-based professionals today, and stronger skills can open the door to jobs, promotions, and leadership opportunities.
Key Features of Microsoft Excel
- CPD Accredited Microsoft Excel Course
- QLS Endorsed Level 5
- Instant e-certificate
- Fully online, interactive course with audio voiceover
- Developed by qualified professionals
- 300+ unique lessons in the Microsoft Excel course
- Self-paced learning and laptop, tablet, smartphone-friendly
- 24/7 Learning Assistance
Learning Outcomes of Microsoft Excel
- What is Microsoft Excel, and how to get started
- Examine spreadsheet concepts and explore the Microsoft Office Excel environment.
- Learn to enter and edit data
- Learn to adjust a worksheet and workbook
- Learn to use maths, statistics, logic and text functions in Microsoft Excel
- Learn to be a better, stronger and faster Excel user
- Learn to use functions and formulas
- Understand how to capture your first job as a Microsoft Excel expert
- Create and edit charts
- Tips for starting a successful career
Achievement
Certificates
Hard copy certificate
Hard copy certificate - Included
PDF Certificates
Digital certificate - Included
Reed Courses Certificate of Completion
Digital certificate - Included
Will be downloadable when all lectures have been completed.
QLS Endorsed Certificate
Hard copy certificate - £89
CPD
Curriculum
-
Workbook 09:00
-
Microsoft Excel 2019 New Features 27:34
-
Getting Started with Microsoft Office Excel 1:13:36
-
Performing Calculations 49:21
-
Modifying a Worksheet 25:59
-
Formatting a Worksheet 1:02:43
-
Printing Workbooks 26:24
-
Managing Workbooks 17:33
-
Working with Functions 1:12:33
-
Working with Lists 37:47
-
Analyzing Data 12:33
-
Visualizing Data with Charts 38:03
-
Using PivotTables and PivotCharts 44:25
-
Working with Multiple Worksheets and Workbooks 24:00
-
Using Lookup Functions and Formula Auditing 30:28
-
Sharing and Protecting Workbooks 28:02
-
Automating Workbook Functionality 35:27
-
Creating Sparklines and Mapping Data 14:31
-
Forecasting Data 30:54
-
Excel VBA Data Management 2:04:00
-
Excel 2021 4:12:22
-
Course 02: New Functions in Microsoft Excel 2021 Course 1:14:02
-
Course 03: Microsoft Word 2019 4:40:20
-
Course 04: Microsoft PowerPoint 2019 5:17:55
-
Course 05: Microsoft Access 2019 3:46:41
-
Course 06: Accountancy 1:56:08
-
Course 07: Job Search Skills 1:19:40
-
Course 08: Resilience Training 1:51:58
-
Course 09: Supervisor Training 2:12:54
-
Course 10: Leadership & Management Diploma 7:29:24
-
Course 11: Organisational Skills Course for Administrator 43:23
-
Resources – Microsoft Excel Complete Course 02:00
Course media
Description
Microsoft Excel Curriculum Details;
Workbook
1: Microsoft Excel Complete Course
Microsoft Excel 2019 New Features
2: Course Promo Video
3: Introduction to Microsoft Excel 2019 New Features
4: CONCAT
5: IFS
6: MAXIFS
7: MINIFS
8: SWITCH
9: TEXTJOIN
10: Map Chart
11: Funnel Chart
12: Better Visuals
13: Pivot Table Enhancements
14: Power Pivot Updates
Getting Started with Microsoft Excel
15: Navigate the Excel User Interface
16: Use Excel Commands
17: Create and Save a Basic Workbook
18: Enter Cell Data
19: Use Excel Help
Performing Calculations
20: Create Worksheet Formulas
21: Insert Functions
22: Reuse Formulas and Functions
Modifying a Microsoft Excel Worksheet
23: Insert, Delete, and Adjust Cells, Columns, and Rows
24: Search for and Replace Data
25: Use Proofing and Research Tools
Formatting a Microsoft Excel Worksheet
26: Apply Text Formats
27: Apply Number Format
28: Align Cell Contents
29: Apply Styles and Themes
30: Apply Basic Conditional Formatting
31: Create and Use Templates
Printing Microsoft Excel Workbooks
32: Preview and Print a Workbook
33: Set Up the Page Layout
34: Configure Headers and Footers
Managing Microsoft Excel Workbooks
35: Manage Worksheets
36: Manage Workbook and Worksheet Views
37: Manage Workbook Properties
Working with Microsoft Excel Functions
38: Work with Ranges
39: Use Specialized Functions
40: Work with Logical Functions
41: Work with Date & Time Functions
42: Work with Text Functions
Working with Lists
43: Sort Data
44: Filter Data
45: Query Data with Database Functions
46: Outline and Subtotal Data
Analyzing Data in Microsoft Excel
47: Apply Intermediate Conditional Formatting
48: Apply Advanced Conditional Formatting
Visualizing Data with Charts
49: Create Charts
50: Modify and Format Charts
51: Use Advanced Chart Features
Using PivotTables and PivotCharts
52: Create a PivotTable
53: Analyze PivotTable Data
54: Present Data with PivotCharts
55: Filter Data by Using Timelines and Slicers
Working with Multiple Worksheets and Workbooks
56: Use Links and External References
57: Use 3-D References
58: Consolidate Data
Using Lookup Functions and Formula Auditing
59: Use Lookup Functions
60: Trace Cells
61: Watch and Evaluate Formulas
Sharing and Protecting Workbooks
62: Collaborate on a Workbook
63: Protect Worksheets and Workbooks
Automating Workbook Functionality
64: Apply Data Validation
65: Search for Invalid Data and Formulas with Errors
66: Work with Macros
Creating Sparklines and Mapping Data
67: Create Sparklines
68: Map Data
Forecasting Data with Microsoft Excel
69: Forecasting Data Determine Potential Outcomes Using Data Tables
70: Determine Potential Outcomes Using Scenarios
71: Use the Goal Seek Feature
72: Forecasting Data Trends
73: CPD Certificate & Transcript
Microsoft Excel VBA Data Management
74: 01. Create a Macro Using the Macro Recorder
75: 02. Edit a Macro
76: 03. Debug a Macro
77: 04. Customize the Quick Access Toolbar and Hotkeys
78: 05. Set Macro Security
79: 06. Insert Text
80: 07. Format Text
81: 08. Sort Data
82: 09. Duplicate Data
83: 10. Generate a Report
84: 11. Determine the Dialog Box Type
85: 12. Capture User Input
86: 13. Insert, Copy, and Delete Worksheets
87: 14. Rename Worksheets
88: 15. Modify the Order of Worksheets
89: 16. Print Worksheets
90: 17. Create User-Defined Functions
91: 18. Automate SUM Functions
92: Activities and Exercise Files – Microsoft Excel 2016 and VBA
Microsoft Excel 2021
93: Excel Overview
94: Start Excel Spreadsheet
95: Enter Text and Numbers
96: Relative References
97: Working with Ranges
98: Save and Save As Actions
99: File Extensions, Share, Export, and Publish Files
100: Adding Rows and Columns
101: Modifying Rows and Column Lengths
102: Copy, Cut, and Paste
103: Copying Formulas
104: Page Setup Options
105: Fit to Print on One Page
106: Print Workbooks
107: Sorting Data Ascending Order
108: Sorting Data Descending Order
109: Filter Data
110: Basic Formula Operations
111: Date/Time Functions
112: Mathematical Functions Phase 1
113: Mathematical Functions Phase 2
114: V Lookup Formula
115: HLookup Formula
116: XLookup
117: Handling NA and Approximate Matches in XLookup
118: Split Text into Columns
119: Flash Fill
120: Data Validation
121: Remove Duplicates
122: Get - Import Data from Text
123: Get - Import Data from CSV
124: Formatting Font
125: Formatting Alignment
126: Formatting Number
127: Formatting Date
128: Formatting Tables
129: Creating Pivot Table
130: Pivot Charts
131: Excel Charts – Categories
132: Elements of a Chart
133: Creating Charts
134: Column or Bar Charts
135: Formatting Charts
136: Line Charts
137: Pie and Doughnut Charts
New Functions in Microsoft Excel 2021
138: Introduction and Agenda
139: RANDARRAY
140: UNIQUE
141: SEQUENCE
142: SORT and SORTBY
143: SORT A Practical Example
144: FILTER
145: FILTER A Practical Example
146: Other Useful New Functions
147: Using the New Functions in Reports
Certificate
After completing this Microsoft Excel 2019 course, you will get a Free PDF certificate from Reed. Also, you will be awarded a FREE CPD Accredited PDF Certificate from Training Express.
Besides, you can get your Microsoft Excel QLS Endorsed Level 5 certificate for £89 only.
Who is this course for?
This Microsoft Excel 2019 is suitable for:
- Administrator
- Accounts Administrator
- HR Administrator
- Accountant/Bookkeeper
- Office Administrator
- Warehouse Operatives
- Audio Typist
- Audio Secretary
- Anyone looking for Microsoft Office Specialist Excel Certification
Requirements
Microsoft Excel Training
No formal qualification is required for this Microsoft Excel Online course.
Career path
- Client Service Support
- Payroll Officer
- Data Analyst
- Business Analysts
- Data Journalists
Questions and answers
Is it suitable for complete beginners? I have no excel knowledge.
Answer:Dear Deborah, Yes, this course is suitable for a complete beginner. Thank you
This was helpful.Hi, Is there a timeframe to complete the course, once started?
Answer:Hi Victoria, Thank you for your query. No, there is no specific timeframe to complete the course. You will have lifetime access to the course, allowing you to complete it at your convenience.
This was helpful.In the certification, will there be any place that says cpd certified or the cpd logo or somthing that gives its validity
Answer:Hi T, Yes, the CPD accredited logo will be on the certificate to prove that it's accredited by the CPD.
This was helpful.
Reviews
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.