Excel Lab
A real MIS sales report in your browser. Switch between tabs to see how each Excel feature turns raw rows into a report a manager can read in seconds.
This is what an MIS report starts as
24 rows of monthly sales — region, product, units, revenue. Click the tabs to see what you'll learn to do with it in class.
Excel Chart Studio
Six advanced chart types you will learn to build.
The Excel skills every MIS job asks for
1. SUMIFS, COUNTIFS, AVERAGEIFS
Totals with conditions — revenue for one region, count of orders above a value, average by product. These replace hours of manual filtering.
2. VLOOKUP, XLOOKUP, INDEX-MATCH
Pull matching data from another sheet: employee name from ID, price from product code, manager from region.
3. Pivot Tables, slicers and timelines
Summarise thousands of rows by any dimension in seconds. Add slicers to make an interactive dashboard.
4. Conditional formatting & charts
Highlight what matters and turn tables into charts that tell the story.
5. Macros & VBA
Automate the daily report: one click to refresh, format, split and email. Covered in our VBA & Macros course.