Courses

Course Description

Become job-ready for an MIS Executive role with strong Excel, Reporting, Automation & Resume skills.

Module 1: Excel Mastery (Day 1-20)

* Excel Interface, Navigation, Shortcuts
* Basic Formulas: SUM, AVERAGE, IF, COUNT
* Text Functions: LEFT, RIGHT, MID, CONCATENATE
* Date Functions: TODAY, NOW, DATEDIF
* Conditional Formatting, Data Validation
* Sorting, Filtering, Pivot Tables, Charts
* Basic Dashboards

Module 2: Advanced Excel + MIS Reports (Day 21-35)

* Nested IFs, IF with AND/OR
* Lookup Functions: VLOOKUP, HLOOKUP, INDEX+MATCH
* Error Handling: IFERROR, ISERROR
* What-If Analysis
* Named Ranges
* Sales, Inventory, Expense, Attendance Reports
* Mini-Projects: Attendance Dashboard, Sales Report

Module 3: Google Sheets (Day 36-40)

* Google Sheets Essentials
* Sharing, Permissions, Real-time Collaboration
* Forms Integration

Module 4: Power Query + Automation Basics (Day 41-50)

* Power Query Basics (Import, Clean, Load)
* Merge & Append Queries
* Connect to Multiple Files, Folders
* Automate Raw Data into Clean Report

Module 5: Basic VBA (Day 51-55)

* Record Macros
* Intro to VBA Editor
* Automate Excel Formatting, Emailing, Cleanup

Module 6: Resume + Interview (Day 56-60)