MS Excel & Advanced MIS Reporting
XLOOKUP, Pivot Tables, dynamic dashboards and macro basics for corporate roles.
Created by GCI India Faculty · 1 Month · Hindi & English · ₹699
About this course
Excel is one of the most asked-for skills in office, accounts and MIS jobs. This course takes you from cell formatting and basic formulas to lookups, pivot tables, charts and dynamic dashboards, using practice files that look like real business data. You also learn how to automate repeated work and prepare clean MIS reports that managers can read at a glance.
What you will learn
- Formatting, sorting, filtering and data cleaning
- Core formulas, IF logic and XLOOKUP / VLOOKUP
- Pivot tables, charts and interactive dashboards
- Building MIS reports from raw data
- Basics of automating repeated tasks with macros
Frequently asked questions
Which Excel version is used?
Lessons use modern Excel, and most techniques also work in older versions and in Google Sheets.
Will this help in an MIS or accounts job?
The course focuses on the formulas, pivot tables and reports used daily in MIS and accounts roles, so it is a practical skill to show in interviews.
Related courses
- CCC Computer Course (NIELIT Pattern)
Complete NIELIT syllabus: LibreOffice Writer, Calc, Impress, Internet and Cyber Security, with mock tests and bilingual notes.
3 Months · GCI India Faculty
₹999
₹1,999 - Free Computer Fundamentals & Typing Mastery
Windows basics, shortcuts, folder management and Hindi/English touch typing to boost your clerical speed.
2 Weeks · GCI India Faculty
Free
- O Level IT Tools & Network Basics (M1-R5)
Updated NIELIT syllabus with solved past papers and exam-ready practice.
4 Months · GCI India Faculty
₹1,499
₹2,999