Advanced Diploma in Microsoft Excel
Last Updated:
09 June 2026
Number of Students:
1 Students
Accreditation:
CPD Accredited
Prerequisites:
No formal qualification required (Anyone can participate)
Course Rating:
4.8 out of 5
Key features of the Advanced Diploma in Microsoft Excel
- Recognised qualification upon successful completion of the course
- Study from anywhere, anytime, whenever it is convenient for you.
- Get 24/7 support from our Customer Success Team
- Affordable and engaging e-learning study materials
- Study at your own pace from a tablet, PC or smartphone
- Online tutor support when you are in need.
Who is this course for?
There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.
Requirements
Our Advanced Diploma in Microsoft Excel is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career Path
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
Course Curriculum
30 Sections | 155 Lessons
Excel from A-Z Course Intro
3m
Excel Job Opportunities
3m
Excel Job Types
4m
Microsoft Excel Marketplace
4m
Who is This Course For?
3m
Finding & Opening Excel
1m
Excel’s Start Screen
3m
Explaining the Excel Interface
3m
Excel Interface Continued
1m
Excel Workbook vs. Excel Worksheet
2m
Saving an Excel Document
4m
Customizing the Quick Access Toolbar
2m
Customizing the Excel Ribbon
3m
Excel Shortcut Keys
2m
Creating Excel Labels
3m
Entering Numeric Values in Excel
3m
Formatting Date Values in Excel
5m
Building Basic Formulas in Excel
5m
Order of Operations
6m
Relative vs. Absolute Cell References
7m
Excel Functions Explained
3m
The SUM() Function
8m
The MIN() & MAX() Function
4m
The AVERAGE() Function
2m
COUNT() Functions
5m
Moving & Copying Data
7m
Insert & Delete Rows and Columns
5m
Adjusting the Width and Height of Cells
5m
Hiding and Unhiding Excel Rows and Columns
4m
Renaming, Moving & Deleting Excel Worksheets
5m
Adding Protection to Specific Cells
4m
Protecting the Structure of a Workbook
2m
Adding a Workbook Password to Open File
2m
Formatting Fonts and Cell Background Color
5m
Adding Cell Borders
5m
Formatting Data Appropriately
5m
The Magic behind Excel's Format Painter
3m
Creating Styles for Formatting Efficiency
6m
Merging Cells for a Cleaner Look
3m
The Power of Conditional Formatting
6m
Grab User’s Attention using Illustrations
9m
Customizing Icons
5m
Create Compelling Graphics with SmartArt
6m
The Commonly Used Column Chart
3m
Changing the Chart Design.mp4
2m
Formatting Elements of a Chart
6m
Modifying the Data, Type & Location of a Chart
6m
Print Preview Options
4m
Excel's Page Layout View
7m
Printing a Specific Range of Cells
3m
Converting Spreadsheets to PDF Files
2m
Why Create an Excel Template
1m
How to Create an Excel Template
5m
How to Prepare Data for Analysis
4m
How to Sort Data in Excel
3m
Multi-Level Sorting
3m
Custom Sorting Datasets in Excel
2m
Applying Filters to Datasets
5m
Creating Subtotals within a Dataset
6m
Converting Datasets into Tables
6m
Little Slice of Pie Charts
5m
Finding & Removing Duplicate Values
7m
The SUMIF() Function
9m
The DSUM() Function
8m
The DSUM() Function Cont.
7m
The SUBTOTAL() Function
6m
What is Excel Data Validation?
2m
Creating a Drop Down List with Data Validation
7m
Different Types of Excel Data Validation
6m
Adding Custom Alerts to Data Validation
7m
Creating a Dynamic Drop Down List
3m
Complex Validation: Dependent Drop Down List!
9m
Creating an Excel Pivot Table
6m
Modifying Excel PivotTables
6m
Grouping & Filtering PivotTable Data
6m
Drilling Down into PivotTable Data
2m
Creating Pivot Charts & Utilizing Slicers
6m
What is PowerPivot?
4m
Activating the Excel PowerPivot Add-In
2m
Creating Relationships between Data Tables.mp4
6m
Using Data Models to Create PivotTables
5m
How to Create PowerPivot KPI’s
8m
Excels IF Function
5m
IF() Function with AND() Criteria
5m
IF() Function with OR() Criteria
5m
Nesting Multiple IF() Functions
7m
The COUNTIF() Function
4m
Key Benefits of Named Ranges
4m
VLOOKUP() Function
9m
The Beauty of Excel’s IFERROR() Function
4m
HLOOKUP() Function
6m
The INDEX Function
5m
MATCH() Function
5m
INDEX() and MATCH() Combined
5m
Two-Way Lookup with INDEX() and MATCH()
4m
LEFT(), RIGHT() and MID() Function
7m
Extracting Specific Text using LEN() & SEARCH()
13m
Combining Text with CONCATENATE()
6m
Quick Tips & Other Text Based Functions
6m
Tracing Precedents & Dependents in Formulas
4m
Showing Formulas
2m
Grouping Data
3m
3D Referencing in Formulas
5m
Utilizing the Watch Window in Excel
3m
How to Freeze Panes in Excel
3m
Excel’s Scenario Manager Tool
6m
Goal Seek in Excel
6m
Compare Results with Excel Data Tables
4m
Solver Tool
11m
The Power Behind Excel VBA
3m
A Look Inside the Visual Basic Editor (VBE)
4m
Recording a Macro
9m
Saving & Opening a Macro-Enabled Workbook
2m
Modules and Procedures
7m
Objects, Methods and Properties
6m
Excel VBA Variables
5m
Referencing a Range
13m
InputBox & MsgBox
6m
Using Variables in VBA Code
5m
If Then Else Statement
10m
Worksheet Functions inside VBA
8m
Creating User Defined Functions
9m
User Defined Functions within VBA Scripts
6m
Find Last Row of Data
6m
Find Last Column of Data
3m
With Statement
5m
Debugging & Error Handling
7m
Debugging & Error Handling Cont.
7m
For Next Loop
9m
Do Until Loop
6m
For Each Loop
4m
Assigning Macros to Shapes
4m
Form Controls vs ActiveX Controls
8m
Worksheet Events
4m
Workbook Events
3m
Fun with VBA Events!
7m
Creating an Excel UserForm
3m
Adding Controls to UserForms
10m
How to Show an UserForm
3m
Passing TextBox Values to Desired Cells
7m
Passing Option Buttons to Desired Cells
7m
UserForm ComboBoxes
8m
Clearing Values from UserForm Controls
3m
How to Close an UserForm
2m
UserForms and Protected Sheets
5m
Creating an Excel Resume
5m
Getting Started with Freelancing
6m
How to Become an Excel Freelancer
5m
Top Freelance Websites
5m
How to Get Your First Client
8m
Personal Branding
7m
Networking Do’s and Don’ts
4m
Importance of Having a Website
4m
Resources - Advanced Diploma in Microsoft Excel
Order Your Certificates or Transcripts
Course Reviews
No reviews yet.
Key features of the Advanced Diploma in Microsoft Excel
- Recognised qualification upon successful completion of the course
- Study from anywhere, anytime, whenever it is convenient for you.
- Get 24/7 support from our Customer Success Team
- Affordable and engaging e-learning study materials
- Study at your own pace from a tablet, PC or smartphone
- Online tutor support when you are in need.
Who is this course for?
There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.
Requirements
Our Advanced Diploma in Microsoft Excel is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career Path
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
30 Sections | 155 Lessons
Excel from A-Z Course Intro
3m
Excel Job Opportunities
3m
Excel Job Types
4m
Microsoft Excel Marketplace
4m
Who is This Course For?
3m
Finding & Opening Excel
1m
Excel’s Start Screen
3m
Explaining the Excel Interface
3m
Excel Interface Continued
1m
Excel Workbook vs. Excel Worksheet
2m
Saving an Excel Document
4m
Customizing the Quick Access Toolbar
2m
Customizing the Excel Ribbon
3m
Excel Shortcut Keys
2m
Creating Excel Labels
3m
Entering Numeric Values in Excel
3m
Formatting Date Values in Excel
5m
Building Basic Formulas in Excel
5m
Order of Operations
6m
Relative vs. Absolute Cell References
7m
Excel Functions Explained
3m
The SUM() Function
8m
The MIN() & MAX() Function
4m
The AVERAGE() Function
2m
COUNT() Functions
5m
Moving & Copying Data
7m
Insert & Delete Rows and Columns
5m
Adjusting the Width and Height of Cells
5m
Hiding and Unhiding Excel Rows and Columns
4m
Renaming, Moving & Deleting Excel Worksheets
5m
Adding Protection to Specific Cells
4m
Protecting the Structure of a Workbook
2m
Adding a Workbook Password to Open File
2m
Formatting Fonts and Cell Background Color
5m
Adding Cell Borders
5m
Formatting Data Appropriately
5m
The Magic behind Excel's Format Painter
3m
Creating Styles for Formatting Efficiency
6m
Merging Cells for a Cleaner Look
3m
The Power of Conditional Formatting
6m
Grab User’s Attention using Illustrations
9m
Customizing Icons
5m
Create Compelling Graphics with SmartArt
6m
The Commonly Used Column Chart
3m
Changing the Chart Design.mp4
2m
Formatting Elements of a Chart
6m
Modifying the Data, Type & Location of a Chart
6m
Print Preview Options
4m
Excel's Page Layout View
7m
Printing a Specific Range of Cells
3m
Converting Spreadsheets to PDF Files
2m
Why Create an Excel Template
1m
How to Create an Excel Template
5m
How to Prepare Data for Analysis
4m
How to Sort Data in Excel
3m
Multi-Level Sorting
3m
Custom Sorting Datasets in Excel
2m
Applying Filters to Datasets
5m
Creating Subtotals within a Dataset
6m
Converting Datasets into Tables
6m
Little Slice of Pie Charts
5m
Finding & Removing Duplicate Values
7m
The SUMIF() Function
9m
The DSUM() Function
8m
The DSUM() Function Cont.
7m
The SUBTOTAL() Function
6m
What is Excel Data Validation?
2m
Creating a Drop Down List with Data Validation
7m
Different Types of Excel Data Validation
6m
Adding Custom Alerts to Data Validation
7m
Creating a Dynamic Drop Down List
3m
Complex Validation: Dependent Drop Down List!
9m
Creating an Excel Pivot Table
6m
Modifying Excel PivotTables
6m
Grouping & Filtering PivotTable Data
6m
Drilling Down into PivotTable Data
2m
Creating Pivot Charts & Utilizing Slicers
6m
What is PowerPivot?
4m
Activating the Excel PowerPivot Add-In
2m
Creating Relationships between Data Tables.mp4
6m
Using Data Models to Create PivotTables
5m
How to Create PowerPivot KPI’s
8m
Excels IF Function
5m
IF() Function with AND() Criteria
5m
IF() Function with OR() Criteria
5m
Nesting Multiple IF() Functions
7m
The COUNTIF() Function
4m
Key Benefits of Named Ranges
4m
VLOOKUP() Function
9m
The Beauty of Excel’s IFERROR() Function
4m
HLOOKUP() Function
6m
The INDEX Function
5m
MATCH() Function
5m
INDEX() and MATCH() Combined
5m
Two-Way Lookup with INDEX() and MATCH()
4m
LEFT(), RIGHT() and MID() Function
7m
Extracting Specific Text using LEN() & SEARCH()
13m
Combining Text with CONCATENATE()
6m
Quick Tips & Other Text Based Functions
6m
Tracing Precedents & Dependents in Formulas
4m
Showing Formulas
2m
Grouping Data
3m
3D Referencing in Formulas
5m
Utilizing the Watch Window in Excel
3m
How to Freeze Panes in Excel
3m
Excel’s Scenario Manager Tool
6m
Goal Seek in Excel
6m
Compare Results with Excel Data Tables
4m
Solver Tool
11m
The Power Behind Excel VBA
3m
A Look Inside the Visual Basic Editor (VBE)
4m
Recording a Macro
9m
Saving & Opening a Macro-Enabled Workbook
2m
Modules and Procedures
7m
Objects, Methods and Properties
6m
Excel VBA Variables
5m
Referencing a Range
13m
InputBox & MsgBox
6m
Using Variables in VBA Code
5m
If Then Else Statement
10m
Worksheet Functions inside VBA
8m
Creating User Defined Functions
9m
User Defined Functions within VBA Scripts
6m
Find Last Row of Data
6m
Find Last Column of Data
3m
With Statement
5m
Debugging & Error Handling
7m
Debugging & Error Handling Cont.
7m
For Next Loop
9m
Do Until Loop
6m
For Each Loop
4m
Assigning Macros to Shapes
4m
Form Controls vs ActiveX Controls
8m
Worksheet Events
4m
Workbook Events
3m
Fun with VBA Events!
7m
Creating an Excel UserForm
3m
Adding Controls to UserForms
10m
How to Show an UserForm
3m
Passing TextBox Values to Desired Cells
7m
Passing Option Buttons to Desired Cells
7m
UserForm ComboBoxes
8m
Clearing Values from UserForm Controls
3m
How to Close an UserForm
2m
UserForms and Protected Sheets
5m
Creating an Excel Resume
5m
Getting Started with Freelancing
6m
How to Become an Excel Freelancer
5m
Top Freelance Websites
5m
How to Get Your First Client
8m
Personal Branding
7m
Networking Do’s and Don’ts
4m
Importance of Having a Website
4m
Resources - Advanced Diploma in Microsoft Excel
Order Your Certificates or Transcripts
92% Discount Offer Ends in
08
Hours
00
Minutes
00
Seconds
£125.00£19.00
TAKE THIS COURSE
OR
ALL COURSES FOR £50 
14 Days Money Back Guarantee
Related Courses
18 Students
Tutor Support
10h 38m
Certificate
Microsoft Word Complete Course – Level 1, 2 and 3
4 Students
Tutor Support
1h 21m
Certificate
Microsoft Excel: Pivot Tables, Pivot Charts, Slicers and Timelines
1 Students
Tutor Support
4h 28m
Certificate
Microsoft PowerPoint for Beginners
1 Students
Tutor Support
1h 38m
Certificate