# 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”

1. Dinu Viorel

Very good courses!