Top 10 Most Important Excel Formulas - Made Easy!

This video provides a basic introduction into the top 10 most important formulas used in excel. These include the average function, autosum, Sum If, Count, Counta, Count If function, Concantenate, If logical function, Vlookup, and Drop Down Lists.
Full-Length Math & Science Videos:
/ collections
Excel Tutorial For Beginners:
• Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
_________________________________________
Excel - Statistics - Mean, Median, Mode:
• Statistics - Excel
Excel Scatter Charts:
• How To Make a X Y Scat...
Excel - Finding Slope & Y-Intercept:
• Excel Basics - Linear ...
Solving Polynomial Equations - Goal Seek:
• Solving Polynomial Equ...
__________________________________________
How To Calculate Loan Payments In Excel:
• How To Calculate Loan ...
How To Create an Amortization Table:
• How To Create an Amort...
How To Look Up Customer Data In Excel:
• VLookUp - How To Extra...
How To Create a Data Entry Form In Excel:
• How To Create a Data E...
_________________________________________
KZbin Channel Growth Accelerator:
/ youtubechannelgrowthac...
Algebra For Beginners:
www.video-tutor.net/algebra-f...
Final Exams and Video Playlists:
www.video-tutor.net/
Full-Length Math & Science Videos:
/ collections

[@TheOrganicChemistryTutor]

Final Exams and Video Playlists: www.video-tutor.net/ Top 30 Excel Tricks: kzbin.info/www/bejne/i37ElWyVYpmlhbc Full-Length Videos: www.patreon.com/MathScienceTutor Channel Growth Accelerator: vimeo.com/ondemand/youtubeaccelerator

[@JmKrokY]

Your videos are great bro

[@chellastation]

Your videos are extremely easy and simple to follow. Thank you.

[@DiezmoMelvin-xo2gf]

Melvin diezmo

[@ClesterPahayahay-xh3cb]

Clester john E. Pahayahay

[@okoroblessing214]

Thanks alot

[@chisomosithole6558]

This dude literally knows everything.

[@zahidaparveen8981]

yuppp you are right

[@Wildkomments]

@@zahidaparveen8981 He doesnt know my name

[@MusicNerdMIDI]

His name should just be Tutor For Literally Everything

[@omppeaktechnology618]

Like seriously I love him

[@chinaechetam]

I was gon say that .

[@disquote5998]

I've come to realize that this Guy has a chokehold on everyone ranging from calculus, chemistry, and now excel! The way he teaches and explains is second to none. This guy truly does it all. This guy carries the industry on his back! Much love to you The Organic Chemistry Tutor

[@user-cl5cs2yu4k]

Yeah baby

[@moniquecampbell5709]

1. Average 0:12 2. Sum 1:29 3. SumIf 2:48 4. Count 5:31 5. Counta 6:25 6. Countblank 7:56 7. CountIf 8:23 8. Concatenate 10:29 9. If 13:09 10. VLookUp 19:18 11. Drop Down List 25:23

[@aminullah8373]

Great

[@didial5266]

Thank you

[@yonickmaribojo569]

Thanks

[@lindajohnson2419]

Thankssss

[@somaiasami5506]

how do you make that?

[@neptunethezimbo1254]

You're saving people's lives man. Someone at some point, just NEEDS excel. Great to the point explanation 👍🏽

[@Nefe2782]

OMG, YES!!

[@eagle-yt-6lock572]

i like that

[@FanTube0001]

Can please make understand your comments?

[@soundwave1686]

id rather do gaming instead of this

[@trymoreshateyi7508]

There are two types of Excel videos: the ordinary ones and the extraordinary ones. Yours was the latter. Thanks a lot.

[@elvisgomez9314]

Man I have watched many other tutorial videos, but not one was as helpful as this one. Your teaching skill is so evident. That's indeed a God given gift! Thank you so much for so much insight!

[@klaracraft6641]

Thank you so much for this!!! It's been a few years since I used Excel on the regular and I felt lost trying to create a workbook - even just trying to visualize what I wanted to do. Watching this video at 4x speed with captions not only gave me a great review of things I used to know, but showed me how I could have done some things better back then and taught me things I hadn't used yet. Thank you!!

[@winstonsabellona2204]

Now, I finally know, that the one who helped me make it through calculus and most of my math in my electrical engineering (I have just graduated July 27 this year) was Julio Gonzalez!! All these years, you kept your name in secret despite having people admire you so much. Thank you for everything you taught, Julio!

[@musketeer3780]

This gentleman is a GENIUS. I've seen some of his other math videos on KZbin as well regarding Algebra and Geometry. And, his teaching method - making it so easy to understand without rushing the viewer . . . well, that in itself, is a RARE quality. "Hats Off" to him!

[@mawilimarygracen.3656]

You are really great! thanks for sharing your knowledge to us. From Physics, chemistry, calculus and trigonometry to computer programming you have these videos that helps me in times of need. I have no other words to say but thank you! you are better teachers tan my professors in my local university. you are an all around teacher thank you so much!

You are a born video instructor. Your voice is engaging, your speed with the mouse is not too fast and not too slow, and your progression made sure I did not get lost. I am absolutely coming back to watch this again when I need another refresher. Subscribed!

[@DanielButler-pr3vj]

This video is a must-watch for Excel users. The explanations are clear, and the examples provided make it easy to grasp each formula's purpose. It's like unlocking the secrets to Excel success without the usual confusion.

[@querrythis]

First, thank you for sharing your knowledge. Secondly, you have great presentation skills.

[@MariaVelezschmitt]

This video is simple and straight to the point. Thank you.

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@simpleexcelexamples9619]

WOW your knowledge and way of teaching are outstanding! Thanks for the video which gave me inspiration for my own classes (I give basic Excel training to students) 😊

[@srenpetersen1681]

Agree

[@Hakamaman]

Never have I seen it explained so simply, my interest in excel is back again.......thank you!!!

[@peachesrae5175]

same here, a colleague of mine made me hate excel because she never explained it to me very well, she would just click and click and leave me confused AF.

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@evenastyles3008]

Thank you so much for this. I have this urge to learn more about Excel!

[@mwjacobs]

Thank you for breaking these formulas down so simply. I haven’t used a spreadsheet in years. This was a quick and easy refresher.

[@karimali4611]

I've gotten through many years of high school and college with your help, I was looking up some excel formulas to refresh my memory for an interview I have coming up. I opened up this video from google without checking out the channel's name and the second I heard your voice I honestly felt like crying. You're the best, keep doing what you're doing, I couldn't have gone through so many years without you. Thank you so much for your efforts.

[@theophilusdada1222]

Simple, precise and straight forward. Thanks a lot.

[@badgyalmimi]

True 🙏

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@BillyWilliams-ty4lc]

With a friendly approach and real-world applications, the video is a must-watch for those wanting to master essential Excel formulas without the usual confusion, turning spreadsheet tasks into a breeze.

[@BuiLien-in3zs]

As someone who always found Excel intimidating, this video was a revelation. The presenter's engaging style and practical examples make learning these top 10 formulas a breeze. Now, I feel more confident and efficient in using Excel for my work and personal projects.

[@rostegg3683]

Average Function. [00:07] Sum Function. [01:25] Sum if Function. [02:31] Count Function. [05:24] Eight the if Function. [13:01] Vlookup Function. [22:05]

[@viviencheng7839]

Thx

[@rostegg3683]

@@viviencheng7839 Vivien Cheng? I think I know you

[@yournexxt5125]

Thanks a lot!

[@rostegg3683]

@@yournexxt5125 lol it was like 6 months ago but your welcome

[@norlidiyana]

could you teach me how to do this durations mark? thanks in advance

[@KeebasLife]

I watched this a few times. I use to be a very proficient user. These videos are refreshers for me. Thank you for such great content.

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@potroasted]

You're such a phenomenal teacher! Your voice is so pleasant and you're very clear and thorough. I'm studying for a job interview in which Excel is a mandatory skill, and your videos are the best I've found :)

[@talktoada]

I love the way he teaches calmly... I learnt so much in such a short time. Thank you so much

[@unknownunknown4500]

The best excel tutorial. Straight to the point!

[@maitrayeechakraborty9363]

I am loving Excel now. Earlier I used to avoid excel. Thanks to you. Please make more and more of such videos. MS Access & webpage development would do wonders for layman like me. As Swami Vivekananda had rightly said, "The greatness of a teacher consists in the simplicity of his language". You are a real great teacher. Thanks again. Subscribed, liked and also shraed on my facebook account with my friends. Regards from India.

[@JioXROfficial]

WOW ..

[@Dreamer_Soul01]

World-class teaching, your work is highly appreciated. Your videos taught me so much about excel.

[@cdaniels8671]

This is an awesome Excel Tutorial. I watched this video over and over, and I scored a 90% on my Excel test. Your voice is very calming and your method of teaching is excellent. Thank you so much!

[@cynthiaandrews9362]

This is an excellent tutorial and i learned so much that I didn't know. I clicked to learn vlookup and got bonus functions that i didn't know! thanks! great video

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@Sam-ji1fu]

I just accepted a new job and needed a refresher on some excel skills, this definitely provided it. Great tutorial!

[@Floweryflower99999]

Great tutorial! Thank you for making things so accessible !

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@danafazziola3785]

Thank you for this! So concise and useful. Prepping for a job interview and trying to expand my excel vocabulary!

[@FreedomForever1964]

Ha... me too, after not using it for 13 years. This was AWSOME! Good luck on your interview! :-)

[@raesah9519]

This is the best Excel turotial i've watch. Very simple yet easy to understand.

[@peachesrae5175]

So so true

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@thatameerguy8178]

Thanks a lot for this simple yet powerful explanatory tutorial ❤️

[@ByronCooper-mk6op]

If you're intimidated by Excel, this video is your solution. The explanations are straightforward, and the host goes at a pace that's easy to follow. I've learned more in this video than in hours of staring at my spreadsheet.

[@jewellive2819]

Thank you, you have been very clear with your instructions :)

[@peterreichl6418]

this is by far one of the best excel videos ive used study thanks so much

[@Celinah]

indeed

[@hpourmamih]

Thank you very much for this valuable crash course . It was wonderful!!! and you are AWESOME!

[@kereyc5751]

You have the best excel videos so far out of all the ones I have watched. Occasionally there are small things you do that aren't explained that need to be figured out but other than that this is solid easy to follow instruction. Just a little constructive criticism. Thank you!

[@KelsiCollins-zl7ce]

The explanations are super clear and now I feel like an Excel pro after learning these crucial formulas. Definitely recommend it for anyone looking to up their spreadsheet game!

[@nuraz5202]

Thank you SO SO much! I have an ICT practical exam tomorrow and I don't know anything but after watching this video I am way more confident in myself to succeed. Thank you very much.

[@UwU-uw5cq]

me too!!

[@FelipeBuilesLoaiza]

I was looking exactly for something like this, straight to the point

[@voulak3025]

Concatenate was something I’ve been looking for, for some time. I know how to use it to do something difficult now. Much appreciated!

[@originalginah]

Thank you! I am no longer panic-stricken when I hear VLookup or concatenate. Your vid was easy to follow and comprehend. Deep gratitude from NC.

[@sushrutthakur9927]

Thank you so much for making learning so much fun. Long time fan of the channel and as soon as I start earning, I'm becoming your patreon. Hats off sir, you're doing something great for our community

[@aashiadancingchannel9989]

You are right bro 😁😁👍👍😉

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@thesunshineisgrae6987]

This is such a great refresher course. I needed it being that I don't use excel on my own but will be tested on it for a job assessment.

[@reenabharath9845]

Did u get the job?

[@thesunshineisgrae6987]

@@reenabharath9845 I did, thank you for asking.

[@noe7660]

Thank you for these explanations, it’s always helping people, even 3 years later

[@junity1]

Best tutorial so far ! Well explained. Delivery was on point. You did not rush through it like the others !

[@ablooga298]

I never usually comment but thank you for making excel less daunting!!!!

[@andyallenpcsmr4169]

I felt like your explanations were spot on! I learned a lot. Thank you so much!!!!!

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@risinghawk5294]

You are literally amazing man. You can teach everything Mathematics, Chemistry, Physics, Biology and Computer Science.

[@ernestrost4069]

Thanks for making this! I was able to figure out how to achieve what I was looking to accomplish using the "SUM" function. This taught me so much more than I thought I needed to know.

[@darlenebradley5827]

Love the examples. I found them to be very helpful. Thank you!

[@run_hike_vanlife]

Holy crap that was packed with all the exact information I needed!!!! Wow!!!!!! Thank you for this video!!!!

[@Mental_Rebirth]

Dude, this was the shortest and most clearest lesson I have ever seen here,,,safe and brief

[@emmanu1818]

I kept procrastinating things but today I decided to learn it.Thank you so much. Worth it💪

[@KevinAtinpacu]

Thank you so much! The IF function really beats my understanding.

[@danielteyenor6742]

This is amazing. Thank you Tutor!

[@Artbyep]

Best excel tutorial I have ever watched. This is golden. Thank you!!!!

[@vagafu.jvfonlinestore]

Your explanation is simple and easy to understand. It's a great video. You're a the best excel teacher

[@MrMrannoying]

I was like "Hey I recognize this voice", then was surprised to see you made this video. Very good functions! I think these will help me stand out among others

[@michaelodero7718]

Very helpful.Thanks

[@swaggyskye]

yes! I didn't know he also make excel videos apart from chem calculus and stuff

[@nataliae9229]

Best Excel Tutorial!!! You are an amazing instructor

[@JustAng116]

I've been looking for this specific if/then formula FOREVER! Urgh you just made my day! Wish i found this video long ago

[@NightWalker911]

I know this video is really old, but you don't understand how easy you've explained everything to assist with my assignment. Truly appreciate this video!! Very well explained!! 👍

[@thiphyo6758]

Thank you very much, i have got a lot of things for me.

[@TarunSharma-mg5ju]

this was a real big help brother. God bless you and thank you so much.

[@kaimemess]

I don't usually post comments but I just wanna say thank you for this video. Have an exam for excel and these really helps me a lot. ❤

[@selenalyrics4570]

I love the way you teach it! Watching these videos is way better than scrolling on social media.

[@paulorobertojunior5348]

Thanks so much! This video is amazing, helped me a lot. There is no waste of time here because you were straight to the point. =)

[@alexiapalmer6659]

This is just so all rounded, I know you voice from math so I know I’ll be able to grasp this too

[@rowenasalditos9159]

we have these in my college times but just now i realize that this is so easy because all those years, i thought these are difficult to understand. Thank you so much.

[@universaltreeltd1117]

You are absolutely 💯 amazing. Thank you. I will be using your videos to support learners, staff, and myself! I love your delivery and simplicity. It's one of the best videos I have ever seen! This can really be used within a lesson or as a quick guide. Well done!

[@happylumanao3289]

Thank you sir. Very informative 👏

[@bethnichols2537]

This tutorial is saving me at my job right now. Thanks you so much!

[@AhmedSallam-pj1cb]

Thanks a lot

[@Rachidasister]

Wow! I came here for a refresher and I am blown away by some of the functions. Great video!

[@sevra4836]

Perfect, straight to point and easy to understand! Thanks!

[@kara1595]

Hi sir, thank you very much for the lesson, this is the most interesting and understandable excel lesson I've seen. Please keep up what you're doing, thanks again!

[@SK-mv5co]

kzbin.info/www/bejne/h16ngZaFidCWjtk

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@anwarhussain-vf6bl]

sitting in the interview hall and watching this😭

[@sarveshchandrasekar813]

😂😂😂

[@mbt1274]

Best of luck brother I also have a interview tomorrow 😅

[@daminirautela7257]

Lol today I am in the same situation.🥲

[@KusumaD-wy4pn]

Did u get selected 😅😅

[@srilakshminimmagadda-dl4sh]

Same here

[@filipcvetanovski3233]

literally the simplext explanation to all the formulas .Good job man ,thanks for uploading

[@klausreka438]

you helped me in maths, chemistry, physics and even excel!

[@gabrielwong6161]

didn't know about the drop down list using data validation. cools !

[@jestaguinod4401]

Great job sharing your knowledge 👏 Just to add instead of using concatenate, you can use ampersand & symbol to combine/connect information from cells. 😊 =B&C

[@hadassahbaluran9544]

Thanks!

[@notacontentprovider]

The SUMIF & Counta functions are going to save me soooo much time, thank you.

[@janin4real]

I have been out of learning for a long time I watched so many videos that didn't help yourself is straight to the point and easy to understand, just came across your channel wonderful you have been so dedicated over the years, I hope KZbin is doing you well.

[@normaramirez886]

Thank you for a quick crash course before a job interview lol

[@freakystley]

I'm here for the same reason. 😂 I hope your interview went well. 🤞

[@NAYABNAZIR]

Best Explanation at all.Proved such a helpful for me.😍

[@TheBulilits]

You're a life saver! the clearest tutorial I've watched. thank you!

[@user-ug3rq4yu2c]

Short, sweet, and incredibly informative!

[@sangeetaisrani9661]

Thank you, simple, short and easy to understand!

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@emilydedmon3288]

This is great, thank you!

[@Art-by-Milly]

Thank you for explaining patiently, very helpful, please do more of excel videos, you have abundant knowledge 😇❤

[@lnxv2706]

This man is insane for real like my whole school year didn't benefit me as this video thank u so much

[@farouqbakare7154]

Thanks a bunch, very helpful

[@patriciablackmon6764]

Great tutor. Right to the point and I appreciate all the examples. You really made easy all these functions, Thanks a lot.

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8

[@chrispinesamuneti6535]

So very well simplified! You are great, man.

[@markchristianpadrones7211]

Just came back to thank you for helping me pass and get my prof. License. Youre channel helped me know math in a simple and easy way. If only I knew this channel when I was still in college 😅.Again thank you good sir and more power to you and this channel.🎉🎉

[@steveroberts1199]

great demonstration of functions in excel, thank you. in the average function and the sum function demo, your range only includes the first 9 numbers (not all 10). that means the average and the sum you calculate are incorrect. (sorry if this is already been pointed out)

[@jodavis1950]

Thank you for commenting on this! I was going crazy thinking I was doing something wrong. I am following along with each Formula and inputting the same information but kept getting a different answer for Average and Sum (this is as far as I have gotten.) I started looking in the comments to see if anyone else was having an issue and I saw your comment which was over three months ago. Today is, April 17, 2021. This may not be a big deal to others, but to a newbie who is following along with the video, it is important! I am enjoying, understanding and learning from The Organic Chemistry Tutor! Thanks Steve.

[@jesusajasmincarin1647]

Thank you for your comment at first I taught I'm doing something wrong on the average and sum function.

[@relaxtv584]

kzbin.info/www/bejne/sH6reGhjl8p4aK8