About This Course
Course Overview
Go from an Excel novice to a confident power user. Covering Level 1 (Fundamentals), Level 2 (Intermediate Analysis), and Level 3 (Advanced Formulas & Dashboards), this complete series teaches you the essential Excel skills required in modern business.
What You Will Learn
- Level 1: Excel navigation, cell formatting, basic math formulas, and printing
- Level 2: VLOOKUP, XLOOKUP, INDEX/MATCH, IF conditions, and data validation
- Level 3: PivotTables, Pivot Charts, Slicers, and dynamic business dashboards
- Data cleaning, text functions, conditional formatting, and sorting/filtering
- Practical business models, financial forecasting, and time-saving shortcuts
Prerequisites
- Microsoft Excel installed on your computer (Excel 2016, 2019, 2021, or Microsoft 365)
Who This Course is For
Professionals, accountants, analysts, students, and managers who want to master Excel.
Admin
30
Courses
1
Students
Curriculum Overview
This course includes 25 modules, 295 lessons, and 0 hours of materials.
1. Excel Essentials Level 1 Basics Master Excel Step By Step
2 Parts
Intro To Level 1
Free
Volume
12.33 MB
Before We Start...Viewing The Lectures, And Following Along On A Single Screen
Volume
9.51 MB
2. An Introduction To Level 1
1 Parts
Where Are My Practice Files
Volume
3.41 MB
3. Start Here All The Basics
16 Parts
Opening Excel, And Creating A Shortcut
Volume
17.8 MB
The Anatomy Of A Workbook Where Everything Is, And What It Does!
Volume
49.57 MB
A Quick Review Of What's Where
Volume
17.06 MB
Always Do This First! Save Your New Workbook!
Volume
4.71 MB
Let's Enter Some Data
Volume
3.27 MB
Editing Data
Volume
2.99 MB
Ooops. I Made A Mistake Undo And Redo
Volume
2.37 MB
Changing Appearance Of Text With Formatting Fonts
Volume
21.83 MB
A Quick Word On Formatting
Volume
3.53 MB
Formatting Text Alignment
Volume
6.88 MB
Saving Time With AutoFilling Sequences
Volume
11 MB
POWER USER Adding Your Own Lists To Autofill
Volume
18.04 MB
Saving Time With Format Painter
Volume
6.56 MB
Changing The Column Width
Volume
7.39 MB
Tidy Large Titles With Merge And Centre
Volume
6.16 MB
Entering Data A Couple Of Shortcuts
Volume
8.27 MB
4. Doing The (Simple) Math
10 Parts
Sums The Old Fashioned Way!
Volume
6.07 MB
Sums Using Autosum
Volume
13.14 MB
Copying Formulas
Volume
7.7 MB
SUMming Horizontally
Volume
7.38 MB
Basic Formulas Subtraction
Volume
5.58 MB
Basic Formulas Multiplication
Volume
3.55 MB
Basic Formulas Division
Volume
2.77 MB
Average Function
Volume
7.14 MB
The Order Of Mathematical Operation
Volume
12.55 MB
POWER USER Evaluate Formula
Volume
10.39 MB
5. Rearranging Things
4 Parts
Inserting New Columns And Rows
Volume
16.22 MB
Moving Existing Columns And Rows
Volume
5.88 MB
Cutting, Copying, Inserting And Deleting
Volume
12.07 MB
Hiding Columns And Rows
Volume
8.14 MB
6. Formulas Learning The Clever Stuff!
4 Parts
ROUNDing Functions
Volume
15.28 MB
Formatting Numbers
Volume
7.63 MB
A Primer In Building Complex Formulas
Volume
6.09 MB
Buliding A Compex Formula
Volume
11.27 MB
7. A Few More Essentials
12 Parts
Sorting
Volume
13.92 MB
Wrapping Text And Soft Enter
Volume
11.17 MB
Adding A New Worksheet
Volume
3.82 MB
Creating A Simple Chart
Volume
12.33 MB
Adding Borders
Volume
8.17 MB
Customizing The Quick Access Toolbar
Volume
6.82 MB
Simple Printing
Volume
12.87 MB
Freezing For An Easier View
Volume
13.73 MB
Getting Help
Volume
5.4 MB
Filters
Volume
16.96 MB
Highlighting Cells
Volume
8.47 MB
Closing
Volume
3.76 MB
11. Excel Essentials Level 2 IntermediateAdvanced
1 Parts
Intro To Level 2
Volume
8.94 MB
12. Project 1 Creating A Data Entry Screen To Populate Multiple Templates
22 Parts
Proof Of Concept
Volume
16.33 MB
Planning Ahead
Volume
4.74 MB
Creating Our Data Entry Screen
Volume
9.48 MB
(Custom) Formatting Dates And Time
Volume
13.11 MB
Simple Calculations With Time
Volume
5.02 MB
More (Useful) Calculations With Time
Volume
19.5 MB
It's About Time (And Dates!)
Volume
16.4 MB
Adding Time
Volume
8.88 MB
Creating A Template From An Image
Volume
34.71 MB
Importing A Template From An Existing Excel File
Volume
13.14 MB
Converting Time To A Decimal
Volume
16.16 MB
A Little Bit Of Simple Data Entry
Volume
9.13 MB
Simple Conditional Formatting For A Cleaner View
Volume
15.7 MB
Calculating Time Out Of House Using Travel Time
Volume
16.65 MB
Simple Logical Testing And Nested Logical Testing
Volume
22.58 MB
Building Text Strings With A Formula
Volume
43.46 MB
Before We Move On...Accessing The Developer Ribbon
Volume
4.78 MB
A Tick Box Exercise (Of Sorts)
Volume
28.22 MB
Auto Populating Check Boxes
Volume
34.15 MB
PRACTICE EXERCISE 1 Time To Add A New Entry
Volume
6.32 MB
Defining A Working Area, And Protecting Your Work
Volume
16.15 MB
PRACTICE EXERCISE 2 Set Up A Working Area, And Limit User Entry
Volume
3.83 MB
13. Project 2 Building A Database With Excel
26 Parts
Simple VLOOKUPs
Volume
8.58 MB
Step 1 Get Some Data In, And Split It
Volume
17.47 MB
Using Data Validation To Get The Right Input
Volume
11.59 MB
Let's Build Our Database!
Volume
19 MB
Importing Data From A Text File
Volume
8.8 MB
Importing Data From A Word File
Volume
10.98 MB
Pulling Data From Multiple Sources
Volume
10.07 MB
Using OTHER Look Ups To Look Up!
Volume
16.62 MB
LOOKUP From A LOOKUP With No Intermediary Step
Volume
5.95 MB
Data Arrays Don't Have To Start At A!
Volume
9.64 MB
Some Common Reasons VLook Ups Fail
Volume
14.02 MB
One Inherent Flaw In Vlook Up
Volume
3.55 MB
POWER USER A Breakdown Of Looking Up Backwards
Volume
13.25 MB
The Other Way Of Looking Up Backwards
Volume
14.2 MB
Backwards Look Ups In Action
Volume
11.47 MB
POWER USER Dealing With Inconsistencies In User Entry
Volume
28.16 MB
POWER USER Fuzzy Vlook Ups
Volume
10.44 MB
POWER USER Vlook Ups With Multiple Inputs
Volume
25.77 MB
POWER USER Looking Up Multiple Inputs Using An Array Formula
Volume
14.7 MB
VLOOKUPs Brother...HLOOKUP
Volume
12.33 MB
POWER USER The Holy Grail How To Return Multiple Values From A Single Look U
Volume
32.47 MB
What To Look For When THAT Formula Didn't Work
Volume
10.19 MB
The Fastest Way To Modify Your Column Numbers
Volume
16.14 MB
POWER USER Vlook Ups With Moving Columns
Volume
7.52 MB
Putting It All Together
Volume
28.06 MB
The Finishing Touch How Many Records Did I Find
Volume
12.55 MB
14. Project 3 Named Ranges
8 Parts
A Simple Static Named Range Using A Single Cell
Volume
8.76 MB
Creating A Named Range Using A Range Of Cells
Volume
6.32 MB
Using Row Labels To Name Multiple Ranges
Volume
7.24 MB
POWER USER A Magic Trick Using Row And Column Labels
Volume
10.3 MB
POWER USER Dynamic Named Ranges
Volume
18.38 MB
POWER USER What To Do With Dynamic Names Ranges With Titles
Volume
16.57 MB
3035 POWER USER Dynamic Charts
Volume
48.61 MB
3040 Horizontal Dynamic Named Ranges For Charts
Volume
42.61 MB
15. Project 4 What Can I Have For Dinner
15 Parts
Welcome To What Can I Have For Dinner Or...What Would I Use THAT For
Volume
2.49 MB
Hyperlinking To A Different Sheet In The Same Workbook
Volume
8.43 MB
Creating Our First Macro
Volume
12.68 MB
Assigning A Macro To A Button
Volume
9.89 MB
Creating A List For Our Dropdown Using A Dynamic Named Range
Volume
5.6 MB
Using A Conditional Format To Know When A Value Is Missing
Volume
10.12 MB
Copying Conditional Formats And Creating Our Drop Downs
Volume
6.84 MB
Building Our Formula...INDIRECT Function
Volume
5.62 MB
Building Strings For Indirect Sheet And Cell References
Volume
18.23 MB
It's A One Or A Zero
Volume
5.18 MB
Working The Percentages And Adding Traffic Lights
Volume
8.54 MB
POWER USER The HYPERLINK Function (And Problem)
Volume
12.15 MB
PRACTICE EXERCISE 1 Fill In The Blanks
Volume
2.03 MB
PRACTICE EXERCISE 2 Pretty It Up (With A Macro)
Volume
4.3 MB
PRACTICE EXERCISE 3 Create A VLOOKUP Using A Built String With INDIRECT
Volume
4.66 MB
16. Project 5 Using Excel For Gantt Charts...Timelines And Project Plans!
6 Parts
Creating A Gantt Chart Using A Worksheet
Volume
20.79 MB
Building The First Part Of Our Logical Test
Volume
12.94 MB
Multiple Logical Tests At Once Using AND
Volume
29.5 MB
Conditional Formatting...Where The Magic Happens
Volume
18.75 MB
Gantt Charts Using The Built In Charting Tools
Volume
29.58 MB
SQA Gantt Charts With Different Colours For Different Categories
Volume
20.01 MB
18. Student Questions Answered!
12 Parts
Calls Text Data Or How To Return A Column Title If Value Is 1
Volume
17.12 MB
Calls Text Data 2 This Time Using Text!
Volume
38.65 MB
Extracting Phone Numbers From A Cell
Volume
6.86 MB
What Is The CHOOSE Function Really Used For
Volume
40.53 MB
Casing And Text Functions
Volume
14.37 MB
Dynamic Charting From A Drop Down
Volume
37.34 MB
Extracting A Unique List, And Summing The Money!
Volume
13.43 MB
SUMIF With Dynamic Sum Range
Volume
16.63 MB
Vlookups With Pictures!
Volume
20.3 MB
Data Validation With Dependent Drop Downs
Volume
37.38 MB
Data Validation With Dependent Drop Downs (Dynamic Named Range Workaround)
Volume
77.6 MB
Using 2 Labels As A Lookup From Drop Downs
Volume
55.64 MB
19. Excel Essentials Level 3 VBA Programming
1 Parts
Why Should I Learn How To Code
Volume
39.65 MB
20. What's It All About, Alan
1 Parts
The 15 Golden Rules Of Coding
Volume
11.38 MB
21. Introducing Your Personal Built In Translator...the Macro Recorder
10 Parts
Introducing The Visual Basic Editor, & Recording Our First Macro
Volume
35.36 MB
Saving Macro Enabled Workbooks, And Security Settings
Volume
18.11 MB
Moving Code Around
Volume
13.38 MB
Stepping Out. Well, In Actually! Debugging Made Easy )
Volume
25.83 MB
With And End With
Volume
37.06 MB
Streamlining You Code, Or, Get Rid Of What You Don't Need
Volume
26.94 MB
Combining Your Code
Volume
22.29 MB
A Little Privacy Please
Volume
12.53 MB
Keyboard Shortcuts, And Why I Don't Use Them
Volume
4.14 MB
Why You Can't Get By With Just Recording Macros
Volume
35.85 MB
22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!
31 Parts
Introduction To The Coding Section
Volume
10.05 MB
Getting All The Code For This Section
Volume
20.11 MB
Changing Your VBE Settings
Volume
11.25 MB
Protecting Your Code
Volume
4.76 MB
Objects, Methods And Properties
Volume
16.78 MB
Understanding The Hierarchy
Volume
8.44 MB
The Range Object
Volume
7.06 MB
The Cells Object
Volume
6.21 MB
The ActiveCell Property
Volume
4.86 MB
The Offset Property
Volume
8.85 MB
The End Property
Volume
12.95 MB
Dynamic Range Selection
Volume
14.49 MB
The CurrentRegion Property
Volume
8.05 MB
ACTIVATE Vs. SELECT
Volume
4.29 MB
Between The Sheets
Volume
6.29 MB
Calling A Sheet By Its VB Name
Volume
11.46 MB
Sheets Vs. Worksheets
Volume
9.29 MB
Getting Around The Workbooks
Volume
8.81 MB
The Value Property Writing Data
Volume
18.1 MB
The Value Property Reading And Writing Data
Volume
9.35 MB
Copy And Paste
Volume
10.61 MB
Commonly Used Properties
Volume
6.07 MB
CODING EXERCISE The Rainbow
Volume
5.79 MB
The Address Property
Volume
8.83 MB
The Row And Column Properties
Volume
3.42 MB
Capturing The Column Letter
Volume
4.4 MB
More Useful Properties
Volume
8.89 MB
Even More Useful Properties
Volume
6.74 MB
Opening Another Workbook Programmatically
Volume
16.5 MB
Closing Workbooks Programmatically
Volume
9.51 MB
CODING EXERCISE OpenWriteClose
Volume
8.98 MB
23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)
39 Parts
Introduction To The Programmers Toolbox
Volume
2.97 MB
Variables Local Variables
Volume
17.94 MB
Variables Local Variables With A Twist
Volume
11.78 MB
Variables Module Level Variables
Volume
12.09 MB
Variables Project Level Variables
Volume
8.67 MB
Bonus Calling A Sub Stored In A DIFFERENT Workbook!
Volume
10.14 MB
A Neat Trick To Force Variable Declaration
Volume
6.48 MB
Variables All The Techie Bits
Volume
18.44 MB
An Introduction To Looping
Volume
2.79 MB
Looping With Do...Loop
Volume
13.37 MB
Looping With For...Next
Volume
7.59 MB
Looping With A Stepped For...Next
Volume
6.81 MB
Looping With While...Wend
Volume
25.81 MB
An Introduction To Logical Testing
Volume
4.78 MB
Logical Testing A Simple If Test
Volume
22.92 MB
Logical Testing A Simple If Test Using Cells
Volume
13.98 MB
Logical Testing If Then Else
Volume
13.08 MB
Logical Testing If Then Else Using Cells
Volume
16.49 MB
Logical Testing Testing Multiple Criteria
Volume
14.59 MB
Logical Testing Testing If One Is True, And One Is False
Volume
8.38 MB
Logical Testing Testing If Either Value Is True
Volume
14.44 MB
Logical Testing Select Case
Volume
20.61 MB
Maths Doing Simple Maths In Code
Volume
11.1 MB
Maths Writing Formulas To Single Cells
Volume
19.94 MB
Maths Writing Formulas To Ranges Of Cells
Volume
20.04 MB
Maths Using Excel's Built In Functions
Volume
9.95 MB
Maths Built In Functions With Defined Ranges
Volume
10.46 MB
InputBox Getting User Input Using The InputBox Function
Volume
15.99 MB
Manipulating The User Input With Casing
Volume
18.73 MB
InputBox Getting User Input Using The InputBox Method
Volume
19.89 MB
Message Boxes Simple Message Boxes
Volume
10.58 MB
Message Boxes Testing Which Button Was Pressed
Volume
12.78 MB
Arrays An Introduction
Volume
8.66 MB
Arrays A Simple One Dimensional Static Array
Volume
21.4 MB
Arrays A Simple One Dimensional Dynamic Array
Volume
18.12 MB
Arrays A Simple Two Dimensional Static Array
Volume
16.67 MB
Arrays The Most Efficient Way To Capture An Array
Volume
20.71 MB
Arrays Extracting Useful Data Based On User Input
Volume
26.05 MB
Arrays Using An Array As A Data Source For A VLookup
Volume
43.59 MB
24. Automating All Your Reports!
22 Parts
Introduction To Report Automation Section
Volume
9.45 MB
A Special Note For Office 2010 Users
Volume
4.87 MB
Recording The Bones Of The Code
Volume
12.63 MB
Streamlining The Add New Sheet Code
Volume
21.9 MB
Deconstructing The Profit By Day Code
Volume
4.58 MB
Building Source Data Strings Dynamically At Runtime
Volume
21.35 MB
Creating The Run Order And Data Capture Subs
Volume
13.69 MB
Solving That Naming Problem
Volume
14.04 MB
POWER USER Sizing Your Charts Precisely
Volume
9.08 MB
Changing The Chart Title (And Why We Do It Separately)
Volume
9.18 MB
Deconstructing The Pivot Tables (It's Slightly Different)
Volume
22.68 MB
Titles, Money And Sorting
Volume
15.79 MB
Butchering One Table, To Create Another
Volume
19.55 MB
Adding The Commentary Building Strings Dynamically At Runtime
Volume
28 MB
Adding The Comentary Using Data From The Sheet We're On
Volume
20.66 MB
POWER USER How DO You Make Specific Words Bold
Volume
22.02 MB
POWER USER INSTR...A Very Useful Function
Volume
14.28 MB
INSTR And Paying Attention To Detail
Volume
11.82 MB
Tidy Up The Title
Volume
16.79 MB
Easy As Pie (Chart)
Volume
24.42 MB
Prettying Up Our Pie Chart
Volume
11.19 MB
Putting It All Together
Volume
20.83 MB
25. The Data Is Out There...On The Internet, That Is
9 Parts
Introduction To Web Query Section
Volume
9.86 MB
Pulling Data From The Internet Capturing The Data For Rome
Volume
17.14 MB
Getting To Cancun And London From Rome
Volume
22.61 MB
Data Clean Up
Volume
13.99 MB
A Simple Find And Replace
Volume
8.7 MB
Getting Our Formulas Right
Volume
20.21 MB
Streamlining The Formulas Code
Volume
21.82 MB
POWER USER Displaying Messages In The Status Bar (Cool)
Volume
10.95 MB
Putting It All Together
Volume
10.94 MB
26. Workbook Events You Don't Have To Run Code To Have Code Run!
14 Parts
Intro To The Events Section
Volume
4.63 MB
WorkBook SheetActivate
Volume
15.07 MB
WorkBook BeforePrint
Volume
8.28 MB
WorkBook SheetChange
Volume
3.01 MB
WorkBook Open Creating An Auto Back Up
Volume
20.44 MB
WorkBook Open Creating A Splash Screen
Volume
14.7 MB
WorkBook Open Calling Other Code
Volume
23.06 MB
WorkBook BeforeClose
Volume
7.96 MB
WorkSheet Activate You Can't Pick This!
Volume
5.54 MB
WorkSheet Activate You Might Pick This!
Volume
8.63 MB
WorkSheet Change
Volume
6.45 MB
WorkSheet Change A More Useful Use
Volume
18.36 MB
WorkSheet Activate Top Secret Classified Information!
Volume
11.33 MB
WorkSheet Events BONUS 4 New Things To Try
Volume
77.36 MB
27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!
6 Parts
User Defined Functions...What They Are, And How You Make Them
Volume
12.03 MB
Using A UDF To Return Information
Volume
3.66 MB
Creating A Countdown Timer With A UDF
Volume
16.35 MB
A Custom UDF For Calculating Volume Discount
Volume
8.14 MB
A UDF For Getting All Your Sheet Names
Volume
20.71 MB
Calling A UDF From A Different Workbook
Volume
3.86 MB
32. Importing Specific Data From Multiple Files
5 Parts
Intro To Importing Data From A Folder Full Of Files
Volume
10 MB
Looping Through All Excel Files In A Folder
Volume
14.44 MB
The Folder Picker
Volume
10.83 MB
A More Useful Loop Through Files
Volume
7.9 MB
The Data Grabber(er)
Volume
45.96 MB
33. Student Questions Answered
18 Parts
Get Rid Of Rows In A Array
Volume
16.66 MB
Emailing Routine Adding A Specific Attachment Based On A Criteria
Volume
12.48 MB
Adding A Date Stamp, And Going To The Insertion Point AUTOMATICALLY
Volume
17.41 MB
Saving An Individual Sheet To A Specific Folder
Volume
29.72 MB
Saving Multiple Sheets To A Single Workbook In A Specific Folder
Volume
80.94 MB
Animated Charts...With A Little Something Extra!
Volume
24.35 MB
Extracting Specific Data From A Big File, To A Bunch Of Little Ones
Volume
38.11 MB
Finding A Search String In Another Workbook With Multiple Sheets
Volume
14.65 MB
Extracting Unique Tables To Unique Sheets From A Big Data Set
Volume
44.87 MB
Protecting Specific Cells And Data Validation
Volume
32.56 MB
Dynamically Populating A Reusable Array While Looping Through A Table
Volume
15.26 MB
Sequential PDF Creation With Pictures
Volume
49 MB
File Picker, And Report Generator With Intelligent Filing
Volume
58.5 MB
Help! My File Has Got HUGE!
Volume
26.28 MB
Finding Updated Values In One Workbook, And Adding Them To Another Workbook
Volume
29.37 MB
Gantt Charts...With A Little More Sophistication!
Volume
33.18 MB
Vlookups (Or Any Application.WorksheetFunction) Over Ranges
Volume
136.2 MB
Adding A Date Stamp If A Change Has Been Made
Volume
47.41 MB
0
0 Reviews
Content Quality (0)
Instructor Skills (0)
Value for Money (0)
Support Quality (0)
Course Specifications
Sections
25
Lessons
295
Capacity
Unlimited
Duration
52:45 Hours
Students
0
Created Date
9 Sep 2026
Updated Date
9 Sep 2026
You are viewing
Excel Essentials: Complete Excel Masterclass (Levels 1, 2 & 3)
Subscribe to Our Newsletter
Receive expert insights, course updates, and learning resources directly in your inbox and get notified
Additional Links
Login Register Contact Certificate Validation About Us Terms & Conditions Privacy Policy Refund PolicyContact US
© 2026 ZyloLearn, operated by Trelixa Technologies Private Limited. All rights reserved.
Reply to Comment