Up next

Excel Formulas and Functions You NEED to KNOW!

3 Views· 17/06/24
Oligaji
Oligaji
2 Subscribers
2

Join 400,000+ professionals in our courses here 👉 https://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: https://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: https://www.youtube.com/playli....st?list=PLmHVyfmcRKy

Intermediate Excel Functions (including the Excel IF and VLOOKUP functions): https://www.youtube.com/playli....st?list=PLmHVyfmcRKy
__________________
Get access to my Excel Essentials course: https://www.xelplus.com/course..../learn-excel-essenti

➡️ Join this channel to get access to perks: https://www.youtube.com/channe....l/UCJtUOos_MwJa_Ewii

👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

🎥 RESOURCES I recommend: https://www.xelplus.com/resources/

🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://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

Show more

 0 Comments sort   Sort By


Up next