Skip to main content
Excel MIS Practice Lab

Excel Functions Practice

Master the Excel functions that power MIS, reporting and analyst work. Each topic links to an interactive exercise where you can practise the function in a real scenario.

SUMIFS Practice

Learn to sum values based on multiple conditions. Essential for sales and inventory summaries.

Practise SUMIFS

XLOOKUP Practice

Look up values in any direction, handle missing matches and build cleaner formulas than VLOOKUP.

Practise XLOOKUP

Pivot Table Practice

Understand grouping, summarising and cross-tabulation with pivot-table-style exercises.

Practise Pivot