Basics | Length |
Introduction to array formulas | 07:47 |
Working with cell ranges in formulas | 02:24 |
Array constants | |
Numbers | 02:22 |
Text | 02:47 |
Example | 02:32 |
Boolean | 01:41 |
Cell references | 10:26 |
Comparison operators | 07:29 |
Arithmetical operators | |
Examples | 06:02 |
Order of operation | 05:56 |
Functions | |
IF function | |
IF function - Basics | 04:57 |
IF function - examples | 04:32 |
IF function - dynamic values | 5:56 |
ROW and COLUMN function | 05:54 |
SMALL and LARGE function | 02:44 |
MIN and MAX function | 04:17 |
SUM function | 04:48 |
MATCH function | 07:24 |
INDEX function | 06:57 |
SEARCH and FIND function | 03:42 |
COUNTIF function | 07:12 |
COUNTIFS function | 07:14 |
SUMRODUCT function | |
Explaining function and example 1 | 04:19 |
Example 2 and 3 | 06:11 |
Example 4 and 5 | 03:48 |
ABS function | 02:00 |
FREQUENCY function | 10:32 |
SUMIF and SUMIFS function | 05:21 |
OFFSET function | 04:50 |
MMULT function | 22:43 |
Mod and quotient function | 15:05 |
Hyperlink function | 09:57 |
String manipulation | |
Left function | 03:57 |
Right function | 03:28 |
Mid function | 02:43 |
LEN function | 01:47 |
TRIM function | 03:10 |
Array formula example 1 | 05:24 |
Array formula example 2 | 05:07 |
Substitute function | 05:37 |
Array formula example 1 | 07:49 |
Array formula example 2 | 06:29 |
Replace function | 02:49 |
VLOOKUP function | |
VLOOKUP function | 04:17 |
VLOOKUP - array formula example | 04:25 |
Nested functions | |
MATCH and ROW function | 05:57 |
INDEX and MATCH function | 07:06 |
SUMPRODUCT and COUNTIF function | 11:07 |
Excel features | |
Excel defined tables | 08:24 |
Named ranges and dynamic named ranges | 08:20 |
Data Validation | 04:52 |
Count and compare | |
Count items | 10:25 |
Count unique distinct items | 12:34 |
Count duplicate items | 12:49 |
Compare values, records and tables | 11:23 |
Return values | |
Find and return values | 20:18 |
Filter unique distinct values and records (using criteria) | 24:05 |
Return values from a multi-column cell range | 26:09 |
Sort | |
Sort a column | 18:51 |
Time and date calculations | 13:28 |
Conditional formatting | |
Introduction | 04:25 |
CF Formula example 1 | 07:38 |
CF Formula example 1 | 02:49 |
CF Calendars | 08:23 |
CF Lookups | 07:22 |
Advanced examples | 05:35 |
Dashboard examples | |
Example 1 | 32:52 |
Example 2 | 28:42 |
Example 3 | 38:42 |
Example 4 | 30:55 |
Dashboard animation and dynamic pictures in invoice templates | 11:57 |
Dashboard - Financial markets | 33:34 |
Dashboard - Dynamic chart data range | 35:55 |
Dashboard - Choropleth maps | 28:25 |
Charts | |
Excel charts - basics, part 1 | 38:37 |
Excel charts - basics, part 2 | 31:21 |
Excel charts - basics, part 3 | 34:38 |
Dynamic data labels | 04:28 |
Highlight a bar | 03:44 |
Powerful formulas | |
Lookups - multiple conditions | 08:26 |
Find closest value | 10:48 |
Search multiple sheets | 06:35 |
Dynamic lists | 16:56 |
Filter visible cells | 04:10 |
Split data to multiple sheets | 06:07 |
SUMIF(s) - advanced examples | |
SUMIF and arrays | 07:56 |
SUMIFS and arrays | 06:25 |
SUMIF example 1 | 11:19 |
SUMIF example 2 | 03:04 |
Dynamic ranges | 12:29 |
Working with sequences | |
Array formula example 1 | 08:00 |
Array formula example 2 | 04:00 |
Array formula example 3 | 07:27 |
Array formula example 4 | 05:30 |
Array formula example 5 | 11:10 |
Find numbers which are closest to a total | |
Introduction | 05:03 |
Explaining formula 1 | 09:17 |
Explaining formula 2 | 06:14 |
Explaining formula 3 | 05:48 |
Example 2 | 08:38 |
Manipulating data | |
Rearrange data - example 1 | 03:39 |
Rearrange data - example 2 | 02:54 |
Rearrange data - example 3 | 07:36 |
Rearrange data - example 4 | 05:58 |
Advanced date and time calculations | |
Sum overlapping ranges | 11:34 |
Advanced time calculations | 10:46 |
Advanced date and time calculations | 16:24 |
Advanced date and time calculations, example 2 | 20:57 |
Count overlapping days across multiple date ranges | |
MMULT function | 15:37 |
FREQUENCY function | 15:04 |
Do you have an idea to share with me and other students or a workbook you are working on and you need help? Share it and we can together find a solution. | |
Share your ideas | |
Suggest a topic, function or anything else you want to know more about | |
Suggest a topic | |
Total: | 18:38:40 |
One thought on “Advanced excel course – Table of contents”
Leave a Reply
You must be logged in to post a comment.
Very good courses!