# 15 Functions in Google Sheets You NEED to know!

Please login to search this video.

Google SHEETS is incredibly powerful. Are you using these functions to save time, get work done and be more productive? Here are 15 functions in Google Sheets you need to know!

Timestamps:

0:00 Intro

0:25 Why these functions?

0:41 SUM()

1:08 The info window of Functions

1:28 SUMIF() Set conditions for your function

2:35 Joining strings or text together using these three functions.

2:55 CONCATENATE()

3:55 JOIN()

4:54 TEXTJOIN()

5:30 COUNT() Count how many numeric values there are in the selected range

6:14 COUNTA() Count the number of values (All values)

6:47 COUNTIF() Set conditions before counting the number of values

7:21 AVERAGE() Whats the average of the selected range?

7:52 TODAY() Whats the date today? Interactive and updated automatically.

8:35 DATE() Use a date using a set format.

9:23 Find out the difference in days between today and a set date in the past or future.

9:55 VLOOKUP() Use this to find specific information from a larger dataset.

11:20 SPARKLINE() The number one function needed for a quick visual chart within a cell.

11:58 GOOGLETRANSLATE() Translate any language into another, automatically!

12:37 GoogleTranslate to automatically create flashcards in Google Slides (Link: https://youtu.be/4J8WJDTjA9Y)

14:04 CHAR() Use a Unicode Character incells. This is great when creating Bullet points and lists. List of all characters: http://www.unicode.org/charts/

15:46 UNIQUE() Get an overview of all unique results

16:15 RANDBETWEEN() Get a random number to use in class

Let me know in the comment section which of these is your favorite and when you use it the most? How are you implementing the use of Google Sheets in the classroom and what are tips and tricks when using sheets? Let me know!

🔴 Don't forget to SUBSCRIBE today for more videos!

http://bit.ly/FlippedYT

Share this video with a friend: https://youtu.be/mRHlvRRERgs

🔴 AFFILIATE LINKS:

(These really help make our content better at No extra cost to you)

My videos are made with Techsmith Camtasia.

Get this amazing software here: http://tools.eduflip.net/Techsmith

✅ CHECK out MY PRE-SELECTED list of my ALL-TIME Favourite EDTECH TOOLS:

https://www.amazon.com/shop/flippedclassroomtutorials

Disclaimer: Some of these links are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you. Some links will link out to one of my websites. These videos have been made for educational purposes and all views or opinions expressed are my own.

🔴 Find me on SOCIAL MEDIA:

My Official EduFlip Website: http://eduflip.net

Follow me on Twitter: https://twitter.com/sdcthailand

Find me on Facebook: http://bit.ly/FlippedFacebook

🔴 get CLASSROOM RESOURCES today:

My TPT Store: https://www.teacherspayteachers.com/Store/Eduflip

source

Good information thank you

Fantastic information! This will be my first time using Google Sheets on this level. Can't wait to give all of this a shot!

Thanks for these classes

hello mister professor like human being . i have a question . i dont know if this is possible but .. who knows . I ll use an example to explain myself , I put A1 a name and a value | xxxx xxxxx 5000 | if its possible i need google sheets to take only the number from A1 negativate it and put it to A2 like -5000. is this possible ?

Loved the Sparkline! Would like to see a bit more of the vlookup. Thank you!

I have columns with the heading Grade Earned CR Potential CR and GPA Points. Is there a function to get the GPA points to pop into that column after the Grade Earned has been entered?

Good explanation sir

i want to add .001 to each cell (x-axis) how can i do that quickly?

great video, I hope you consider making new videos about the char function.

Hello how do you do TSXV on google sheets?

Is it possible to find cells whose total will be between 100 to 200 with this data

73

79

67

32

52

58

43

54

57

52

75

40

35

75

68

44

74

62

41

55

Importrange

Can't stand Google sheets, my employer uses it unfortunately, Excel is the one

Great vid mate. can you help me? I added a color selection ccolumn, in there I want the customer to be able to select a color and quantity from 1-6. its for my vinyl and decal sales

I discovered vlookup recently and I love it.

Sparkline looks super useful!

And I don't know how to use the ampersand operator, but it looks like what I was looking for. Going to search for more info right now.

You should explain "FILTER" this was the most difficult for me to correct the syntax

Please some buddy help me i want to make one formula i have 1 digit if it is less than 1.5 it is considered as 1 if it is greater than 1.5 considered as 2 what formulas should I use?

Google maps integration. Now a script can do that but it'd be the best to integrate as TRANSLATE is integrated.

FILTER is also a function that pushes the EXCEL boundaries.

This entire video is full of quality content. Thank You for this.

Translate… I'm a homeschool mom and that tidbit was everything I didn't know I needed. Thanks!

Wonderfulllllll

Sir please make a vedio

About how make candle stick chart in google sheet

This was so helpful, thanks!

Impressed of sparkline feauture

thanks, You should add INDEX & EQUIV to replace Vlookup when the first column is not the key, and also INDIRECT, Indirect save my life lot of time.

great explanation. thanks,. greetings from Ouarzazate, Morocco

Hi,

Thanks for the great video.

I have 2 Google sheets files using the same template[which means the column names are same in both of them]. But they contain different records/data. How do I find the difference between them in an easy, quick way?

Attaching a sample file[which is in MS Excel]for clarity.

Regards

Would love to have you cover how do you use the insertHTML() function?

My favorite function that was not mentioned here is =Query(). This function lets you use Query Language (kinda like SQL, if not exactly like SQL). That may seem a little scary at first if you don't know what SQL is, but it's actually pretty simple! You can basically create pivot tables by using this function and then leverage that in other functions. A simple example of how you can manipulate a table of data by using the Query function: Let's say you have 3 columns of data and you want to represent the data in another sheet but without column B, for example (that would look like this: =Query(A1:C, "Select A,C"). Or maybe you want to show columns in a different order; A,C,B, and order them by C and maybe filter out any cells that have a value of 1 in Column B. This last example would look like this: =Query(A1:C, "Select A,C,B Where B !=1 Order By C"). If you take a little bit of time to learn the syntax for this function, it goes a long way!

It's a very helpful tutorial. I am now taking the next step but I'm just stuck on a certain formula. how can I hide the columns that depend on a cell value? For example, I made a calendar from January to December and the first cell is a data validation of months. If I choose January, I want the rest of the months to be hidden. Is it possible? Thanks for this tutorial.

What if I want my checklist to just be red boxes and if I complete one it turns a different color like green. Also on top of that if goes to a separate formula where I have a percentage setup because there’s 203 cards I need to collect but so far I only have 30 boxes checked. Please let me know!

This video was FANTASTIC. Thank you so much. Very easy to follow along.

ARRAYFORMULA….the biggest function there is…where is it?

Hi, really useful video (thank you!) – I'm trying to create a formula to get data to pull from through from one sheet/tab to another. Any ideas on how I can achieve this? I keep getting a #VALUE error message. thanks

thank you

thank you mister

can you show us/me how I can create a vlook up or a formula where I can enter a zip code in a cell and the cell next to it can produce the appropriate town and state? thanks

I like the vlookup function.

I have researched how to make numbers round but I cannot figure out how to make them automatically round if that makes sense. I have a google sheet made for payroll and want it to automatically round ALL numbers to the nearest penny. Does anyone know how I could give a command to every cell to do this?

sumifs