Intermediate25 min
Daily Sales MIS Report
Clean a realistic sales dataset, identify duplicate orders, calculate branch-wise revenue and measure target achievement for an MIS report.
SUMIFSCOUNTIFSVLOOKUPXLOOKUP
11 tasksSales Reporting
Start ExercisePractice Exercises
Choose an exercise and start practising immediately. Each exercise includes a realistic dataset, step-by-step tasks and instant feedback.
Intermediate20 min
Inventory Management Report
Track stock levels, identify reorder needs, calculate inventory value and summarise stock by category for a warehouse MIS report.
SUMIFSCOUNTIFSIFBasic Arithmetic
9 tasksInventory Management
Start ExerciseBeginner20 min
Employee Attendance and HR Report
Clean attendance data, calculate working hours, identify late arrivals and prepare a department-wise attendance summary.
Time ArithmeticIFCOUNTIFSSUMIFS
9 tasksAttendance Reporting
Start ExerciseIntermediate25 min
Bank Reconciliation Report
Reconcile a cash-book against bank movements: total debits and credits, closing balance, uncleared items and category totals.
SUMIFSUMIFSCOUNTIFMAX
6 tasksReconciliation
Start ExerciseBeginner20 min
Employee Payroll MIS Report
Calculate net salaries, build payroll totals, department headcount and statutory contribution summaries for a monthly MIS payroll report.
SUMAVERAGEMAXCOUNTIF
7 tasksPayroll
Start Exercise