15 Functions in Google Sheets You NEED to know!

[@melissabrito5389]

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!

[@FlippedClassroomTutorials]

Glad it was helpful! I try to add timestamp to all my recent videos for just that reason! Hope you stick around for more videos.

[@ItsByko]

@@FlippedClassroomTutorials Very smart decision seeing that KZbin has now implemented time stamps into the video player. Appreciate the help!

[@leylabayraktar650]

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.

[@romankolyvanov4569]

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!

[@romydalapo1994]

This one's good. I'm amazed. Thank you for sharing

[@FlippedClassroomTutorials]

Use it all the time. Might have to make a follow up video. At the time of making this video I thought it would be a bit advanced but I think its too useful not to use

[@KLSe]

@@FlippedClassroomTutorials Thank you both.

[@randallledbetter1273]

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

[@dgvisual7476]

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.

[@FlippedClassroomTutorials]

Brilliant! Adding it to my comment submissions list ;-) feels like a follow up video might be the right thing... Thank you for sharing.

[@greeppl]

@@FlippedClassroomTutorials Agree, I'd also add QUERY

[@lorenzoarodriguez6048]

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!

[@rohanfernando5924]

All 15 were very useful. Thank you

[@FlippedClassroomTutorials]

Brilliant! Thank you!

[@Katelynn-e5b]

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

[@FlippedClassroomTutorials]

Such nice feedback. Thank you for this. It really made my day! I'm glad to hear you found the functions shared helpful, and yes, sparklines are pretty neat to work with

[@saharaleebolo2759]

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

[@dnanton72]

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 :)

[@FlippedClassroomTutorials]

Thank you for that ! Definitely adding that one to my follow up video! Look like there are many great examples of functions still to be added. Mind you, query is so powerful it might need its own video.

[@anitaparkin1422]

Well explain and never have enough of your video.

[@FlippedClassroomTutorials]

Thank you! Glad you find them all helpful.

[@carmenchapdelaine852]

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

[@FlippedClassroomTutorials]

Thank you!

[@Series7Exam]

amazing! Sparkline and translate blew my mind

[@FlippedClassroomTutorials]

Brilliant! Thank you for sharing.

[@PepeTheFrog2016.]

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

[@FlippedClassroomTutorials]

Glad you enjoyed it!

[@TyrantRC823]

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

[@pcl22000]

lol hhhhhhhhhhhhhh

[@MaryAguirre-r1o]

Super easy to understand. More please. 👏👏👏

[@FlippedClassroomTutorials]

Thank you!

[@dimasdjamaris6503]

That sparkline is so useful, i love that one XD

[@jaseminet8834]

Nice video and I appreciate the time stamps.

[@FlippedClassroomTutorials]

Glad you liked it!

[@Coraline-j1g]

All 15 were very useful. Thank you. Well explain and never have enough of your video..

[@Coraline-j1g]

I'm new learning basics BUT I can say this is a good knowledgeable video with good varieties . Thank u.

[@NaomiGoldstein7895]

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

[@petewoodhead52]

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

[@FlippedClassroomTutorials]

Great to hear you found this helpful!

[@acarde]

I very much like how you explain these functions. I'm hoping to find more. Thank you.

[@crypto4ever525]

great video!! Thanks!!

[@rosinmerman]

Thank you for all your help!

[@FlippedClassroomTutorials]

You're very welcome!

[@daniellanazario4029]

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

[@FlippedClassroomTutorials]

Great to hear you found it helpful!

[@zoegarcia8470]

Never heard of the function Randbetween! Definitely helpful to create an example data base to test certain formulas. Thank you for the video!

[@davidguevara8455]

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

[@jacquelinelara3626]

Loving the gtranslate function!!

[@kendra-chao]

This was such a helpful video! Thank you so much!

[@theenlteacher549]

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

[@gomakhanal2473]

That was very very helpful dear sir!! Thank u so much

[@khaltiwanger1]

Sparkline!!! Blows my mind!! Wow! I never knew!

[@nirmalasenerath]

your videos are so easy to understand.Thanks!

[@Hambxne]

Sparkline is incredible!! 11:22

[@G23teknik]

You are awsome, my friend. Great information presented in an easy to understand manner.

[@sergedm5553]

Thanks for these classes

[@jieadee4977]

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

[@FlippedClassroomTutorials]

Great to hear that!

[@bartoszkarpinski5902]

Great video!!

[@mazinsuroor6170]

Sparkline was the best in this video.....Thanks.

[@patrickmuvunyi722]

I love the If function. Thank you sir!

[@WilhelmFreidrich]

Excellent video, as usual!

[@PrinceWesterburg]

Well, I've been in computing for 40 years an I learnt something! :o)

[@tjtindal9077]

Very good crash course in some Google Sheets tricks. Thanks for the video!

[@DileepKumar-je1vw]

Thanks for awesome 15 fuctions

[@FlippedClassroomTutorials]

You're welcome

[@abzgarciava]

I love the Google Translate and sparkline. Very educational video :)

[@normahd]

Thank you very much for tips👍

[@FlippedClassroomTutorials]

No problem 👍

[@MadisonGutierrez-r5n]

Date() was my favorite function. Thank you!

[@suttirakchinda1813]

I like "google translate" function. Thank you for knowledge.

[@huawang190]

Great tutorial and very helpful!

[@FlippedClassroomTutorials]

Thank you

[@ClaireVillarreal]

This was so helpful, thanks!

[@FlippedClassroomTutorials]

You're welcome

[@jorgevasquez7816]

Very clear explanations. I would like to know more about Index and Match.

[@darlingngbayan344]

wow! very useful information. I learned new function key like sparkline, unique and randbetween. thank you so much...

[@shanstatedrd7295]

Thank you very much for your excellent explanation.

[@realIKON]

Quality content ! Thanks

[@asifazeem6552]

Excellent! Very valuable video. Thank you

[@tallyerptutorials]

Good 👍

[@rekhal5692]

Thank you for this class it will be very helpful

[@bruceholsted2127]

Brilliant presentation. Thanks for providing the list of topics with links. Great presenter.

[@ak5848]

Thanks a lot!! It was very useful

[@mariahenrique4672]

I'm new learning basics BUT I can say this is a good knowledgeable video with good varieties . Thank u.

[@hrishikeshnerlekar9652]

Absolutely very useful.

[@florenzgante7042]

Thanks, so helpful

[@FlippedClassroomTutorials]

Thank you!

[@rendaw79]

Thank you so much! I thought all that was going to be so much harder than that. I just made my first weekly/monthly tip tracker. So easy!

[@ultimateadaptation756]

Thanks for sharing. Sparkline!

[@PaulaGil-lz9kp]

awesome video. My favorite was google translate, but all very helpful, definitely going to be trying to use some of these! :) Thank you!!

[@angelrinoa6836]

Thank you for this very helpful video. My favorite function is Sparkline.

[@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.

[@bethebee4779]

Thanks a lot. very useful

[@FlippedClassroomTutorials]

Glad it was helpful!

[@ravindercherla]

Good explanation sir

[@frankiemendez9585]

Thanks for this.... a very big help indeed. Thanks

[@laurenhummel-lehfaculty1671]

This is excellent! Thank you!

[@teddyw.charawa8989]

You are amazing!! M grateful to God for you.

[@aanchalshrivastava5228]

That was great to have these functions explained so well,thanks .

[@PropertiDong]

Cool 😎 I like sparkline , Google translate , but overall ... All are nicely presented.

[@FlippedClassroomTutorials]

Thanks! 😃

[@balatsu1]

Thank you for taking the time to do this video.

[@DGA8787]

Filter functions changed my life.

[@FlippedClassroomTutorials]

It's brilliant!

[@danielwebb9766]

This was really helpful

[@joaoleitaoviagens]

great explanation. thanks,. greetings from Ouarzazate, Morocco

[@rosfelylaya9563]

Sparkling is amazing

[@FlippedClassroomTutorials]

I agree!

[@brianmorrison9168]

Is there a way I can change the highlight colour and line thickness to show the current cell. The current blue outline is proving quite hard for me to see. thanks !

[@gazislink]

Works are very creative i like it

[@FlippedClassroomTutorials]

Thank you

[@khadijasumaiya3374]

wow..this video is really helpful,, here are some of the functions which I have heard the first time,.thanks for this video.

[@DarkMoonDroid]

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

[@FlippedClassroomTutorials]

Haha brilliant :-) let me know when you get round to it :-)

[@tokyojerry]

Very interesting indeed. Thank you. My favorite function is Google Translate. I was not even aware this existed. When translating from English to Japanese it works beautifully, not just for single words but phrases as well. However, the translation becomes the native Japanese kanji characters system as it should. Much of the Japanese Kanji character system I can read and recognize but sometimes I can not. Q1. Is there a way to convert kanji characters into hiragana characters (simplified phonetics) into an adjacent 3rd column? Q2. Is it possible to activate text to voice as an alternative? I see you also have a flash card video as well. I will have a quick review of that to see if that might answer my inquiry. Thanks. Jerry. Tokyo, Japan.

[@jessejames4444]

What a great video, thank you!

[@carolineschroder5682]

I love this so much!

[@binitaagarwal60]

Very very helpful!

[@FlippedClassroomTutorials]

Glad it was helpful!

[@davidguevara8455]

Sparkling is pretty cool

[@FlippedClassroomTutorials]

I have to agree! So much it deserves its own video really

[@rachdc313]

Great vid!

[@FlippedClassroomTutorials]

Thanks!

[@jorgeirula2621]

Thanks, it was a great presentation.

[@kalyankumar8629]

all are useful, thanks for teaching this useful tutorial sir..

[@FlippedClassroomTutorials]

You are most welcome

[@ianjames6320]

Wow sparkling and translate both brilliant

[@jayakrishnanm7838]

thanks for this

[@akulanarayana5284]

Date and unique are interesting.Thank you 😊

[@FlippedClassroomTutorials]

You're welcome 😊

[@cnceeg]

It's magical and practical!

[@leekspinner]

awesome, thank you!

[@BronsonJM]

Google Translate!!! That's awesome!

[@FlippedClassroomTutorials]

Agree! Love that one.

[@nettievaughan7672]

I didn't know about Google Translate...amazing!

[@experiment_mixedfunnystuff5261]

Great clear video. Thks

[@hex_army]

Great video thanks.