15 Functions in Google Sheets You NEED to know!

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

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

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

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

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

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

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

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

[@zoegarcia8470]

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

[@carmenchapdelaine852]

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

[@FlippedClassroomTutorials]

Thank you!

[@TyrantRC823]

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

[@pcl22000]

lol hhhhhhhhhhhhhh

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

[@jieadee4977]

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

[@FlippedClassroomTutorials]

Great to hear that!

[@rohanfernando5924]

All 15 were very useful. Thank you

[@FlippedClassroomTutorials]

Brilliant! Thank you!

[@saharaleebolo2759]

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

[@jacquelinelara3626]

Loving the gtranslate function!!

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

[@MadisonGutierrez-r5n]

Date() was my favorite function. Thank you!

[@pinkiechan5758]

Not really sure if I’m gonna get any response to this but disclaimer I am a dyslexic person so just doing this through S2T mean about 500 other people play dungeons and dragons online using Google sheets I am currently trying to come up with some formulas that would automatically calculate scaling class features based off of character level we use a lot of homebrew rules for advance progression in the game I am confused on how to make an =IF() that could read the characters level for some reason it is still coming up as false this is what I have so far =IF(char lvl cell=“>22”,10+(char lvl cell-20),ROUNDUP(char lvl cell/2)) what I wanted to accomplish is if you are 20th level or lower it takes your level divided by two rounded up to give you your sneak attack dice amount if your 21st level it would just stay at 10 and the progression starts at 22 giving you one for your previous level and the one that you’re currently in and then plus one per level Confused on how to make it do 22 or higher not sure if the server progression is it going to go past 30 so I don’t want to make an equation limited to that I would really love some help it would be very appreciated I am very new at doing this and my learning disability does not help finding proper resources

[@dimasdjamaris6503]

That sparkline is so useful, i love that one XD

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

[@PrinceWesterburg]

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

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

[@MaryAguirre-r1o]

Super easy to understand. More please. 👏👏👏

[@FlippedClassroomTutorials]

Thank you!

[@zellazella5323]

This is so much helpful. Can you also share a link where I can use the following abbreviation, not so sure if my question is correct say for example "EN" for English, ES for Spanish. Would love to try other language to translate too, Thank you:).

[@darlingngbayan344]

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

[@acarde]

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

[@amitkumardubey7672]

Hello sir I'm from INDIA Thank you very much for influencing our knowledge, after seeing your helpful videos I'm doing better in my office work But I request to you please make video on all the Google sheet functions including engineering, batabase, web , math and all those are in the functions list Please sir 🙏🏼

[@PepeTheFrog2016.]

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

[@FlippedClassroomTutorials]

Glad you enjoyed it!

[@jaseminet8834]

Nice video and I appreciate the time stamps.

[@FlippedClassroomTutorials]

Glad you liked it!

[@gomakhanal2473]

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

[@anitaparkin1422]

Well explain and never have enough of your video.

[@FlippedClassroomTutorials]

Thank you! Glad you find them all helpful.

[@Series7Exam]

amazing! Sparkline and translate blew my mind

[@FlippedClassroomTutorials]

Brilliant! Thank you for sharing.

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

[@mazinsuroor6170]

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

[@tjtindal9077]

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

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

[@nirmalasenerath]

your videos are so easy to understand.Thanks!

[@NaomiGoldstein7895]

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

[@mariahenrique4672]

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

[@sergedm5553]

Thanks for these classes

[@rosinmerman]

Thank you for all your help!

[@FlippedClassroomTutorials]

You're very welcome!

[@rekhal5692]

Thank you for this class it will be very helpful

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

[@DileepKumar-je1vw]

Thanks for awesome 15 fuctions

[@FlippedClassroomTutorials]

You're welcome

[@suttirakchinda1813]

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

[@olivergodfrey]

Great video thanks. Do you know how to show a progress bar in a cell, but from using text from dropdown options? So I have a column that I manually select what I want from my dropdown box options (I previously set and those are stages through a process we have for a work task), then I want another column to reflect how far complete we are depending of what dropdown option is selected. I hope that makes sense. I've been searching far and wide for months now but found nothing helpful yet. I'd love it if you already have a video for this or could help me out? Thanks in advance

[@Hambxne]

Sparkline is incredible!! 11:22

[@jorgevasquez7816]

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

[@joaoleitaoviagens]

great explanation. thanks,. greetings from Ouarzazate, Morocco

[@yvettekane9444]

Very informative. I need to transfer all of my information from Microsoft. I just found google sheets. One thing I struggle with is adding all the information and then finding I need to put in after I input functions. If that makes any sense. Do you all of the functions just keep moving down?

[@patrickmuvunyi722]

I love the If function. Thank you sir!

[@kendra-chao]

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

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

[@shanstatedrd7295]

Thank you very much for your excellent explanation.

[@normahd]

Thank you very much for tips👍

[@FlippedClassroomTutorials]

No problem 👍

[@davidguevara8455]

Sparkling is pretty cool

[@FlippedClassroomTutorials]

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

[@DGA8787]

Filter functions changed my life.

[@FlippedClassroomTutorials]

It's brilliant!

[@khaltiwanger1]

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

[@adelinepannadhika2475]

for me, the most mindblown formula is importrange :D I just learned it and truly understand it, how it helps me to link data between files.

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

[@teddyw.charawa8989]

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

[@mohamedashiq4831]

Hi, Thanks for the great video. I have 2 Google sheets files using the same template[which means the column names are same in both of them]. But they contain different records/data. How do I find the difference between them in an easy, quick way? Attaching a sample file[which is in MS Excel]for clarity. Regards

[@balatsu1]

Thank you for taking the time to do this video.

[@rastatekk]

Very usefull tips (I use G.Sheets for a long time, but join and sparkline are new to me)

[@PrettyForiwaah]

thanks for the "sparkline".

[@FlippedClassroomTutorials]

Always! Love me a sparkline ;-)

[@aanchalshrivastava5228]

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

[@lukastejoprasetyo4392]

Thank you for Your very good tutorial, if Chinese what code to be use ? I have tri use CH, is not working. thank you

[@PropertiDong]

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

[@FlippedClassroomTutorials]

Thanks! 😃

[@harcio]

Nice stuff for beginners and advanced users, however instead of vlookup I would recommend using a combination of index and match. Formula is a bit longer but much easier to read and maintain, it can also do vertical, horizontal and 2D array lookup and it allows for more than one lookup parameter. To the list I would also add iferror().

[@annielin2894]

I agree with you Match and Index is lot easier

[@patrickchapman8583]

you can embed a Match() function in place of the VLOOKUP index parameter. That way the Match function looks for the values in the column headers.

[@dizzydama1768]

i can't believe i didn't know about sum if... so many collumns can be combined now... some other great functions as well but im going to be using this a lot in the next few days as i update my sheets

[@ClaireVillarreal]

This was so helpful, thanks!

[@FlippedClassroomTutorials]

You're welcome

[@bruceholsted2127]

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

[@abzgarciava]

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

[@vanessalorica7129]

very informative, indeed. I hope these few little things would be added on your next video (not even sure if they are possible in google sheets) calendar in google sheets (dates auto change when the month & year is changed) calendar in google sheets (where you can add appointment/meetings/notes, etc. in particular dates, and will auto hide when the month & year is changed) thanks a bunch!

[@ultimateadaptation756]

Thanks for sharing. Sparkline!

[@JasonLayton]

After sitting through most of this video thinking it's a waste of time... I got to VLOOKUP function and my life will be forever changed. Thanks!

[@FlippedClassroomTutorials]

I tried to put something in there for everyone, so hopefully nobody has to feel they've wasting any time. Glad you got to learn about vlookup. It amazingly powerful.

[@snippetsofpam184]

The date trick was great

[@FlippedClassroomTutorials]

Thanks!

[@rosfelylaya9563]

Sparkling is amazing

[@FlippedClassroomTutorials]

I agree!

[@timcentralpointinvestigati6683]

I have been trying to figure out #9 since I was born. Thank you.

[@crypto4ever525]

great video!! Thanks!!

[@sherid8145]

Thanks for a very helpful video. Can you do a video on using SUMIFS..Thanks,!

[@kevinnelsoen3653]

Hello so ive been trying to get a couple of functions to collect data on the lottery... What would work for tracking a number or numbers and how many games it skips before it plays again?

[@G23teknik]

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

[@nettievaughan7672]

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

[@khadijasumaiya3374]

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

[@saleemalbudairi1684]

great video, I hope you consider making new videos about the char function.

[@ravindercherla]

Good explanation sir

[@information2121]

Hi!. I have a question. I am working on google sheets. I have data in any column. How can I fit my data without expanding this column?

[@ak5848]

Thanks a lot!! It was very useful

[@hendriksahari]

Waw...thank you. I Still wonder how to gathered some values from one file gsheet to another one, I really need your help. Thank in advance

[@huawang190]

Great tutorial and very helpful!

[@FlippedClassroomTutorials]

Thank you

[@asifazeem6552]

Excellent! Very valuable video. Thank you

[@kalyankumar8629]

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

[@FlippedClassroomTutorials]

You are most welcome

[@RobertvanTolUK]

Didn't expect Google Translate as a function. Thank you!

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

[@bhavinmoriya9216]

I want to check if A1 is in column B, if yes then want to omit the location at which it is in column B. If it is in location say B5 then want to output the value C5. Could I do this ?

[@BronsonJM]

Google Translate!!! That's awesome!

[@FlippedClassroomTutorials]

Agree! Love that one.