15 Functions in Google Sheets You NEED to know!

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!

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!

🔴 AFFILIATE LINKS:
(These really help make our content better at No extra cost to you)
My videos are made with Techsmith Camtasia.

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

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:

🔴 get CLASSROOM RESOURCES today:

[romankolyvanov]

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!

[leylabayraktar]

Very Inspirational, John. I Really Loved Listening To You Talk For 17 Minutes And 29 Seconds. I Had a Joyous Time. My Favorite Was The Sum. My Eyes Have Been Opened To The World Of Google Sheets. Thank You Master.

[melissabrito]

Thank you for taking the time to include the time stamps. I was able to go directly to the part of the video I needed help with. I appreciate you helping me save time!! Very thorough and knowledgeable!

[randallledbetter]

Spreadsheets and I, just like weed eaters have never gotten along with each other, until this video. Great explanatory video. Thanks!

[petewoodhead]

I'm not a teacher, but thankfully you must be and I'm finding this very informative. Thank you.

[dgvisual]

Super-video, Sethi!!! IMPORTRANGE is one of the functions that I often use to insert data from other sheets or other books and process them together.

[TyrantRC]

that last one 16:29 seems very useful when you need to grade students and you are too busy.

[lorenzoarodriguez]

I have been using spreadsheets for a long time; this was the simplest explanations I have heard, read and seen of some formulas that I have used before and always had to go back to review to understand. Thank you!

[dnanton]

Excellent explanation, I think one of the very powerful and great functions you left behind is the Query option. But your way of explaining all the functions and the examples are great, thanks for your effort, and keep up the good teaching :)

[daniellanazario]

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

[jieadee]

Translate and Sparkline! I went "Aaaaaww!" when I actually tried them.

[hoginiq]

Never have I ever thought that I would be as intersted as I am listenign to you educate us on the fumctions!!!! I can not decide which is my favorite. Sparkline is the coolest i think but then again i love the googletranslate!!!! I need tutoring lessons lol let me know

[dimasdjamaris]

That sparkline is so useful, i love that one XD

[saharaleebolo]

This is my favorite Google Sheet tutorial so far. Simple but so helpful!

[datarealmax]

I use the Sparkline function for various aggregate data in my work.
For example, it's very convenient to put a graph into a Cell row by row.

[davidguevara]

Not what I was looking for exactly, but a great video explaining some neat functions with excel! Would really love some functions dealing with statistical significance, like seeing what functions have the greatest impact

[anitaparkin]

Well explain and never have enough of your video.

[PepeTheFrog.]

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

[DarkMoonDroid]

I love the little graph in "Sparkline"! Now I just have to make a sheet doc that has numbers like that...

[NaomiGoldstein]

Thank you! This is cool. The sparkline is my favorite-- didn't imagine that or the translation