Advanced excel course – Table of contents

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