Excel Formulas and Functions You NEED to KNOW!

Рет қаралды 733,574

3 жыл бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
This video is perfect for Excel beginners or anyone who wants to feel more comfortable using formulas and functions in Excel. It offers a detailed, easy-to-follow guide on common functions and formulas, along with a special trick to simplify using any type of function in Excel.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/formulas-functions-file
✨ Key Highlights:
▪️ Basic Mathematical Formulas: Learn how to write and use basic mathematical formulas in Excel.
▪️ Using Sum, Average, and Count Functions: Explore how to sum, average, and count data in your Excel sheets.
▪️ Inserting Functions in Excel: Discover the process of finding and inserting the right Excel functions for your data analysis needs.
▪️ Advanced Functions Like AVERAGEIFS: Get insights into using more complex functions like AVERAGEIFS for specific conditions.
▪️ Practical Examples: See real-life examples using sample datasets for a practical understanding of Excel functions.
These Excel functions work for ALL versions of Excel (Excel 2007, Excel 2010 all the way to Excel for Office 365). The basic Excel functions we cover are: SUM, COUNT, COUNTA, MIN, MAX and the AVERAGE function. We also cover AutoSum and the AVERAGEIFS functions.
00:00 How to Use Formula and Functions in Microsoft Excel
00:29 How to Write a Mathematical Formula in Excel
01:44 How to Sum Columns / Rows in Excel
03:24 How to Insert a Function in Excel
03:52 How to Use AutoSum in Excel
05:00 How to Calculate an Average in Excel
05:39 How to Count Numbers in Excel
06:29 How to Count Text in Excel
07:07 How to Calculate Min and Max Values in Excel
07:33 How to Use AVERAGEIFS in Excel
10:06 Wrap Up
More Excel Tutorials for Beginners: kzfaq.info/sun/PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0
Intermediate Excel Functions (including the Excel IF and VLOOKUP functions): kzfaq.info/sun/PLmHVyfmcRKyxYcARtENIf6zFf5OlsrEQN
__________________
Get access to my Excel Essentials course: www.xelplus.com/course/learn-excel-essentials/
➡️ Join this channel to get access to perks: kzfaq.info/love/JtUOos_MwJa_Ewii-R3cJAjoin
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: lgharani
LinkedIn: www.linkedin.com/company/xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

Пікірлер: 320

@LeilaGharani 5 ай бұрын

Grab the file I used in the video from here 👉 pages.xelplus.com/formulas-functions-file

@GComas-jn2yc 3 ай бұрын

Finally found a person like you willing to share your information in English Captions cuz sometimes other people who made their own videos, they never even made their videos in English Captions. Bummer! Why did I say that? Reason is because I am DEAF & I truly believe that through captioning, there’s something to learn for the DEAF community. Thank you! You deserve an award for that❣️ Keep up the awesome work‼️

@phantompawn 2 жыл бұрын

Thank you so much for not only showing the functions, but also how to self-educate within the program. Knowing how to explore through the program to feel more comfortable within it is a godsend.

@tiffanyrollinscannon3568 2 жыл бұрын

I cannot explain how simply and beautifully you break down information -- from the most foreign, to the most basic -- you somehow still seem to make things much more understandable and less intimidating than your viewers thought possible. I could not hit subscribe fast enough! Professor Gharani is definitely one of THE top professors at "KZfaq University"! lol. Hands down!

@veronicarizescu1364 2 жыл бұрын

Thank you for the simple and coherent way of explaining. Wish I had teachers like you when I was in school.

@derranstokes8760 3 жыл бұрын

Thanks Leila - A very experienced Excel user, who has forgotten the basics and grateful to be reminded of the basics and alternatives.

@LeilaGharani 3 жыл бұрын

You're very welcome!

@farhanasheoraj8843 2 жыл бұрын

Love the videos, always professionally presented and easy to understand, great job. Keep it up.

@jocky1027 2 жыл бұрын

What a fantastic video, so well put together and explained. Thank you so very much, I will be watching the rest of your videos to get me up to speed with Excel

@iDelta77 Жыл бұрын

This lady actually talks in a language that i can understand. Now I can actually start learning

@PoeticJusticeSC 3 жыл бұрын

Having watched some of your more advanced videos this feels like a doctor kindly explaining how to apply a band-aid. It's nice to see you explain basic concepts as well as you explain the complex ones. Definitely worth subscribing.

@LeilaGharani 3 жыл бұрын

Basics should never be forgotten :)

@umaralbarnawi 2 жыл бұрын

@@LeilaGharani ok

@Rickwash1972 Жыл бұрын

1 year later I'm thinking the exact same thing.

@andrewmoss6449 3 жыл бұрын

Good to see the Excel rookies are not being neglected.

@anthonysais2580 3 жыл бұрын

Exactly, like myself! 😉

@LeilaGharani 3 жыл бұрын

😁

@virtualtreadmillwalknature1488 2 жыл бұрын

Definitely helping out busy professionals!! ❤️🇺🇸

@scentofcanela1803 Жыл бұрын

Hahah amen!

@wolverineforce2068 Жыл бұрын

Coming for your spot.

@petermoorhouse5994 3 жыл бұрын

Value the way you are mixing basic, revision for some, and advanced together with a prank or two, I really appreciate your channel

@LeilaGharani 3 жыл бұрын

Great to hear, Peter!

@mrkhalidhafeth5823 3 жыл бұрын

I really appreciate your method of demonstrating these basics.

@Galileo2pi 3 жыл бұрын

Leila, as always, brilliant.

@stevengarcia1719 2 жыл бұрын

By far the most detailed explanation, that is understandable and will not make you go to sleep.

@irwankurniawan1737 3 жыл бұрын

Thank you. I use your video as the starting point for my kid entering the spreadsheet world. Awesome!

@2JSinc 3 жыл бұрын

Hello everyone, just want to say that this is the best channel for learning excel / sheets for beginners to advance users, the way she teaches things is very simple to follow, she has that gift of teaching and explaining things easily... thank you Gorgeous Ms. Leila...

@djjammindave 2 жыл бұрын

I GOT IT (GIFT)

@2JSinc 2 жыл бұрын

@@djjammindave thanks for noticing...

@kemiesan1908 2 жыл бұрын

I love your video, it is so easy to follow. Thank you, in just one night I have been able to boost my confidence

@ykrakesh1984 2 жыл бұрын

Totally enjoyed watching your video, superb demonstration and totally worth for me as I was also looking for tips/knowledge on how and where in Excel!! Thank you for making such great videos...A great help for beginners like me :)

@sachinrv1 3 жыл бұрын

Nice to see the basics. Even after using excel for so many years, sometimes I still find that function argument box very useful especially when using complex integration, as one can get inside the formula to ensure that it is heading in the right direction. One simple trick, while using function argument box is, you can press F2 to select cells or range of cells while you build formula. Using a mouse is coward man's work. LOL. Thanks Leila. Cheers :)

@LeilaGharani 3 жыл бұрын

Haha, I like that 😂 Thanks Sachin!

@peterm6081 Жыл бұрын

I am very new to excel and I loved the way you explain information needed to navigate excel. I will have to practice what I seen from you and will definitely be spending a lot of time on your channel. Thank you!

@Mohamed-yq4fj Ай бұрын

Thank you for the simple and coherent way of explaining.

@dfsupport Жыл бұрын

So much to learn! I practice all of these formulas as I go through your videos, Leila. I ran into an issue when using the =COUNTA formula. I had 10 names in my list but the formula was giving me $10.00 instead of 10. All my names were formatted as text but the cell that I inserted the formula in was formatted as currency! Silly mistake but I learned a lot because I was deep into the research. Thanks for another great video!

@Alexthefrench1 3 жыл бұрын

The way you teach is.. EXCELente!! You make everything sound so easy to learn. Love from Portugal

@LeilaGharani 3 жыл бұрын

Thank you very much!

@glisdidee 2 жыл бұрын

Thank you so much for making excel easy for me to understand as I have always been not confident using it.

@henryifeanyi2181 8 ай бұрын

I learnt something the advance tutorials never touch on, the Function icon and how useful it can be. Thanks

@wayneedmondson1065 3 жыл бұрын

Thanks Leila. Always a pleasure to watch your videos. Thanks for sharing! Thumbs up!!

@cuda8538 2 жыл бұрын

Great tutorial! I your explanation of the insert function and autosum in specific. I haven't seen a video of those explained this well.

@AlexAlex-pi4hh 2 күн бұрын

Thank you very much for sharing.

@wazmink2459 Жыл бұрын

Good that I found this vlog, now I'm able to see how to solve complex function.

@islandcactus1508 3 жыл бұрын

Brilliant stuff! Us Mac users still don’t have quick analysis so manually learning Min / Max is necessary. Lets get this girl to a Mil sub!

@LeilaGharani 3 жыл бұрын

Thank you!

@ironempath7261 Жыл бұрын

Thank you. Easy to follow, and lovely office furniture set up.

@5sbarokah336 3 жыл бұрын

Thanks for your video, it help me adding a knowledge of excell function.

@suleimanshaik 2 жыл бұрын

I am a fan of your videos and the presentation style. Thanks, as I'm learning so much.

@Lodgeitude 3 жыл бұрын

Always making videos easy to understand. Thanks a lot.

@LeilaGharani 3 жыл бұрын

Glad to hear that!

@dimanthagamage9895 2 жыл бұрын

Thanks for letting us know very useful features of excel. ♥️

@juditedsouza8369 Жыл бұрын

You made it look so easy and you have such a pleasant voice. Thank you.

@excelismagical-shakeel4793 3 жыл бұрын

With so many advanced videos of yours, Nice to see a basic formula one for the fresher's... Honestly you are an inspiration for me to start an KZfaq channel of my own in Excel recently... I need wishes from genius like you for the success

@LeilaGharani 3 жыл бұрын

Happy to hear that. Best of luck with your channel!

@excelismagical-shakeel4793 3 жыл бұрын

Wow!! Glad to see your wishes, Thank you so much 😊

@elenich5159 2 жыл бұрын

Thank you!!

@kaisykaisy 2 жыл бұрын

This video or lesson is very important to start in Excel formulas. My best regards to Ms. Leila

@noush4283 3 жыл бұрын

Thank you you are instructor. Not like others trying to keep it short and time limitation in my opinion you are taking your time making us understand the lecture I did joined you course unfortunately did not get bonuses. Keep the good work 👍👍👍

@queenbodicea 2 жыл бұрын

Brilliant. That was very helpful and you were easy to follow.

@djjammindave 2 жыл бұрын

I JUST STARTED WORKING WITH EXCEL ON THE FIELD. OUR SPREAD SHEETS ARE A COMBINATION OF NUMBERS AND TEXT. I'M NOT FAMILIAR WITH EXCEL, BUT LOOKING FORWARD TO LEARN THE BASICS WITH YOU. I'VE BEEN A SUBSCRIBER FOR YEARS NOW, BUT I NEVER REALLY SPEND TO MUCH TIME STUDYING THESE COURSES. THANK YOU FOR SHARING YOUR KNOWLEDGE...

@vijayarjunwadkar 3 жыл бұрын

I never used the Function Arguments Box, although I was aware, but looking at it's utility, I am going to use it now, while exploring new functions especially. Thanks for this tip. Whether "basics" or "advanced", we can rely on Leila for everything Excel! Stay blessed! 😊👍

@LeilaGharani 3 жыл бұрын

Yes, it's a great way to getting to know new functions. Thanks for watching even my basic videos!

@ProfreshionalLifeBeyond 2 жыл бұрын

Thank you for your video with clear and simple instructions. I am touching up on Excel and I really appreciate your teaching methods. Best wishes from beautiful autumn Melbourne Australia.

@LeilaGharani 2 жыл бұрын

You're very welcome!

@paulussantosowidjaja93 Жыл бұрын

learning is for a life time while still alive, I subscribe. Cheers,Leila.

@brightafghans2886 9 ай бұрын

Thank you.

@VIJER47 3 жыл бұрын

Nice video for us rookies. Thanks.

@ADITH_UCIT 3 жыл бұрын

Thank you for these videos.

@mdmotaleb6142 Жыл бұрын

Thanks a lot.

@claramumba9124 2 жыл бұрын

Your presentation is passionate and easy to grasp I will teach with patience like you

@mensahemmanuel3814 Жыл бұрын

very nice and easy way of doing that operations. wow.

@ishangoinyambo6523 Жыл бұрын

thank you !!!

@markdavies-ei8sf 7 ай бұрын

Powerful, thank you.

@JitenderSingh-hg8wl 2 жыл бұрын

Nice video. Thanks.

@roselinembonu2192 2 ай бұрын

Leila Gharani, you are the best I have ever seen on this field! Thank you for your simplicity and excellent presentations! Now I can learn Excel!

@LeilaGharani 2 ай бұрын

Thank you! 😃

@CandaceJDunkley Жыл бұрын

This was very helpful. Thank you!

@adamanthony7465 2 жыл бұрын

Thank you Leila , I found you clear and simple , to the point I would like to make a clear progression onto a full function set with relevance to a job search in electrical administration. If you are able to offer a list of video in progression of complexity I would much appreciate this. I am going to begin with the video Excel Functions You Need in 2021 & 2022 meanwhile

@normanbayvel8727 2 жыл бұрын

Listened to u for the 1st time - u explain brilliantly and remove the fear aspect of starting Excell

@entertainmentworldwide5582 2 жыл бұрын

Try this channel Ytc: Rajpoot khan

@maxosall6972 3 жыл бұрын

Thank you so much, that was very handy

@yinyin6998 Жыл бұрын

Thanks teacher...it's helpful a lot for beginner.

@furious-choehaalen1525 3 жыл бұрын

Thank for tips teacher😊

@riungufaith5866 2 жыл бұрын

Thanks a lot Leila

@cybertaiga9534 Жыл бұрын

Extremely wonderful explanation and demonstration. I am truly grateful to you, Leila Gharani.

@LeilaGharani Жыл бұрын

My pleasure!

@gtclicks Жыл бұрын

Leila inspires me to keep posting Excel videos every time I watch her videos.

@pampudazoneallinone4011 2 жыл бұрын

Thank you so much❤

@EXCELWORLD-ez8xy 5 ай бұрын

nice teaching leila,

@simbarashemakwedza1640 5 ай бұрын

Thanks, Leila, for making me understand the concept.

@LeilaGharani 5 ай бұрын

Glad it was helpful!

@consistentlylearning6895 2 жыл бұрын

great video, I think i learned enough to have a great start on excel

@d.g.1986 7 ай бұрын

Very helpful! Thank you for your channel

@dianerobinson4160 2 жыл бұрын

thank you very easy

@niudartakh2058 2 жыл бұрын

Thank you. This video is very useful.

@mariaaraujo6904 11 ай бұрын

Thank you

@lynnjohnson3669 6 ай бұрын

Wow, just found your video. Thanks for explaining Excel formulas in such a simple and easy way to understand. Thank you. I will be watching more of your talks.

@LeilaGharani 6 ай бұрын

Glad it was helpful!

@abrahamjbah 11 ай бұрын

Thanks ❤

@RA-rh5lb Жыл бұрын

I liked average ifs which I never used. good information. thanks

@kettymulenga6710 2 жыл бұрын

Literally had no idea...all thanks to you

@randhib5918 2 жыл бұрын

Wow. Been following you for some time. Thank you.

@joshuamanampiu6489 3 жыл бұрын

Very useful for beginners

@cnntetteh2 Жыл бұрын

Great job

@ethioictmedia 5 ай бұрын

Nice one.

@wallyortizjr71 Жыл бұрын

You are awesome thank you for this video

@stacesprinkle7822 Жыл бұрын

(As someone who says, “ of course I can do excel” on my resume, 😊I love these videos! Subscribed!

@steveplyler8077 5 ай бұрын

Well done, easy to follow, no wasted time as you covered most options to apply to normal business. Thanks

@LeilaGharani 5 ай бұрын

Glad it was helpful!

@akitoakito8790 7 ай бұрын

THANK YOU SO MUCH ❤️ 💖

@katrinanunez1434 3 жыл бұрын

Love all your videos 😍

@user-mu9sz2bn3g 9 ай бұрын

WOW! thank you.

@derrickwalker4615 2 жыл бұрын

Good Job Thank you!

@ShubhamMathur14 3 жыл бұрын

Always enjoy learning from you

@LeilaGharani 3 жыл бұрын

I appreciate that!

@shariffmigaliza7789 2 жыл бұрын

i like your breakdown its fantastic

@adelaidesmith862 7 ай бұрын

Very good at training

@OA-ql3ox 10 ай бұрын

You’re awesome ! Thanks a lot

@shakil1075 Жыл бұрын

Hi, your way of explaining is amazing. I liked that. Would you please upload the video on Qualtrics for beginners!!!

@FarhanMerchant 3 жыл бұрын

Simple yet good insights into getting started ; Thanx

@LeilaGharani 3 жыл бұрын

Very welcome!

@amraref9116 2 жыл бұрын

I'm very happy to listening to you

@hassanahmedalhabib8032 3 жыл бұрын

what a great teacher

@mehnazchowdhury76 2 жыл бұрын

very helpful

@parvizdinmohammadi3078 3 жыл бұрын

Thank you indeed

@cxcw089 Жыл бұрын

Thx so good👍🏻

@arindambasu8343 2 жыл бұрын

Hi Leila, Undoubtedly. it is a highly helpful video. Thank you.