All courses

Advanced Excel

Power Query, pivot intelligence and business modelling.

Duration
4 weeks
Mode
Live online
Level
Beginner to Advanced
Course fee
₹6,999

Upcoming batches

Pick a start date that suits you. Reserve your seat with a part payment or pay the full fee online.

  • Starts 15 Aug 202607:00 – 09:00 AM ISTMon – Fri · Live online9 seats left
  • Starts 25 Aug 202607:00 – 09:00 PM ISTMon – Fri · Live online12 seats left
  • Starts 05 Sept 202610:00 AM – 01:00 PM ISTSat & Sun · Classroom + online6 seats left

Prerequisites

  • Working knowledge of basic Excel formulas
  • Windows laptop with Excel 2016 or newer / Microsoft 365

What you get

  • Live mentor-led sessions with recordings for lifetime revision
  • Portfolio-ready projects reviewed by industry practitioners
  • Course completion certificate plus certification exam prep
  • Resume, LinkedIn and mock-interview support
  • Placement assistance with our hiring partner network

Syllabus

Career and job oriented curriculum across three levels.

3 weeks · 24 hrsAnyone using Excel for daily office work.
Syllabus modules
  • Workbook structure, formatting and productivity shortcuts
  • Core formulas: IF, SUMIFS, COUNTIFS, TEXT functions
  • Lookups: VLOOKUP, XLOOKUP, INDEX-MATCH
  • Sorting, filtering, conditional formatting and data validation
  • Charts and basic pivot tables
  • Printing, protection and sharing best practice
Hands-on projects
  • Automated attendance and payroll tracker
  • Monthly sales summary workbook
Tools covered
Microsoft Excel 365
Job roles you can target
Office ExecutiveData Entry AnalystMIS Assistant

Ready to start your AI career?

Book a free demo session with a mentor and get a personalised learning and placement roadmap.

See Placement Support