The Full Google Sheets Advanced Level Tutorial - Free Course

If you want to learn Google Sheets to an advanced level, this full tutorial for is for you. This video used to be a paid course but we have now put it up on Youtube as a free course.

To help you learn, grab a copy of our free practise spreadsheet here: https://bit.ly/3tmDLeT

If you would like to learn more about Google Sheets check out our other full-length tutorials:
►► Beginner:    • The Full Google Sheets Tutorial for B...  
►► Intermediate:    • The Full Google Sheets Intermediate L...  

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Timestamps:
00:00 The Full Google Sheets Advanced Level Tutorial - Free Course
01:28 What is an array?
02:48 Curly Brackets
11:30 ARRAYFORMULA function
18:25 ARRAY_CONSTRAIN function
19:55 MMULT function
24:26 TRANSPOSE function
25:59 SUMPRODUCT function
30:25 FILTER function
35:19 SORT function
38:44 DSUM, DAVERAGE, DCOUNT, DCOUNTA functions
43:11 EFFECT, NOMINAL, INTRATE, RATE functions
50:29 FV, NPV, PV functions
54:16 IRR, NPER, PMT, YIELD functions
01:00:08 GOOGLEFINANCE, GOOGLETRANSLATE functions
01:03:15 QUERY function with with SELECT, AND, ORDER BY, LIMIT functions
01:12:43 SPARKLINE function
01:17:52 IMPORTHTML function
01:20:46 IMPORTRANGE function
01:23:37 Combining Curly Brackets, ARRAYFORMULA, SORT, FILTER and ARRAY_CONSTRAIN functions
01:30:49 Fixed Named Ranges
01:38:06 Dynamic Named Ranges
01:43:54 QUERY with Names Ranges
01:46:21 Basic Macros

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

The Full Google Sheets Advanced Level Tutorial - Free Course