11/06/2026
When we talk to fresh graduates, they know accounting concepts but struggle with Excel. 🤔
Mastering these 10 Excel functions can make you job-ready faster than many fresh graduates! Like me.
📊Top 10 Excel Functions Every Accounting Student Should Learn
1. SUM() – Add Numbers Quickly
✅ Example: =SUM(A1:A5)
💡 If your expenses are 1000, 2000, 1500, 3000, and 2500, SUM will calculate the total automatically.
✅ Use for: Total Sales, Total Expenses, Budget Calculation.
2. AVERAGE() – Find the Average Value
🔹 Example: =AVERAGE(A1:A5)
💡 If five employees earned 20,000, 25,000, 30,000, 35,000, and 40,000, Excel will show the average salary.
✅ Use for: Average Salary, Average Sales, Performance Analysis.
3. COUNT() – Count Numeric Entries
🔹 Example: =COUNT(A1:A10)
💡 If there are 8 numbers in the range, the result will be 8.
✅ Use for: Counting Transactions, Attendance Records, Invoice Tracking.
4. IF() – Create Conditions
🔹 Example: =IF(A1>=40,"Pass","Fail")
💡 If a student scores 45, Excel returns "Pass".
✅ Use for: Pass/Fail, Approved/Rejected, Bonus Eligibility.
5. COUNTIF() – Count Based on Criteria
🔹 Example: =COUNTIF(A1:A10,"Present")
💡 Counts how many times "Present" appears.
✅ Use for: Attendance Reports, Status Tracking, Employee Records.
6. SUMIF() – Sum Based on Conditions
🔹 Example: =SUMIF(A1:A10,"Sales",B1:B10)
💡 Adds only values related to Sales.
✅ Use for: Department-wise Expenses, Category-wise Sales, Budget Analysis.
7. VLOOKUP() – Find Data from Another Table
🔹 Example: =VLOOKUP(101,A:B,2,FALSE)
💡 Finds Employee ID 101 and returns the employee name.
✅ Use for: Employee Records, Product Lists, Customer Databases.
8. XLOOKUP() – Advanced Version of VLOOKUP
🔹 Example: =XLOOKUP(101,A:A,B:B)
💡 Easier and more flexible than VLOOKUP.
✅ Use for: Modern Excel Reports, Large Datasets, Accurate Lookups.
9. IFERROR() – Handle Errors Professionally
🔹 Example: =IFERROR(A1/B1,0)
💡 Instead of showing /0!, Excel shows 0.
✅ Use for: Cleaner Reports, Dashboards, Financial Statements.
10. Pivot Table – Summarize Large Data Instantly
🔹 Example: Sales Data (January = 50k, February = 70k, March = 60k)
💡 Pivot Table can summarize monthly, yearly, or employee-wise sales in seconds.
✅ Use for: Sales Reports, Expense Analysis, Management Reporting.
Best Free Resources to Learn Excel:
YouTube Channels:
• ExcelIsFun
• Leila Gharani
• Kevin Stratvert
• MyOnlineTrainingHub
Web Websites:
• Microsoft Learn
• Excel Easy
• Coursera (Free Courses Available)
💡If you're an Accounting or Finance student, start with this roadmap:
SUM ➔ IF ➔ COUNTIF ➔ SUMIF ➔ VLOOKUP ➔ Pivot Table
