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: [ Ссылка ])

14:04 CHAR() Use a Unicode Character incells. This is great when creating Bullet points and lists. List of all characters: [ Ссылка ]

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!
[ Ссылка ]

Share this video with a friend: [ Ссылка ]

🔴 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: [ Ссылка ]

✅ 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:
My Official EduFlip Website: [ Ссылка ]
Follow me on Twitter: [ Ссылка ]
Find me on Facebook: [ Ссылка ]

🔴 get CLASSROOM RESOURCES today:
My TPT Store: [ Ссылка ]

свернуть