Online Advanced Excel Course with Certificate
Learn Advanced Excel and MIS reporting in live online classes from anywhere in India. Aptech Learning Center, Lucknow teaches the Excel skills offices use every day, with practice files you work on during each class.
Course at a glance
- Course
- Advanced Excel & MIS (online)
- Format
- Live trainer-led classes on video call, plus practice files
- Covers
- Formulas, lookups, data cleaning, pivot tables, charts, dashboards, MIS reports, intro to macros
- Software
- Microsoft Excel 2016 or later (Microsoft 365 recommended)
- Who it is for
- Students, job seekers, MIS and back-office staff, accountants and managers
- Certificate
- Aptech Learning course certificate after the practical assessment
- Classroom option
- Same course at Mahanagar Extension, Lucknow — see the classroom course
What you learn
- Core formulas: IF, SUMIFS, COUNTIFS, text and date functions
- Lookups: VLOOKUP, HLOOKUP, INDEX-MATCH and XLOOKUP
- Data cleaning: sorting, filters, data validation, removing duplicates, Power Query basics
- Pivot tables and charts: summarising large data and building clear charts
- Dashboards and MIS: daily, weekly and monthly reports the way offices use them
- Automation basics: recording simple macros to save repeated work
How the online classes work
- Practice files. You get a set of practice workbooks before the first class.
- Learn live. The trainer works through each topic on screen and explains when to use which tool.
- Practise during class. You build the same sheets on your computer while the trainer checks your work.
- Build an MIS report. You create a working dashboard and MIS report you can show employers.
- Final assessment. A practical test leads to your course certificate.
Who should join
- Students and freshers applying for office, MIS or back-office jobs
- Accountants who want faster reconciliation and reporting
- Sales, operations and HR staff who build reports every week
- Anyone moving into data analytics — Excel is the first step
Frequently asked questions
Which Excel version do I need?
Excel 2016 or later works. Microsoft 365 is recommended because it includes XLOOKUP and the newest functions.
Is this course useful for jobs?
Yes. Advanced Excel and MIS reporting are asked for in accounts, MIS, operations and back-office roles.
Can I join from outside Lucknow?
Yes. Online batches are open to learners anywhere in India.
Will I get a certificate?
Yes. You receive an Aptech Learning course certificate after the practical assessment.
How do I check fees and batch timings?
Call or WhatsApp +91 63861 19566.
Related: Excel career options · Excel salaries in India · all online courses

