Currently Empty: £0.00
Welcome to Our Microsoft Excel Training. This training will empower your skillset and boost your confidence and portfolio. This course starts with the basics and steadily builds your expertise through advanced topics like Power Query, PivotTables, Dynamic Arrays, and even automation using VBA and Macros. You’ll master Excel functions such as IF, VLOOKUP, INDEX, and SUMIF—and learn how to apply them with confidence.
Is Excel still worth learning in 2025?
Absolutely. Whether you’re analysing performance, forecasting trends, or automating reports, Excel remains the go-to tool for professionals across every industry.
I already know the MS Excel basics. Is this course for me?
Yes. The course is structured to support learners at all levels. If you’re familiar with simple formulas and ready to dive into advanced data transformation, automation, and dashboard creation—this is your next step.
Can I automate tasks and save time with Excel?
Yes. You’ll explore Excel VBA and Macros to automate repetitive tasks and unlock a new level of productivity.
Will this Excel course help me in my job or career?
Definitely. Excel skills are among the most in-demand in today’s job market. By the end of this course, you’ll be equipped to handle real-world data challenges, streamline reporting, and impress your team or clients.
Key Employment Opportunities:
- Excel Cost Estimator: Yearly £45,000 approx
- Excel Project Manager: Yearly £50,000 approx
- Office Administrator: Yearly £18,000 to £30,000 approx
Certification
After the successful completion of the final assessment, you will be eligible to order a digital certificate issued by Empower UK Employment Training for only £4. You will also have the option to order an official CPD Quality Ensured Certificate and Transcript to further validate your learning. Charges apply.
What Will You Learn?
- Apply advanced formulas for dynamic data analysis
- Transform data using Power Query and PowerPivot
- Automate tasks using Excel VBA and Macros
- Create professional dashboards and charts
- Use Excel functions with accuracy and confidence
Audience
- Business Professionals
- Data Analysts
- Students and Graduates
- Small Business Owners
- Accountants and Finance Professionals
- HR Professionals
- Administrative Assistants
- Marketing Professionals
Course Content
Section 01: Introduction
-
Introduction
03:13
Section 02: Working with Large Worksheets
-
Keeping your Headings Visible as you Scroll
03:50 -
Splitting a Worksheet to Reference Two Different Areas
03:50 -
Hiding and Unhiding Columns
02:47 -
Sorting a Large List – Including a Super Shortcut
06:20 -
Filtering a List – One of the Most Useful Excel Skills
07:10
Section 03: Five Essential Tricks for Printing Spreadsheets
-
Scaling a Print to Fit onto Fewer Pages
05:26 -
Repeating your Headers Across Multiple Pages
03:06 -
Printing a Selected Range and Setting a Print Area
04:06 -
Aligning a Print on a Page
02:30 -
Using Page Breaks to Logically Break Up
04:29
Section 04: Getting Started with Excel Formulas
-
Introduction to Formulas – Writing your First Excel Formulas
07:50 -
The Order Of Calculation-BODMAS
03:13 -
Calculating Percentages
07:54 -
Unleash the Power of Excel Functions
08:44 -
Referencing Other Sheets and Workbooks
11:45 -
Calculating Date Difference including Working Day
08:09 -
Understand Absolute Cell Addresses
06:22 -
The COUNTIF Function-An Incredibly Useful Function
13:12
Section 05: Logical Functions: The Decision Making Formulas of Excel
-
IF Function 1
04:22 -
IF Function 2
03:52 -
IF Function 3
04:06 -
Nested IFS
04:50 -
AND and OR Functions
06:35 -
TNo More Nested IFS
04:10 -
The Switch Function
09:00
Section 06: Conditional Formatting – Make your Data Come to Life
-
Create your First Conditional Formatting
07:00 -
Managing Multiple Rules
07:09 -
Highlight Expired And Due Dates
07:23 -
Applying Data Bars
06:21 -
Create a Heat Map
03:00 -
Using Icon Sets
08:04 -
Entire Row
04:31 -
Testing Multiple Conditions
06:42
Section 07: Dynamic Array Functions – Formulas Have Changed
-
Introduction to dynamic Arrays
11:54 -
The UNIQUE Function
08:20 -
The SORT Function
08:25 -
The SORTBY Function
06:53 -
The FILTER Function
20:00 -
The SEQUENCE Function
10:33
Section 08: Lookup Functions – The Powerful VLOOKUP Function and beyond
-
The VLOOKUP Function Explained
07:00 -
Using VLOOKUP for a Range
05:09 -
Advanced VLOOKUP
09:00 -
Handling Error Messages
05:24 -
The INDEX and MATCH Comb
06:19 -
INDEX and MATCH
04:15 -
Return Non Adjacent Columns
06:19 -
XLOOKUP Function
11:38 -
Multi-Column Lookup
03:20 -
Two-Way Lookup
04:41
Section 09: Validating and Protecting Excel Data
-
Number Of Characters
02:23 -
Create Date Validation Rules
02:23 -
Drop Down Lists
04:35 -
Dependent Lists
05:25 -
Data Validation Messages
06:46 -
Encrypt a File
02:48 -
Protect Workbook
05:46 -
Protect Worksheet
07:50
Section 10: Advanced Formulas for Analysing Data
-
Using SUMIF, COUNTIF and AVERAGEIF
08:00 -
Summing the Values between Two Dates
05:44 -
Advanced Sum Formula with SUMPRODUCT
05:53 -
SUMPRODUCT Example 2
09:37 -
Secret AGGREGATE Function
07:38 -
Advanced AGGREGATE
04:51
Section 11: Charts – Simple and Effective Data Presentation
-
First-Charts
07:35 -
Chart-Elements
05:23 -
Formatting Charts
06:42 -
Modify the Charts Axis
07:22 -
Chart Templates
04:35 -
Combo Charts
06:19 -
Chart-Filters
02:29 -
Interactive Charts
08:03 -
Using Cell Values for Chart Labels
04:27 -
Conditional-Formatting with Charts
07:58 -
Sparklines
06:03
Section 12: Manipulating Text in Excel
-
Splitting Text across Multiple Columns
07:25 -
Concat and Concatenate Functions
06:28 -
The TEXTJOIN Function
04:10 -
Extracting Text from a Cell
09:34 -
MID and FIND Functions
07:23 -
Value Function
03:34 -
Substitute Function
07:31 -
Flash Fill Tool
10:07
Section 13: Formatting your Data Ranges as Tables for Easier Management
-
Formatting as a Table
04:00 -
Benefits of Using Table
07:50 -
Creating Table Style
04:42 -
Formulas Using a Tables
06:51 -
Back to a Normal Range
01:40
Section 14: Master PivotTables for Powerful Analysis and Reporting
-
Creating a PivotTable
08:09 -
Values Function
03:19 -
Formatting Values
02:20 -
PivotTable Style
05:10 -
Sorting PivotTable
02:37 -
Grouping Data
04:55 -
Showing Values
05:11 -
Conditional Formatting
03:41 -
Filtering PivotTable Data
04:00 -
Refreshing a PivotTable
04:49 -
Creating a Pivotchart
05:22 -
Slicers
11:56 -
Timeline
02:55
Section 15: Getting and Transforming Data with Power Query
-
What is Power Query
03:09 -
Merge-Queries-2
06:15 -
Messy Data
21:26 -
Unpivot
07:01 -
Merge Queries-1
10:03 -
Combine and Append
10:32
Section 16: Working with the Data Model and PowerPivot
-
Introduction PowerPivot
07:00 -
Creating Relationships
07:46 -
Creating PivotTable
05:51 -
PowerPivot Adding
01:12 -
Setting Locales
10:04 -
PowerPivot Window
04:39 -
Calculated columns
07:37 -
Measures
10:29 -
Multiple Files From Folder
15:07 -
Importing Data From web
12:46
A course by
Student Ratings & Reviews
No Review Yet
Course Includes:
- Price:
£199.00Original price was: £199.00.£20.00Current price is: £20.00. - Instructor:Alan Murray
- Duration:15 hours30 minutes
Lessons:117
- Students:0
- Level:All Levels
£20.00
£199.00
Hi, Welcome back!




