In the first part of Excel basics, we get familiar with the Excel interface and start building some Excel formulae.
Excel Basics Part 1 START.xlsm
14 KB
Excel Basics Part 1 END.xlsm
110 KB
Excel Basics Part 1 Session 1.mp4
11 mins
544 MB
Excel Basics Part 1 Session 2.mp4
16 mins
1.02 GB
Excel Basics Part 1 Session 3.mp4
11 mins
727 MB
Excel Basics Part 1 Session 4.mp4
11 mins
339 MB
Excel Basics Part 1 Session 5.mp4
14 mins
434 MB
Part 2: Excel Modelling Basics
Modelling is what Excel is great at! By creating relationships between cells using formulae, we can implement a chain of calculations to 'model' a real-life situation. Let's see how in this module ...
Excel Basics Part 2 START.xlsm
21.6 KB
Excel Basics Module 2 END.xlsm
24.7 KB
Excel Basics Part 2 Session 1.mp4
10 mins
567 MB
Excel Basics Part 2 Session 2.mp4
12 mins
705 MB
Excel Basics Part 2 Session 3.mp4
17 mins
1.04 GB
Excel Basics Part 2 Session 4.mp4
15 mins
497 MB
Excel Basics Part 2 Session 5.mp4
13 mins
429 MB
Excel Basics Part 2 Session 3.mp4
17 mins
538 MB
Excel Basics Part 2 Session 1.mp4
14 mins
432 MB
Excel Basics Part 2 Session 2.mp4
18 mins
573 MB
Part 3: Excel Data Analysis Basics
Excel tends to hold data and it is often our job to make sense of it! This is why data analysis is a fundamental skill for any Excel user. Let's learn the basics in this module ...
Excel Basics Part 3 START v2.xlsm
50.3 KB
Excel Basics Part 3 END.xlsm
62.2 KB
Excel Basics Part 3 Session 1
18 mins
578 MB
Excel Basics Part 3 Session 2.mp4
16 mins
527 MB
Excel Basics Part 3 Session 3.mp4
12 mins
374 MB
Excel Basics Part 3 Session 4.mp4
17 mins
535 MB
Excel Basics Part 3 Session 5.mp4
18 mins
580 MB
Excel Basics Part 3 Session 6.mp4
12 mins
395 MB
Part 4: Excel Data Input Basics
Data input is the one thing you can guarantee happens in most spreadsheets. So why don't we focus on it more? Let's learn the basics in this module ...
Excel Basics Part 4 START.xlsm
11.1 KB
Excel Basics Part 4 END.xlsm
17.2 KB
Excel Basics Part 4 Session 1.mp4
12 mins
376 MB
Excel Basics Part 4 Session 2.mp4
15 mins
480 MB
Excel Basics Part 4 Session 3.mp4
17 mins
547 MB
Excel Basics Part 4 Session 4.mp4
18 mins
580 MB
Part 5: Excel VBA Automation Basics
In this module, we explore how to begin to automate time-consuming tasks using Excel VBA