MASTER Google Sheets for FREE | Part 3 - Advanced

MASTER Google Sheets for FREE | Part 3 - Advanced

❤️ MORE FREE STUFF - to continue learning about Google Sheets check out these videos:

Welcome to our completely free advanced level Google Sheets course! If you want to take your Google Sheets game to an advanced level, this video is for you. This full-length tutorial will guide you step-by-step on how to master the advanced concepts needed to become efficient and productive in Google Sheets.

So go ahead and grab a copy of the practice file so you can learn by doing and make sure you check out the Beginner and Intermediate level tutorials if you need to go over the basics.

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

Timestamps:
00:00 MASTER Google Sheets for FREE | Part 3 - Advanced
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

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

⚖ DISCLAIMER
Information provided in our videos does not constitute financial, taxation, legal, business or other professional advice. If you make a purchase through an affiliate link provided here we may receive a commssion. We do not accept any responsibility or liability for purchases made through third-party vendors, websites, or services. It is your reponsibility to review and understand the terms, conditions, and policies of third parties before making any purchases.

[anakop]

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

[SimonBaier]

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.

[lafamillecarrington]

Thanks for the nice clear examples. First lesson down and I've already learnt something new - I'll be working through all your lessons!

[JGSLandscaping-ey]

great tutorial. i will be going back again and again for reference. However, I do have a question. I want to add a note to a cell in google sheets, but I want the note to be a pdf. Is that possible and how on earth do I do it. All I get is the option to write words in the note. Your help would be greatly appreciated. Thank you for your time.

[DarrylHuntley]

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.

[hovno]

very good course. I really appreciate effort put in it. Thank you

[mahamohan]

Enjoyed the course. Very useful. My only request is that you may zoom the formulas so that e can see much clearly.