Excel Formulas and Functions Tutorial

[@KevinStratvert]

🆓 Watch my FREE Full Course on Excel Formulas and Functions (New for 2022): kzbin.info/www/bejne/j2nbmaWLlph-fpY 🏫 Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com ⏭️ Watch next - playlist with all my free tutorial videos on how to use Excel: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@grush6919]

How do I get mean of only one value

[@anntempleton8431]

Kevin Stratvert add

[@reemsaeed7183]

Kevin Stratvert thanks a lot for ur simple way to explain it wish u all the best

[@ShalamarEntertainmentGroupLLC]

How do you find and calculate percentages

[@joycerowe8621]

Question: my workbook has multi tabs- is there a way to search for a specific tab without scrolling thru all the tabs -Example tabs are named for numbers 4196-7690--- Can I make it jump to tab 5628 without scrolling thru each tab

[@andregoulbourne839]

Any guy who has time stamps in the video, is a good guy.

[@theaccountant5846]

Good idea. I'm gonna put timestamps in all my videos. Thanks

[@lifeofapunjerican8135]

Hi, I am using two date columns to check if an incident occurred BEFORE or AFTER a certain date in a column but when I use the IF formula, it shows the same output even when there’s nothing in one of the date columns. Not sure what’s wrong. Can I send you my example?

[@manuelcharquetunamontan5672]

@@theaccountant5846 i

[@theaccountant5846]

@@lifeofapunjerican8135 You can send me your example and I can try to figure it out

[@alirezaeskandari2287]

Absolutely agree

[@nancystrickler1760]

What you taught me in 15 minutes, I have been trying to figure out for the past two hours from my book. Thank you sooo much!!

[@selectivemusictracks3372]

the irony is professors make it boring. You-tubers make it interesting.

[@hajrahnawab4722]

@@selectivemusictracks3372 yupp!! Cuz it's KZbin!!

[@nmcobragameing5027]

the video is only 15 min

[@slev8871]

I’m trying with books for ages and this video just nails it.

[@hexwarrior89]

Dido

[@tooyosimi]

That joy when you find exactly what you want and it’s as straightforward as possible. Thank Kevin Stratvert

[@SimplyAnne1]

Hi Kevin, I’m an accounting student and I wanted to say I appreciate your excel tutorials. They’ve helped me greatly. I had finals and needed to know how to use some excel functions and I can’t thank you enough. Your videos are straight to the point and easy to understand.

[@yousefe7804]

well I don't

[@maltepettersson3083]

well I don't

[@neophilander5366]

@@yousefe7804 why

[@ArchieTee-uf7cz]

👏👌💯

[@ArchieTee-uf7cz]

👏👌💯

[@Donorito]

I lied on my resume and now here I am

[@arlenegonzalez6375]

LMAOOOO SO REAL 😭 (here I am rn as well)

[@sandramendoza703]

Lmao I didn’t lie but did say I knew basics which I did but I kinda forgot so now here I am 😂

[@Plain_Jan]

😂😂😂😂

[@AzraČengić-u9d]

Im your boss ur Fried🫡

[@Donorito]

@AzraČengić-u9d if my boss knew my online alias, we'd have bigger problems than lying on my resume

[@winterenlightened4268]

I was feeling ashamed of not knowing Excel and my colleagues being used to it for a whole year. You're a saviour. Thank you so much.

[@nocoverchargee]

The formulas were the most complicated thing for me but thanks to this video I will be able to use them without complications, as soon as I get a product key for my laptop, of course... Thanks for the video tho!

[@Ann_779]

Hi! For the product key, I got mine from BNH Software, and it was straightforward to use. You might want to give it a try if you’re looking for one.

[@nocoverchargee]

​Thank you! I got it!

[@BeHappy-bq4pw]

THANKS FOR THE VEDIO...SUPER HELPFUL😊😁❤

[@robmorris9001]

I am 29 years old and have never understood Excel, so many people have tried teaching me but I have not been able to retain the information. Your video makes it so simple and now I have completed my first comprehensive excel sheet. Thank you so much

[@Henogorbachov]

Ive been through a lot of KZbin Excel tutorials in the last couple of days and yours is the most professional, easy to follow and to the point. Keep up the good work, liked and subscribed.

[@lucky-nz1ll]

agreed, please make more videos

[@diamondt1426]

Totally agree I've been going through multiple videos myself

[@hectorflores3590]

Likewise. I agree too.

[@airvacancy]

easy and straight forward, thanks buddy

[@dr.bolaadebiyi249]

alMutaz Shora '.

[@Enjoywatchingyoutube8227]

Kevin, I've used excel for a number of years so many of the items listed I had experience, but others I needed to brush up on. The way you laid out your table of examples and listed across examples was great. I've seen other videos and yours I will say are the best with simple straight forward examples. Thanks

[@mattkaz9604]

This is exactly what I needed - so many flabby pointless Excel videos online, but this is the good stuff. Big thanks.

[@soya.seungocado]

I have a practical exam tomorrow, portion is just excel, I had to miss the first week of school because I was still writing final exams in my previous school. I haven’t had much time to study and didn’t really understand excel formulas well, but this has saved me. Gonna go learn charts too because that’s coming too. I salute you

[@TechTinkTronics]

Thanks Kevin! It is awesome how when writing formulas, Excel provides real-time assistance via auto suggestions. Fascinating!

[@GAARA._XFF]

I'm only 16 and Kevin I love your video's it really helps to understand everything I like subscribe and comment love you Kevin keep up the good work your very smart it isn't every where you go you can find someone this smart😎😇

[@sandralarocque5000]

Thank you Kevin, for clarity and ease. I did excel way back in time, I always thought the more modern method were a bit complicated to access. Glad is not the headache I was afraid of.

[@katez2508]

You have no idea how much you helped and how fast....Thank you. And the detailed time fraims...wow.

[@tylersf8758]

Shush this video is old

[@Relive-Anime]

This man is more valuable than any college book you can buy

[@dlocktrends9703]

Please never delete this 🙏 I watched this a year ago and I needed a refresher today

[@JohnCarpus]

He did what my teachers been doing for 3 months IN 12 MINUTES

[@abdijibaaraadam5279]

Thanks bro from somalia 🇸🇴

[@093crusherace]

Definitely subscribed! Thank you for providing easy to understand and straightforward tutorials.

[@KevinStratvert]

Thanks for the note Deja. Let me know if there are any other topics that would be helpful.

[@ihteshamkhan-v3k]

Realy dear friend

[@shreyasb.m8930]

Super video,can learn in 15 minutes 👌👌👌😃

[@shoaibahmed81]

never felt more comfortable using sumif & vlookup function. Thanks a bunch

[@ernestosabatercalvet]

Very easy to understand , adequate speed, looking forward to more complex formulas video.

[@dabaruknemuhar1981]

I missed important classes and this helped clear things up. wish me luck lads, i have a paper tomorrow. its a practical

[@aaroncook7866]

Ahad Rehman how did you do?

[@dabaruknemuhar1981]

@@aaroncook7866 pretty good actually. Nailed it

[@aaroncook7866]

Ahad Rehman nice one ☝️

[@diamondt1426]

Good luck. Come back and let us know how you did

[@blackiebrisma.15]

Diamond T she said she did pretty good

[@rebeccasundayemmanuel7908]

i love your lectures, i understand better

[@marianaceja6150]

I'm starting a payroll position soon where they use excel frequently and I am not familiar with formulas so I found your video to learn before I start and this has been SUPER helpful for me!! thanks so much, I feel a little more prepared! :)

[@Mikaluvem88]

Did this actually work for you? Are you still with the company?!

[@susujatha3994]

Thank you very much brother you help me for my final exams at my school👌👌👍👍👍👍👍👍👍👍

[@diamondt1426]

Thank you so very very much. This was so self-explanatory. You made it look so simple. However I know there will be difficulties in trying to remember everything but for the most part I think I got it. I just needed a good refresher and this was awesome and I will continue to go back and look at this video and check out more of your videos this is the first one I've checked out ever thank you again

[@bridgettwiley-davis970]

THANK YOU!!!!! THIS IS THE BEST EXPLANATION! YOU HAVE LITERALLY TAUGHT ME HOW TO DO STATISTICS !!!!!

[@dawnsanders1251]

That was so informative, easy to watch and learn from! Going to watch them all now - thank you!

[@joesio7701]

very easy to follow and most importantly i have learnt a new skill. THANKS KEVIN

[@kittenkate]

Thank you. I’m getting a new job and needed to brush up on things like this.

[@everythingnnothingpodcast]

Thank you for always having the exact way to teach something with your personable demeanor and not just some mouse moving on a screen.

[@maxdoug739]

I have always wanted to learn the basics of Excel but would die inside when I look at the program. Thank you Kevin for being such a great teacher. I no longer have to hide my fear. Excellent introduction for beginners.

[@neophilander5366]

same dude

[@glendaramos4268]

Thank God for you! I've googled Excel formulas many times and gave up every time! You explain it so easy. I'll watch the full course too. Thank you!

[@Hot-Jackfruit-3113]

This was insanely helpful and easy to understand! I’m taking an accounting class and I need to create an excel using formulas, but I’ve never been taught or had to use them before. Thanks a ton!

[@mustafasalam5139]

Thanks for this simple & benefit description.

[@carolynsullivan5303]

That is awesome you include the worksheet. Your tutorial is quick, easy to follow and to the point. Thank you

[@phoebehazelmelleza1936]

Thank you sir ,so much 😘😘

[@cristoferaquino7959]

From now on i'm looking this guy's videos before anyone else, it's esasy to understand and has a excelent way of teaching.

[@ruggediyke]

exactly - he is the best x far x ever.

[@rubyxdiamond]

Thank you for this, it's a super quick and simple explanation without going too overboard!

[@Nasir.786.]

Nice

[@pame4345]

Thank you for putting things into its simplest form and getting to point.

[@elainecastilho1000]

I am taking a test and need excel. Your video is great! Thank you for the professionalism and easy to follow explanations!

[@farhadaliyev6962]

Thanks Kevin, really helpful!👍👍👍

[@ZAINAND_AZAAN_edits]

Omg I just learned excel so fast!! lol.. After watching so many videos, this one has been the most useful!! Thank you so much, looking forward to watching more videos from you!

[@NdzhakaNdlovu]

I can't thank you enough Kevin, wow, my teacher tought the whole year and it made no sense & you made me understand just from a single video, thank you so much!!!

[@charlievelez3510]

Thank you for the extreme basics in the formulas! Question - is there a formula to: - multiply - subtract all cells within a range? Kind of like how it was done to add? Thank you once again :)

[@adeyemitejumola8436]

Wow 5 years ago. Today I learnt a lot, thanks so much!

[@annettesimpson974]

Thank you for being so clear and easy to understand. I have been working with Excell for years but didnt know how to do some of the things that you just showed. great job!!!!

[@babettephillips4414]

Thank you, retired and needed to get a refresher!!! You did a great job, looking forward to watching more,

[@ayca8538]

I learned much much more than I learned at the university in one and a half hour today. Thanks!

[@SUPERXGAMER888]

[@andrea-er3id]

Thank you! Saved me. I understood this easier than my instructor. Zoom classes are somewhat difficult at times. Glad your videos are here

[@Richard-lj2lx]

Just what I was looking for. Thanks Kevin! Also, I'm now a subscriber.

[@nidiatrevino1034]

I actually got what I was looking for!!! Thanks so much.. you are a good teacher :)

[@lauragilmore3298]

I like this guy already after a second, no back story jump right in and validated his experience in the award winning company that stands out Microsoft!

[@1128zoe]

Thank you so much for this video Kevin, please upload more, maybe that help with bookkeeping purposes!

[@alianuemmanuelgrace8929]

Wow, what an awesome big deal in few minutes! I can't wait to get more from you. Grace Uganda 🇺🇬

[@Piggy_tailyyy]

Thank you Kevin, this is so easy and well explained. In older versions, to add numbers i just click in the cell add the = then i could just tap on the cell I needed to add and it will automatically add the + sign, the newer version does not do that. What setting should I change, to have it?

[@hplayspubg5390]

thanks, man it helped a lot in my computer practical

[@chickedeedee292]

We must admire the level of human intelligence and memory capacity.

[@batoolhayat3393]

wow time stamps he is a great guy!!!!! I only needed to watch count but end up watching the all video because he sounds calm and gives detail meaning amazing

[@nikolaromanos456]

The sound, timing and explanation is one of the best on your video., I love it both soft world and excel I subscribed.

[@maryjanemontano972]

i learn alot in his video very professional and clear

[@heavenlyblessed2044]

Clear, concise, and direct Excel tutorial. Thanks Kevin!

[@aminaparveenmansoor6000]

Loved it , i have tomorrow my ICT exam , wish me

[@aishwaryapandey7350]

Nice tutorial and an even nicer jaw-line

[@dr.m.s.prasad7356]

Jargon-free straight tutorial. Never I heard someone explain excel so simply, Thanks Kevin

[@thenightshines6569]

This is an equivalent of learning commands in Minecraft.

[@ReelFusionbySupun]

One of my biggest weaknesses was not knowing excel, And because of you Kevin I learned it in 12.28 minutes. Thank you

[@m.g.4538]

Thanks for simplifying the tutorial for this knucklehead. Much appreciated.

[@BujahMaisan]

This video is very handy.Thanks much!

[@paolaverches774]

Better than my math teacher, computer teacher and my father

[@peopleswhip]

I think I should learn how to start following you. This is a very good video. After seeing this, I deleted all the video films I had on my phone so I can get space to save many of your tutorials. Your great and I hope I saw this before my current interviews. Without I've from Africa

[@ketoamuzie698]

This is the best excel tutorial i have come across, you made it so simple and easy as ABC. The time stamp is awesome, so easy to jump to what you intend to learn. Thank you so much Kelvin

[@osvaldomiranda1778]

Thank you, I am 60 and still learning because people like you. God Bless

[@websterhakata3995]

it is so simple and straight forward, thank you

[@tiffanyfranklin6881]

Thank you Kevin for a video of substance with a pace that shows you want us to learn not just show off what you know by flying through it. Much appreciated!

[@crafty_janaloser7212]

thank you for this tutorial and all of your other tutorials :) you are very helpful and explain everything well. I have been out of work for many years due to 12 surgeries that I have had and am now trying to get back into the working field. some of my excel areas were a bit rusty and your tutorials have been very helpful so thank you :)

[@djm634]

Very helpful as a repeat beginner.

[@ayaansiddiqui3419]

Hi Kevin! Great tutorial! I just wanted to ask which screen recorder you use, and whether or not it's better than Xbox game bar. Thanks

[@jimnatancredi7910]

use "OBS STUDIO". I ALSO LEARNT ABOUT THIS FROM KEVINS VIDEOS

[@siddarthrawat58]

thankyou so much Kevin, thus was really helpful.......what you just taught me in 12 mins was what i was trying to learn from my book since hours

[@leevinson6422]

Great video! Thank you for doing these. Just went into business for myself and your videos are helping so much with time management and work flow!!

[@staceysscentsyselections9456]

thank you so much. I have a oot of trouble with stuff like this and trying to learn it online with a teacher not showing it like you had me so stressed. You are amazing. Thank you so much. I can do it now.

[@oceanadrianne]

Thank you! I am reviewing Excel for a new job. I'll definitely be watching your other videos.

[@hajrahnawab4722]

It honestly took me 3 hours trying to figure out that was I supposed to do from the book, then when I saw this video, I learnt it in 15 minutes!! Thank youuuuu!!!!!

[@ewasylvesterjethro212]

I want to learn how to format excel

[@ImranKhan-vw1sw]

You are just too good...A big thank you sir

[@uplifting_g6069]

I am the 10th dislike do I get a prize? :)

[@uplifting_g6069]

Thanks for the like.

[@spoinge]

youre Welcome :)

[@uplifting_g6069]

Thanks bro for the support couldn't do it without the fans.

[@spoinge]

youre Welcome :)

[@spoinge]

Thanks bro for the support couldn't do it without the fans.

[@michelleburgess5643]

This was simple, to the point, and had clear examples. Miles better than many excel videos I’ve watched.

[@bindijariwala5535]

I usually don't write comments but must say very quick and handful video, straight to the point to develop some routine basic excel skills.

[@CodySmith-ho5sp]

Thanks!

[@KaranPlays516]

Thank u so much! This video is so useful. Tommorow is my practical and I saw this video and got tension free!

[@Premium_345]

Your the best i learned a lot from you merci!

[@lloydsamanga4846]

Thank you very much, this is easy to understand

[@demolishedforest8958]

thanks sir it helped me in my exam

[@ahmedhashim6849]

Thank you so much ihave a final semester exam tomorrow and this helped me so much

[@ladytweav]

Yes 👏 finally!!! I found the right person to learn from. Thank you Kevin!

[@BrianMason3636]

Thx for the info Kevin......very helpful!