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 KZread as a free course.
To help you learn, grab a copy of our free practise spreadsheet here: 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...
►► Intermediate: • The Full Google Sheets...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
Пікірлер: 12
Thanks for the nice clear examples. First lesson down and I've already learnt something new - I'll be working through all your lessons!
Great video and shared sheet. I learned a number of new capabilities and modified the sheet with my own notes and additions. One thing that I'd like to point out in the financial formulas, if you are dealing with monthly payments or cash flows, you should adjust the annual interest rate. I usually just divide the annual rate by 12 within the cell to make it explicit what's happening.
Fantastic.
very good course. I really appreciate effort put in it. Thank you
@TheBookkeepingChannel
2 жыл бұрын
You're very welcome!
This is worth much more than free tutorial. Thank you, even if I thought i knew a lot, i didn't. Thank you one more time and wish you the best! I will just dive into your tutorials after this lesson to look for more inspireing things. Thank you
@TheBookkeepingChannel
Жыл бұрын
You're very welcome!
thank you for this; so valuable
@TheBookkeepingChannel
Жыл бұрын
You're so welcome!
Thank you Mark. Such a wealth of knowledge and delivered comprehensively and easy to understand. Is there a way that one can input a date that counts days up daily with the calendar? ie. I want to insert into a cell a number that increased by one daily from a set date. Thank you in advance.
Enjoyed the course. Very useful. My only request is that you may zoom the formulas so that e can see much clearly.
@TheBookkeepingChannel
Жыл бұрын
Yeah I recorded this ages ago when I didn't know how to do that 😂