How to use Formulas and Functions in Google Sheets

Google Sheets formulas and functions for beginner's 2021 tutorial. I will show you how to use formulas and functions in Google Sheets. I will start with basic math formulas in Google Sheets and show you some of the very popular and powerful functions. Use the timestamps below to help you navigate through this video.

0:00 Intro
0:49 Basic math formulas
3:35 Starting with the SUM Function in Google Sheets
7:05 The COUNT function
8:50 AVERAGE, MEDIAN and MODE functions
10:32 MIN and MAX functions in Google Sheets
11:19 Functions and formulas with Date and time in Google Sheets
14:04 Using formulas to combine columns
15:44 If statements in Google Sheets
19:01 How to use VLOOKUP in Google Sheets
22:12 Conditional functions (SUMIF, SUMIFS, COUNTIF etc.)

[danalane]

Thank you for this! I had totally forgotten how to do basic sum functions in spreadsheets (it’s been a long time since high school!), and I was struggling to set up my accounting sheets for my small business. You just laid it out perfectly. Now I can set up my sheets to keep track of inventory and costs more efficiently.

[LowRotor]

This was great! I’m working on building a real estate investment calculator with zero sheets experience and this was very helpful. Wish I could chat with you for some more information but I’ll keep watching your videos!! Thanks for the tutorial

[rocknroy]

Good teachers are such gifts. Thank You.

[pamtaylor-harris]

The best video I've seen on functions and formulas for Google Sheets. Your instructions are logical and easy to follow. Thanks for the worksheet example download and the showing the learn more tool.

[marwaghith]

Your video is the best and most favorable video I've watched concerning formulas as it was step-by-step and easy to follow. Big thanks for your constructive content! it was so helpful.

[gina]

This is by far the best. You explained well how to follow the formula guide. Thank you! I will surely come back some time for a thank you tip.

[emilharden]

Excellent overview of formulas - clearly explained, great examples.

[lizblank]

Thank you, so glad I found you. Had no idea why people used spreadsheets before this video apart from adding!

[kirstentownley]

You are such a great teacher! Thank you!

[ReneeThompson-moqj]

Your are such a great google sheet instructor for these formulas, I would love ❤️ for you to show more formulas using on a couponing spreadsheets, budget sheets please.

[kenbahati]

Excellent teaching! Very practical. Thank you!

[diyaghosh]

Thank you so much for providing the spreadsheet along with the video. enjoyed this one too.

[burhanuddin]

perfect video to learn about google sheet,

[abdofeduconsult]

Excellent Google sheet Instructor!. Keep doing well. Thanks for sharing your knowledge.

[vendeirenea]

OMG THANK YOU SO MUCH!! 😭😭 THIS IS VV HELPFUL!

[orainedittmar]

Great way to learn. How do I total columns and not double add the subtotals in said column total?

[victoriagarcia]

thank you, you simplified the best what i am having trouble is how to saved the formulas so i don't have to be adding constantly, i am working in a time sheet so what to be able to add the time and sum every week logins and add totals . Thank you for your help

[natividaddelfin]

Hi, I like how you explain the subject

[bhanupratapsingh]

very useful video, thanks for posting.

[kimaffleck]

Just a suggestion. You use "Go ahead" quite a lot. Changing it up or omitting it all together would be nice.