Excel Assignment-10 | COUNTA, COUNTIF, SUMIF & VLOOKUP Full Explanation | Excel Practice File

Описание: 📌 Assignment-10 | Excel Formulas – COUNTA, COUNTIF, SUMIF & VLOOKUP (Hindi Tutorial)
#Excel #ExcelTutorial #ExcelFormulas #VLOOKUP #SUMIF #COUNTIF #COUNTA #ExcelAssignment #ExcelInHindi #MSExcel
इस वीडियो में हम Excel के सबसे ज़्यादा इस्तेमाल होने वाले Formulas को Real Data के साथ समझेंगे:
✔ COUNTA – Total Entries Count
✔ COUNTIF – Department Based Count
✔ SUMIF – Department Wise Total Earnings
✔ VLOOKUP – Employee Details Search

इस Assignment में आपको सिखाया जाएगा कि Excel में Employee List से कैसे:
👉 Total Employees निकालें
👉 Marketing & Finance Department में कितने Employee हैं
👉 Manoj Mishra के Department और Earnings कैसे Find करें
👉 Rajesh का SSN Number कैसे निकालें
👉 Marketing Department की Total Earnings कैसे निकालें

ये वीडियो Students, Office Employees, Beginners और Job Seekers सभी के लिए बेहद उपयोगी है।

⭐ Time Stamps

00:00 – Introduction
00:30 – COUNTA Formula
02:10 – COUNTIF Formula
04:20 – SUMIF Formula
06:40 – VLOOKUP पूरा समझें
10:00 – Assignment Solution
12:00 – Final Tips

🔑 SEO Keywords

Excel Assignment 10

Excel COUNTA formula in Hindi

Excel COUNTIF formula tutorial

SUMIF formula with example

VLOOKUP Hindi explanation

Excel formulas for beginners

Excel job interview formulas

Excel practice assignment

Excel employee data project

Best Excel lesson in Hindi


#Excel #ExcelTutorial #ExcelFormulas #VLOOKUP #SUMIF #COUNTIF #COUNTA #ExcelAssignment #ExcelInHindi #MSExcel