Learn the Excel skills that MIS and reporting roles actually test. SUMIFS, XLOOKUP, INDEX/MATCH, PivotTables, dashboards, Power Query — taught through real office-style assignments, not slide shows.
Professionals who create reports, track data, and prepare monthly summaries — and want to stop doing it manually.
Staff already in MIS roles who need to move from basic formulas to real dashboards and automated reports.
Anyone preparing for roles that include an Excel test in the interview — analyst, reporting, operations, back-office.
Owners who want to read their own sales, stock, and expense data without waiting for someone else to prepare reports.
Eight modules, each built around a practical task. You will work on sample business data — sales, expenses, stock — and produce reports that look like real office output.
| Module | Topics Covered | Practical Work |
|---|---|---|
| 1. Data Cleaning & Formatting | Text to Columns, TRIM, CLEAN, PROPER, removing duplicates, number formatting, custom formats | Clean a messy 500-row sales sheet |
| 2. Logical Functions | IF, nested IF, IFS, AND/OR, IFERROR, SWITCH | Grade sheets, discount slabs, error handling |
| 3. Conditional Functions | SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS | Region-wise sales, month-wise totals, KPI summaries |
| 4. Lookup Functions | VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH, two-way lookups, approximate matches | Product master mapping, employee lookup, tax slabs |
| 5. PivotTables & Charts | PivotTables, PivotCharts, grouping, slicers, calculated fields, GETPIVOTDATA | Interactive sales report by region, product, month |
| 6. Conditional Formatting & Data Validation | Highlight rules, icon sets, data bars, formula-based rules, dropdown lists, input messages | KPI dashboard with RAG status, data-entry forms |
| 7. Dashboard Development | Layout planning, named ranges, dynamic charts, KPI cards, print-ready layout | Build a one-page MIS dashboard from raw data |
| 8. Power Query & Automation Intro | Importing data, basic transformations, merging tables, VBA overview (recorded macros) | Auto-refresh a monthly report from a folder of files |
Duration: Contact us for current duration and batch schedule.
Batch timings: Morning, afternoon, and evening batches available. Weekend batches on request.
Every formula below is syntactically correct and works in the version stated. Version-specific functions are flagged.
Total sales for the "North" region in the month of "Apr-2025":
Find the price of a product by its code:
Same lookup, compatible with Excel 2010 and later:
Count how many orders are "Pending" and above ₹10,000:
Return "Not Found" instead of #N/A:
You receive a 500-row export with inconsistent names, extra spaces, duplicate rows, and mixed date formats. Your task: clean every column, split combined fields, remove duplicates, and produce a tidy table ready for analysis.
From the cleaned data, create a one-page MIS with:
Design a one-page dashboard with:
Using Power Query, import data from a folder of monthly CSV files. Build a query that merges them into one table and refreshes with a single click.
| Job Role | Typical Excel Skills Tested |
|---|---|
| MIS Executive | SUMIFS, PivotTables, dashboards, conditional formatting |
| Reporting Analyst | Lookups, Power Query, data cleaning, chart building |
| Operations Executive | COUNTIFS, data validation, daily trackers |
| Back-Office Executive | VLOOKUP/XLOOKUP, IFERROR, basic PivotTables |
| Accounts Assistant (Excel side) | SUMIFS, reconciliations, format checks |
These are commonly asked in MIS and analyst interviews. Each answer is technically correct.
=IFERROR(VLOOKUP(...), "Not Found"). Alternatively, use XLOOKUP's built-in if_not_found argument: =XLOOKUP(..., "Not Found").Advanced Excel & MIS focuses on Excel-based reporting and dashboards. Data Analytics adds SQL and Power BI for larger datasets and interactive reports. If your target role mentions SQL or Power BI, take Data Analytics after Excel. If your role is Excel-only, this course is sufficient.
If you are moving into accounts work, Tally first (it teaches the accounting workflow) then Excel. If your work is already report-based, Excel can come first.
Yes, a certificate is issued on completion by the institute. Ask for the exact certificate issuer name and any recognition details in writing before enrolling.
See the teaching style, the lab, and the assignments before you decide.
📱 WhatsApp Us 📞 Call Now