Excel Formulas and Functions You NEED to KNOW!

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.

✨ 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

__________________

🚩Let’s connect on social:

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

[GComas-jnyc]

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]

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.

[tiffanyrollinscannon]

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 "YouTube University"! lol. Hands down!

[veronicarizescu]

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

[derranstokes]

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

[jocky]

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

[PoeticJusticeSC]

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.

[petermoorhouse]

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

[farhanasheoraj]

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

[TBUniversalGroup.]

Thank you for sharing how to use excel and formulas and functions to get the numbers necessary when adding and subtracting numbers.

[JSinc]

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

[mrkhalidhafeth]

I really appreciate your method of demonstrating these basics.

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

[sachinrv]

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

[ykrakesh]

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

[peterm]

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!

[wayneedmondson]

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

[Alexthefrench]

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

[stevengarcia]

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

[cuda]

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