Google Sheets Formulas Tutorial: How to Use Formulas and Functions in Google Sheets
Hey friends, I’m Tasia Custode, and in this video, I’m breaking down how to use functions and formulas in Google Sheets. You’ll learn the difference between formulas and functions, some basic math equations, how to combine column information, date and time functions, and more. Consider this video your Google Sheets Beginners Bible.
⏰ TIMECODES:
00:00 - Intro
00:33 - Difference between formulas and functions
00:51 - Basic math equations
03:21 - SUM function in Google Sheets
05: 44 - Count function in Google Sheets
06:08 - Min and max functions in Google Sheets
07:00 - Average, median, and mode functions
07:45 - Combine column information
09:24 - Date and countdown functions and formulas
10:51 - Handy shortcuts
👀 WATCH OTHER GOOGLE SHEETS VIDEOS:
📹 Google Sheets Tips for Productivity: https://youtu.be/k_jRRyKP92U
📹 Google Sheets Keyboard Shortcuts: https://youtu.be/zDZt0pchE8A
GOOGLE SHEETS FUNCTION LIST:
https://support.google.com/docs/table/25273?hl=en&ref_topic=1361471
📷 YOUTUBE CAMERA GEAR:
Panasonic GH5 Lumix Kit: https://geni.us/teLeWzz
Sony ZV1 Camera & Vlogging Kit: https://geni.us/B6pj
Rode VideoMic Pro+: https://geni.us/yfXsy
Vanguard Alta Pro Tripod: https://geni.us/3Ougb
Sony E Series SD Card: https://geni.us/BBi1Yxd
Neewer Ring Light Kit: https://geni.us/3ho03WZ
Neewer Desktop Ring Light: https://geni.us/quBpGZ
Neewer Camera Light: https://geni.us/RyRTA
⌚️ MY APPLE WATCH BAND: https://geni.us/1IMxe
👚SHOP MY MERCH: https://tasiacustode.myspreadshop.com/
✅ RECOMMENDATIONS:
🎦 I use Tubebuddy to grow my YouTube Channel. Learn more:
https://www.Tubebuddy.com/tasiacustode
🖼I use Canva to create all my YouTube thumbnails. Learn more: partner.canva.com/jWXqOv
🎞 I use Camtasia for all my screencasting needs: techsmith.z6rjha.net/2rrRvG
⚙️ DOWNLOAD MY DIGITAL TOOLKIT:
https://www.tasiacustode.com/digitaltoolkit
🤝 CONNECT WITH ME:
📸 Instagram - https://www.instagram.com/tasiacustode/
👍🏻 Facebook - https://www.facebook.com/TasiaCustode
🖥 Website: http://www.tasiacustode.com/
*Some of these links are affiliate links, meaning I may make a small commission if you sign up or purchase a product using these links. Don’t worry, this is at no extra cost to you! Thank you so much!
Did you find this video helpful? Have questions or comments? Leave your thoughts in the comment section below.
#GoogleSheets #ProductivityTips
If you like this video, give a like, a share, or subscribe for more tech tips and app reviews.
Тэги:
#Google_Sheets_formulas_tutorial #how_to_use_formulas_and_functions_in_google_sheets #how_to_add_google_sheets_function #how_to_add_google_sheets_formula #google_sheets_function_tips #google_sheets_formula_tips #google_sheets_tips_and_tricks #best_google_sheets_tips #google_sheets_templates #how_to_use_google_sheets #google_sheets_formulas #google_sheets_functions #google_sheet_hacks #google_sheets_for_beginners #google_sheets_basics #tasia_custode #google_sheetsКомментарии:
Hey friends! What are your most-used functions and formulas in Google Sheets? Comment below!
Ответить
❤
Ответить
Hi Tasia I am usually pretty good with google sheets I had combined 4 columns and when I go =sum(c15-c18) it is off by one number it gives me 24
Ответить
Tnx
Ответить
You are amazing. I was given a task at work and for a minute I thought it was going to be difficult. You made it soooo easy. I subscribe to keep on learning with you. Thank you so much!
Ответить
❤ do you have a following long template so I can practice please.
Ответить
Can I collect countif among several sheets?
Thanks
Hi Tasia
how to do subtracting % , like for example my first cell would be 100 usd in the next cell i would like to have that but -15% = 85
Thanks in advance
HELP! I need a formula for google sheets. I have multiple columns that will sometimes have dates in them. I need column "O"'s formula to subtract from the date in column "M" the date in column "L" if there is a date in it, if not the date in column "K" if there is a date in it, and if not the date in Column "J". There will always be a date in "L, K, or J" if there is a date in Column "M" and may have a date in multiple columns but I only need it to subtract from the one with the date in the order specified. Can anyone help me with this?
Ответить
assalam o alaikom dear Tasia please share one video of google sheet formola of profit and lose ( kata )
Ответить
How to use URL to move data between sheets.
Ответить
Could you help with this?: I want to filter on two columns. Where Column C is Blank or Column C contains only a comma; and Where column D contains either the word Red, Green, or Yellow. How do I accomplish this? Also, can I add on one more thing, after you filter on C and D, in Column F I want to take the first 4 letters of the text in Column F.
Ответить
Thank you Tasia. I think you are going to be a "teacher" for Halloween. 😁
Ответить
Tasia, You make learning fun And for Halloween I think you will be Adorable
Ответить
I see YOUR All video
..love u sister
Appreciate the passion you "teach". Waiting for next advanced video on Google Sheets!
Ответить
Awesome Tasia 😊
Ответить
Something new to learn every time from your videos. The combine column information is a massive time saver. Thank you.
Ответить
Thanks
Ответить
Thank you..
Ответить
