15 Functions in Google Sheets You NEED to know!

Video Description

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