SUMIFS, COUNTIFS, AVERAGEIFS, IFERROR & RANK Explained | Excel Live Class 10 | Shanto My Excel

Welcome to Class 10 of our Excel tutorial series on Shanto My Excel!
In this video, you’ll learn how to use powerful Excel functions that are essential for data analysis and automation:

🔍 What You’ll Learn in This Class:

📌 TIMELINE:

⏱️ 0:00 - 4:03 – Intro & Overview
⏱️ 4:04 - 10:12 – SUMIFS (Sum with Multiple Criteria)
⏱️ 10:23 - 12:19 – COUNTIFS (Count with Conditions)
⏱️ 12:20 - 15:29 – AVERAGEIFS (Average Based on Criteria)
⏱️ 15:30 - 17:40 – Revision (SUMIFS, COUNTIFS, AVERAGEIFS)
⏱️ 17:41 - 23:40 – IFERROR (Handle Errors in Formulas)
⏱️ 23:41 - 24:58 – RAND (Generate Random Numbers)
⏱️ 24:59 - 26:19 – RANDBETWEEN (Random Numbers in a Range)
⏱️ 26:20 - 28:13 – SUBTOTAL (Smart Summing with Filters)
⏱️ 28:14 - 32:37 – RANK (Rank Values in a List)
⏱️ 32:38 - 34:04 – Class Task (Test Your Skills)

🎯 Whether you’re preparing for a job, freelancing, or working on reports — this class will level up your Excel game!

📌These functions are very useful for students, professionals, and freelancers working with data.

👉 Watch till the end for practical examples and tips!
👉 Like, Share, and Subscribe to support the channel and stay updated.

Видео SUMIFS, COUNTIFS, AVERAGEIFS, IFERROR & RANK Explained | Excel Live Class 10 | Shanto My Excel канала SHANTO MY EXCEL