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!
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
Видео 15 Functions in Google Sheets You NEED to know! канала Flipped Classroom Tutorials
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
Видео 15 Functions in Google Sheets You NEED to know! канала Flipped Classroom Tutorials
Показать
Комментарии отсутствуют
Информация о видео
9 июня 2019 г. 20:35:09
00:17:30
Другие видео канала
10 Google Sheets Tips You DON'T Want to Miss (2021)5 Google Sheets Tips Every User Should Know!How to Create a Dashboard in Google Sheets (10 steps) - Query FormulaBasic Excel Formulas and Functions You NEED to KNOW!Google Sheets IF & IFS Functions - Formulas with If, Then, Else, Else If StatementsMake Your Google Sheets Look PRO in Under 10 Minutes!Google Sheets Advanced TutorialGoogle Sheets BEATS Excel with THESE 10 Features!Google Sheets Tutorial - Designed for BeginnersGoogle Sheets Beginner TutorialGoogle Sheets - Linking Data Between Sheets (Workbooks, Files) & Other Worksheets (Tabs)Top 10 Google Sheets Tips for Productive Professionals (2021)15 Tips and Tricks in Google Docs for Beginners AND Power UsersGoogle Sheets - Inventory Management System TemplateHow to Use the FORMATTING TOOLS in Google Sheets | A Teacher's Guide #1 | INTERACTIVE TUTORIALGoogle Sheets - Full TutorialExcel Formulas and Functions TutorialGoogle Sheets Formulas TutorialAutomatic number sequence with formula SEQUENCE in Google Sheets