Advanced Diploma in Microsoft Excel
Last Updated:
09 June 2026
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
Excel Job Opportunities
Excel Job Types
Microsoft Excel Marketplace
Who is This Course For?
Finding & Opening Excel
Excel’s Start Screen
Explaining the Excel Interface
Excel Interface Continued
Excel Workbook vs. Excel Worksheet
Saving an Excel Document
Customizing the Quick Access Toolbar
Customizing the Excel Ribbon
Excel Shortcut Keys
Creating Excel Labels
Entering Numeric Values in Excel
Formatting Date Values in Excel
Building Basic Formulas in Excel
Order of Operations
Relative vs. Absolute Cell References
Excel Functions Explained
The SUM() Function
The MIN() & MAX() Function
The AVERAGE() Function
COUNT() Functions
Moving & Copying Data
Insert & Delete Rows and Columns
Adjusting the Width and Height of Cells
Hiding and Unhiding Excel Rows and Columns
Renaming, Moving & Deleting Excel Worksheets
Adding Protection to Specific Cells
Protecting the Structure of a Workbook
Adding a Workbook Password to Open File
Formatting Fonts and Cell Background Color
Adding Cell Borders
Formatting Data Appropriately
The Magic behind Excel's Format Painter
Creating Styles for Formatting Efficiency
Merging Cells for a Cleaner Look
The Power of Conditional Formatting
Grab User’s Attention using Illustrations
Customizing Icons
Create Compelling Graphics with SmartArt
The Commonly Used Column Chart
Changing the Chart Design.mp4
Formatting Elements of a Chart
Modifying the Data, Type & Location of a Chart
Print Preview Options
Excel's Page Layout View
Printing a Specific Range of Cells
Converting Spreadsheets to PDF Files
Why Create an Excel Template
How to Create an Excel Template
How to Prepare Data for Analysis
How to Sort Data in Excel
Multi-Level Sorting
Custom Sorting Datasets in Excel
Applying Filters to Datasets
Creating Subtotals within a Dataset
Converting Datasets into Tables
Little Slice of Pie Charts
Finding & Removing Duplicate Values
The SUMIF() Function
The DSUM() Function
The DSUM() Function Cont.
The SUBTOTAL() Function
What is Excel Data Validation?
Creating a Drop Down List with Data Validation
Different Types of Excel Data Validation
Adding Custom Alerts to Data Validation
Creating a Dynamic Drop Down List
Complex Validation: Dependent Drop Down List!
Creating an Excel Pivot Table
Modifying Excel PivotTables
Grouping & Filtering PivotTable Data
Drilling Down into PivotTable Data
Creating Pivot Charts & Utilizing Slicers
What is PowerPivot?
Activating the Excel PowerPivot Add-In
Creating Relationships between Data Tables.mp4
Using Data Models to Create PivotTables
How to Create PowerPivot KPI’s
Excels IF Function
IF() Function with AND() Criteria
IF() Function with OR() Criteria
Nesting Multiple IF() Functions
The COUNTIF() Function
Key Benefits of Named Ranges
VLOOKUP() Function
The Beauty of Excel’s IFERROR() Function
HLOOKUP() Function
The INDEX Function
MATCH() Function
INDEX() and MATCH() Combined
Two-Way Lookup with INDEX() and MATCH()
LEFT(), RIGHT() and MID() Function
Extracting Specific Text using LEN() & SEARCH()
Combining Text with CONCATENATE()
Quick Tips & Other Text Based Functions
Tracing Precedents & Dependents in Formulas
Showing Formulas
Grouping Data
3D Referencing in Formulas
Utilizing the Watch Window in Excel
How to Freeze Panes in Excel
Excel’s Scenario Manager Tool
Goal Seek in Excel
Compare Results with Excel Data Tables
Solver Tool
The Power Behind Excel VBA
A Look Inside the Visual Basic Editor (VBE)
Recording a Macro
Saving & Opening a Macro-Enabled Workbook
Modules and Procedures
Objects, Methods and Properties
Excel VBA Variables
Referencing a Range
InputBox & MsgBox
Using Variables in VBA Code
If Then Else Statement
Worksheet Functions inside VBA
Creating User Defined Functions
User Defined Functions within VBA Scripts
Find Last Row of Data
Find Last Column of Data
With Statement
Debugging & Error Handling
Debugging & Error Handling Cont.
For Next Loop
Do Until Loop
For Each Loop
Assigning Macros to Shapes
Form Controls vs ActiveX Controls
Worksheet Events
Workbook Events
Fun with VBA Events!
Creating an Excel UserForm
Adding Controls to UserForms
How to Show an UserForm
Passing TextBox Values to Desired Cells
Passing Option Buttons to Desired Cells
UserForm ComboBoxes
Clearing Values from UserForm Controls
How to Close an UserForm
UserForms and Protected Sheets
Creating an Excel Resume
Getting Started with Freelancing
How to Become an Excel Freelancer
Top Freelance Websites
How to Get Your First Client
Personal Branding
Networking Do’s and Don’ts
Importance of Having a Website
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
Excel Job Opportunities
Excel Job Types
Microsoft Excel Marketplace
Who is This Course For?
Finding & Opening Excel
Excel’s Start Screen
Explaining the Excel Interface
Excel Interface Continued
Excel Workbook vs. Excel Worksheet
Saving an Excel Document
Customizing the Quick Access Toolbar
Customizing the Excel Ribbon
Excel Shortcut Keys
Creating Excel Labels
Entering Numeric Values in Excel
Formatting Date Values in Excel
Building Basic Formulas in Excel
Order of Operations
Relative vs. Absolute Cell References
Excel Functions Explained
The SUM() Function
The MIN() & MAX() Function
The AVERAGE() Function
COUNT() Functions
Moving & Copying Data
Insert & Delete Rows and Columns
Adjusting the Width and Height of Cells
Hiding and Unhiding Excel Rows and Columns
Renaming, Moving & Deleting Excel Worksheets
Adding Protection to Specific Cells
Protecting the Structure of a Workbook
Adding a Workbook Password to Open File
Formatting Fonts and Cell Background Color
Adding Cell Borders
Formatting Data Appropriately
The Magic behind Excel's Format Painter
Creating Styles for Formatting Efficiency
Merging Cells for a Cleaner Look
The Power of Conditional Formatting
Grab User’s Attention using Illustrations
Customizing Icons
Create Compelling Graphics with SmartArt
The Commonly Used Column Chart
Changing the Chart Design.mp4
Formatting Elements of a Chart
Modifying the Data, Type & Location of a Chart
Print Preview Options
Excel's Page Layout View
Printing a Specific Range of Cells
Converting Spreadsheets to PDF Files
Why Create an Excel Template
How to Create an Excel Template
How to Prepare Data for Analysis
How to Sort Data in Excel
Multi-Level Sorting
Custom Sorting Datasets in Excel
Applying Filters to Datasets
Creating Subtotals within a Dataset
Converting Datasets into Tables
Little Slice of Pie Charts
Finding & Removing Duplicate Values
The SUMIF() Function
The DSUM() Function
The DSUM() Function Cont.
The SUBTOTAL() Function
What is Excel Data Validation?
Creating a Drop Down List with Data Validation
Different Types of Excel Data Validation
Adding Custom Alerts to Data Validation
Creating a Dynamic Drop Down List
Complex Validation: Dependent Drop Down List!
Creating an Excel Pivot Table
Modifying Excel PivotTables
Grouping & Filtering PivotTable Data
Drilling Down into PivotTable Data
Creating Pivot Charts & Utilizing Slicers
What is PowerPivot?
Activating the Excel PowerPivot Add-In
Creating Relationships between Data Tables.mp4
Using Data Models to Create PivotTables
How to Create PowerPivot KPI’s
Excels IF Function
IF() Function with AND() Criteria
IF() Function with OR() Criteria
Nesting Multiple IF() Functions
The COUNTIF() Function
Key Benefits of Named Ranges
VLOOKUP() Function
The Beauty of Excel’s IFERROR() Function
HLOOKUP() Function
The INDEX Function
MATCH() Function
INDEX() and MATCH() Combined
Two-Way Lookup with INDEX() and MATCH()
LEFT(), RIGHT() and MID() Function
Extracting Specific Text using LEN() & SEARCH()
Combining Text with CONCATENATE()
Quick Tips & Other Text Based Functions
Tracing Precedents & Dependents in Formulas
Showing Formulas
Grouping Data
3D Referencing in Formulas
Utilizing the Watch Window in Excel
How to Freeze Panes in Excel
Excel’s Scenario Manager Tool
Goal Seek in Excel
Compare Results with Excel Data Tables
Solver Tool
The Power Behind Excel VBA
A Look Inside the Visual Basic Editor (VBE)
Recording a Macro
Saving & Opening a Macro-Enabled Workbook
Modules and Procedures
Objects, Methods and Properties
Excel VBA Variables
Referencing a Range
InputBox & MsgBox
Using Variables in VBA Code
If Then Else Statement
Worksheet Functions inside VBA
Creating User Defined Functions
User Defined Functions within VBA Scripts
Find Last Row of Data
Find Last Column of Data
With Statement
Debugging & Error Handling
Debugging & Error Handling Cont.
For Next Loop
Do Until Loop
For Each Loop
Assigning Macros to Shapes
Form Controls vs ActiveX Controls
Worksheet Events
Workbook Events
Fun with VBA Events!
Creating an Excel UserForm
Adding Controls to UserForms
How to Show an UserForm
Passing TextBox Values to Desired Cells
Passing Option Buttons to Desired Cells
UserForm ComboBoxes
Clearing Values from UserForm Controls
How to Close an UserForm
UserForms and Protected Sheets
Creating an Excel Resume
Getting Started with Freelancing
How to Become an Excel Freelancer
Top Freelance Websites
How to Get Your First Client
Personal Branding
Networking Do’s and Don’ts
Importance of Having a Website
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
test TAKE THIS COURSE
OR
ALL COURSES FOR £50 
14 Days Money Back Guarantee
Related Courses
33 Students
Tutor Support
3h 23m
Certificate
Microsoft Access for Beginners
18 Students
Tutor Support
10h 38m
Certificate
Microsoft Word Complete Course – Level 1, 2 and 3
2 Students
Tutor Support
57m
Certificate
Using Excel with ChatGPT
3 Students
Tutor Support
4h 49m
Certificate
Financial Modelling in Excel: Beginner to Intermediate
copyright © LIBM