Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel: From Beginner to Advanced 2023
Introduction
A brief introduction to Excel (5:09)
The basic layout of spreadsheet (10:00)
Auto-fill, basic functions and more (8:13)
Exercise and solution video (5:29)
Course notebook preview (0:52)
Downloading your notebook templates
Must know keyboard shortcuts when doing an online course
List of keyboard shortcuts
A general overview and brief introduction (MUST WATCH) (1:47)
Starting on the main workbook
Main workbook download
The three different types of references. Part 1 (6:38)
The three different types of references. Part 2 (3:41)
References exercise. A quick note
References exercise (4:12)
Quiz question: Test your knowledge on references
Formulas and functions. What's the difference? (2:08)
How to write formulas (8:53)
Basic function variations you must know (10:41)
Basic function variations you must know. SumIF and AverageIF (9:02)
Functions exercise instructions (1:29)
Welcome to the Concatenate function (3:01)
Quiz question: Test your knowledge on the concatenate function
The IF Function (12:25)
Introduction to charts (1:49)
Inserting a chart (6:04)
Chart exercise instructions (1:11)
Charts (And more) Solution video (5:09)
Formatting data into a table (7:03)
Formatting data into a table. Part 2 (5:20)
Function error in next tutorial
The If/And/Or functions. Part 1 (8:26)
Quiz question: Test your knowledge on the IfAndOr function
The If/And/Or functions. Part 2 (3:52)
Quiz question: Test your knowledge on the IfAndOr function
Introduction to printing (0:51)
Printing your first spreadsheet (9:37)
Quiz question: Test your knowledge on printing
Printer settings (1:35)
Printing the second spreadsheet. Solution/exercise (4:23)
Building a Navigation pane (9:33)
Quiz question: Test your knowledge of building a navigation pane
Vlookup (9:38)
Subtotaling data. Part 1 (9:41)
Subtotaling data. Part 2 (6:51)
"Goals" Exercise instructions (2:56)
Goals solution video! (11:33)
Advanced printing
Advanced printing (8:36)
Collation and more... (6:20)
Advanced printing. Part 2 (9:22)
Advanced printing. Part 3 (9:20)
Welcome to macros
Introduction to macros (1:33)
Creating your first macro (12:11)
Create a macro with cell referencing (6:11)
Creating macro shortcut icons on the ribbon (4:27)
How to save a macro enabled Workbook. Best practices (2:14)
Using PMT and IPMT functions for a Mortgage
Using the PMT function for a mortgage (8:20)
Using the IPMT function for a mortgage (7:54)
What if analysis
What if analysis. Data table (7:50)
What if analysis. Goal seek (6:49)
What if analysis. Goal seek formulas (4:35)
3D maps
Introduction to 3D maps (4:18)
3D maps. How to use. Part 1 (11:54)
3D maps. How to use. Part 2 (11:57)
Link to Microsoft web page with data
MUST know functions
Must know functions. Part 1 (8:28)
Must know functions. Part 2 (8:41)
Must know functions. Part 3 (5:53)
Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 1 (7:18)
Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 2 (6:01)
Excels drawing tools and more (6:14)
Charts in Excel
Introduction to Charts in Excel (1:18)
Charts in Excel. Part 1 (5:19)
Charts in Excel. Part 2 (5:58)
Charts in Excel. Part 3 (10:18)
Inserting sparklines and more (11:54)
Charts solution video (8:48)
Sorting large amounts of data
Freezing the panes and more! (8:19)
Sorting the data (Exercise instructions) (2:23)
Sorting the data (Solution video) (5:33)
Filtering and analyzing the data. Part 1 (7:19)
Filtering and analyzing the data. Part 2 (6:25)
Deleting duplicate data, Concatenating and more!
Locating and deleting duplicate entries (4:33)
Concatenate continuation training (5:56)
How to use the "DateValue" attribute within the IF function (4:55)
Working out true cost. PMT & IPMT for Finance
Calculating the payment with the PMT Function (5:45)
Exploring true cost (4:26)
Calculating total cost (6:12)
Using the 'IPMT' function to work out interest (7:59)
Inserting a chart for reference (Car Finance) (5:19)
Welcome to Pivot tables and Pivot Charts
Introduction to pivot tables and charts (0:57)
Source data checklist and build your first pivot table (7:12)
How the interface works (The field list) and more! (10:58)
Inserting our last Pivot table, charts, and beginning on our dashboard (5:37)
Building a dashboard and inserting slicers (11:07)
Link to Microsoft web page with data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock