Advanced Excel Course with Certificate
Master formulas, lookups, pivots, Power Query, DAX and VBA to land MIS, reporting and analyst jobs
Course fee
One-time fee for the full Advanced Excel course. EMI and batch options are shared by the counsellor.
- Live mentor-led classes with recordings
- Hands-on projects and assignments
- Interview preparation with this question bank
- Course completion certificate
- Placement support
What you will learn
- Cell references and named ranges
- Excel Tables
- Number and custom formats
- Conditional formatting
- Data validation and protection
Project: Build a protected monthly expense tracker with dropdowns, Table totals and conditional formatting alerts.
- IF, IFS, AND, OR
- SUMIFS and COUNTIFS
- Text cleaning functions
- Date functions and financial year logic
- Error handling
Project: Create a sales incentive calculator with slab-based commission and financial-year summaries per salesperson.
- XLOOKUP and INDEX/MATCH
- Multi-criteria lookups
- FILTER, SORT, UNIQUE
- LET and LAMBDA
- Reconciliation techniques
Project: Reconcile a bank statement with a ledger and produce a live list of unmatched entries.
- Pivot tables and grouping
- Show Values As
- Slicers and timelines
- Combo and waterfall charts
- Dashboard design
Project: Design a one-page interactive sales dashboard with KPIs, trends and region and product slicers.
- Folder imports and append
- Merge and join kinds
- Unpivot and data types
- Data Model relationships
- DAX measures and time intelligence
Project: Combine 12 monthly branch files into a refreshable Data Model with YTD and growth measures.
- Macro recorder and VBA editor
- Loops and last-row logic
- Events and error handling
- Arrays and dictionaries
- PDF and email automation
Project: Automate region-wise PDF report generation and email each report to its regional manager.
Tools you will use
Frequently asked questions
What is the fee for the Advanced Excel course?
The Advanced Excel course fee is ₹4,999. Ask the counsellor about current batch dates, EMI options and any running offers.
How long is the Advanced Excel course?
The course runs for about 8 weeks and follows the 6-phase roadmap shown on this page.
Do I get a certificate?
Yes. You get a course completion certificate after finishing the course and its projects.