Google Sheets Formulas Tutorial

Google Sheets Formulas Tutorial

Kevin Stratvert

3 года назад

364,257 Просмотров

Learn how to use formulas and functions in Google Sheets.

👋 Additional resources:
- Access the spreadsheet I used if you'd like to follow along: https://docs.google.com/spreadsheets/d/1lRrxezy1dKcJLrZot5BxBBKffEP8Ys-c6qUMirM9OTA/edit?usp=sharing
- Read about all functions available in Google Sheets: https://support.google.com/docs/table/25273

⌚ Timestamps
0:00 Introduction
0:33 Add & formula basics
2:08 Subtract
2:48 Multiply
3:50 Divide
4:37 Bring it all together
5:44 Min
6:16 Max
6:38 Mean
7:23 Median
7:52 Mode
8:24 Sum
9:37 Sumif
11:09 Count
12:01 Counta
12:33 Countif
13:26 Concatenate
14:41 If
16:41 Vlookup
19:29 Convert
20:50 Today & Now
21:30 Len / character length
22:25 Wrap up

📃 Watch related playlists and videos
- Google: https://www.youtube.com/playlist?list=PLlKpQrBME6xLGL3Ty_1Wbd3nTZ_q_OKFQ

🚩 Connect with me on social:
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818

🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1

🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com

🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

Тэги:

#kevin_stratvert
Ссылки и html тэги не поддерживаются


Комментарии:

Kudzai
Kudzai - 09.09.2023 18:21

Thanks for this. I'm working towards becoming a data analyst and this has been most useful. You have my support, I'm subscribed.

Ответить
roblox with Jack
roblox with Jack - 29.07.2023 11:57

how do i use multiplication symbol?

Ответить
Carolyn Callahan
Carolyn Callahan - 25.07.2023 18:00

Great video, thanks Kevin!

Ответить
Trisha Huckabee
Trisha Huckabee - 27.06.2023 02:07

I need to track accrual and usage of sick time for employees based on actual hours worked. For every 40 hours worked, they accrue 1 sick hour. How is this done in google sheets under the total hours?

Ответить
Katherine Humphries
Katherine Humphries - 05.06.2023 13:55

Kevin, so well explained! Great videos. Thank you.

Ответить
Tyler Michalek
Tyler Michalek - 24.05.2023 10:10

Nice tutorial

Ответить
Fredrick Otieno Awino
Fredrick Otieno Awino - 29.04.2023 21:25

very insightful and hands on google sheet skills there. Thanks for giving this out to us

Ответить
Vikentijs Lauruts
Vikentijs Lauruts - 28.04.2023 00:13

Hi Kevin
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

Ответить
2136thenatureboy1
2136thenatureboy1 - 08.04.2023 14:54

Always enjoy watching your educational videos, always helpful!

Ответить
Flawless Myles
Flawless Myles - 25.03.2023 05:11

thanks for the video. I am software developer and I heard a word concatenate[combining two variables] and turn into new one!

Ответить
ADWAITH K DINESH
ADWAITH K DINESH - 23.03.2023 08:11

Thanks for the video man. Really helped me a lot. Actually I heard that the google sheet has too many options and now I learned everything you said. Thank you. 🤝
Your tutorial is really amazing.

Ответить
Ztir23
Ztir23 - 15.03.2023 18:28

So this is the reason why we hired software engineer my mind is dizzing right now

Ответить
Norwina Angeles
Norwina Angeles - 08.03.2023 05:31

Me and my husband learned a lot from this video! Thanks and keep up the good work.

Ответить
Bernie Pascual
Bernie Pascual - 05.03.2023 11:46

I really enjoyed this video and how this is presented to the viewers. Thank you so much!

Ответить
asifpatni
asifpatni - 09.02.2023 19:43

Dear Kevin,
I need your help in google sheet, how to insert blank row formula/automatically between data in google sheet.
For Example :
I have my working data on google sheet with 7 columns a thousand rows and in my 4th column has a city's name and I want to insert a blank row after the city's name change in my google sheet.
Excel has that option to select the whole sheet and insert a blank row but I am a new user of google sheet and it's difficult for me for my work.

I hope you help me for this matter

Ответить
Teddy W.C harawa
Teddy W.C harawa - 08.02.2023 16:31

You are awesome. Heaven honor you!!

Ответить
K-RAY
K-RAY - 08.02.2023 02:02

hey i have a serious and important question about a project I'm working on... long story short , I have a checklist of materials that have at least 3 separate columns of different information.. what i need is to be able to move any checked items too a different area or a new page entirely.. so basically if something is checked off i need that item along with the 3 columns of info it comes with, to be projected somewhere else in a "owned" category

Ответить
Mr. Serenity
Mr. Serenity - 30.01.2023 21:47

Hi hi holy moly this was concise and educational ! Muchos thanks !!

Ответить
Jean-François Regnard
Jean-François Regnard - 26.01.2023 19:10

This is an excellent tutorial. Thanks, Kevin !

Ответить
jenna allison
jenna allison - 21.01.2023 21:50

How do you add 30 days to the date in a certain cell?For example, one cell has a start date and the next cell should be the date 30 days after the start date. I also need it to calculate a deadline, which is the last day of the month that would be 30 days after the start date. I hope that makes sense. If my start date is January 10, the 30 days date would be Feb 9, and the deadline date would be at the end of that month, so Feb 28. Can you please help me figure out a formula?

Ответить
Mahmoud Taha
Mahmoud Taha - 21.01.2023 15:35

Thanks bro❤️

Ответить
Grim_Reaper 420
Grim_Reaper 420 - 19.01.2023 03:37

I’m just here to see how to find the mean median and mode for specific numbers bro

Ответить
VivaLasVeggies
VivaLasVeggies - 17.01.2023 22:24

When adding the addition formula, how do I make it so it continues to add numbers as I add more to it? Instead of doing it manual to add two rows?

Ответить
Casmil Murengezi
Casmil Murengezi - 28.12.2022 13:57

thank you! it was so helpful Kevin

Ответить
Overblown Knight
Overblown Knight - 07.12.2022 11:16

I'm trying a calculator with a twist ( I am trying to hide a number untill X happens ( for instance if a and b is filled then c will appear with the A+B answer

Ответить
Mark Cole
Mark Cole - 28.11.2022 22:45

Very well done

Ответить
Abdullah Al Gani Shakib
Abdullah Al Gani Shakib - 13.11.2022 09:43

very informative video.

Ответить
jo JH
jo JH - 06.11.2022 09:34

awesome very helpful

Ответить
Tommy D
Tommy D - 06.11.2022 07:14

Is there a way that if something is less than 3% or above 3% it can turn that block red or green?

Ответить
Brandon Hernandez
Brandon Hernandez - 23.10.2022 21:47

Love it, thank you

Ответить
Anton Lindberg
Anton Lindberg - 19.10.2022 11:32

Hi Kevin! Thanks for providing this video, I had started a budgeting project in excel that's associated with google forms. I realise chapter 11, =SUMIF was exactly the missing piece. Thanks once again.

Ответить
BMNA
BMNA - 11.10.2022 16:28

today...........

Ответить
George Rodriguez
George Rodriguez - 09.10.2022 20:24

Simple and informative.

Ответить
diamondxp
diamondxp - 06.10.2022 12:46

This helped me with a project. Well presented and straight to the point. I saved it for future reference. Kudos!

Ответить
Matthew Ybarra
Matthew Ybarra - 30.09.2022 21:39

Thank you Kevin!!

Ответить
EEEEEEEEE
EEEEEEEEE - 25.09.2022 17:13

you saved me i have an exam tomorrow and this video was very helpful

Ответить
Rene Romero
Rene Romero - 18.09.2022 03:02

Thank you Kevin!

Ответить
Webster Church
Webster Church - 16.09.2022 15:05

I don't ever leave comments, but this video was sooooo good! Informative, helpful, direct - thank you!!!!

Ответить
ankita yadav
ankita yadav - 15.09.2022 19:00

Thank you for the excel sheet kevin

Ответить
Leonie Amba
Leonie Amba - 11.09.2022 18:32

Thanks for creating this video, Kevin.
Very helpful.❤

Ответить
SNS GTE
SNS GTE - 06.09.2022 10:42

Thanks Bro, This was really a quick and important learning.

Ответить
James  Leleji
James Leleji - 26.08.2022 14:31

Hi , how can i get the developer tap in google sheets. I need to use combo box(Forms Control) becuae i want to create a Leave Tracker. Thanks

Ответить