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)
"Main Workbook" exercises and more!
Introduction (6:05)
What version of Excel is this course based on? (2:05)
List of shortcuts
The basic layout of a spreadsheet (1:30)
How to manage cell size (2:46)
Dealing with data in your spreadsheet (3:49)
Getting the most out of the Auto-fill feature (2:39)
Main Workbook Material
The three different types of references. Part 1 (9:08)
The three different types of references. Part 2 (5:09)
Introduction to writing and using formulas and functions (0:46)
Formulas and Functions (14:59)
Practicing what you've learned (5:27)
Welcome to the concatenate function (3:01)
The IF Function (12:25)
Filling in the totals (6:42)
Formatting the December spreadsheet (5:58)
Inserting a chart, December Spreadsheet (3:54)
Formatting the monthly income spreadsheet (5:53)
Chart insertion and Formatting Monthly Income (8:39)
Function error in next tutorial
The 'If/And/Or' Functions. Part 1 (8:26)
The "If/And/Or" Functions. Part 2 (3:52)
Building a navigation pane (9:33)
Formatting the yearly gross spreadsheet (2:34)
Chart insertion and formatting. Yearly gross (6:55)
Formatting the Titles (3:24)
Vlookup (9:38)
Subtotaling data. Part 1 (9:41)
Subtotaling data. Part 2 (6:51)
Selecting the correct page size
Printing the first Spreadsheet (9:57)
Printing the last spreadsheets (8:17)
"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)
Using PMT and IPMT Funtions to work out a mortgage
Workbook for exercise
Using the PMT function for a mortgage (8:20)
Using the IPMT function for a mortgage (7:54)
3D Maps
Workbook for exercise
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
Welcome to macros
Workbook for exercise
Introduction to macros (1:33)
Create 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 Workbook with macro enabled. (And the risks) (2:14)
MUST know functions
Workbook for exercise
Must know functions. Part 1 (8:28)
Must know functions. Part 2 (8:41)
Must know functions. Part 3 (5:53)
Workbook for exercise
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)
Lets draw and more! (6:14)
Charts in Excel
Introduction to charts in Excel (1:18)
Workbook for exercise
Charts in Excel. Part 1 (5:19)
Charts in Excel. Part 2 (5:58)
Charts in Excel. Part 3 (10:18)
Workbook for exercise (And pictures)
Inserting sparklines and more (11:54)
Charts solution video (8:48)
Using the 'What if Analysis' to calculate changes in data
Workbook for exercise
What If analysis. Data table (7:50)
What if analysis. Goal seek (6:49)
What if analysis. Goal seek formulas (4:35)
Deleting duplicate data, Concatenating and more!
Workbook for exercise
Locating and deleting duplicate entries (4:33)
Concatenate continuation training (5:56)
How to use the "DateValue" attribute within the IF function (4:55)
Sorting Large Amounts of Data
Workbook for exercise
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)
Welcome to Pivot Charts and Tables in Excel
Pivot tables and charts intro (0:57)
Workbook for exercise
Source data checklist and building 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)
The 4-Point Source Data Checklist (6:29)
Creating a Pivot Table: Part 1 (7:34)
Creating a Pivot Table: Part 2 (4:28)
Pivot Tables: A little Extra Information (2:46)
Pivot Table and Chart: Scenario 1 (8:19)
Pivot Table and Chart: Scenario 2 (5:51)
Pivot Table and Chart: Scenario 3 (5:23)
Building a Pivot Dashboard (4:55)
Building a dashboard and inserting slicers
Complete and Continue