Advanced Excel Course in Banashankari, Kathriguppe
Master formulas, XLOOKUP, PivotTables, Power Query, MIS reporting and dashboards, with AI for Excel and optional VBA automation, at Phillos, Outer Ring Road, Banashankari 3rd Stage.
- About 1 month
- From ₹6,500
- AI for Excel
- Optional VBA
Where can I learn Advanced Excel in Banashankari? Phillos Training Institute teaches Advanced Excel at its new Kathriguppe branch on Outer Ring Road, Banashankari 3rd Stage, in three packages: Advanced Excel (₹6,500), Advanced Excel + AI (₹10,500) and Advanced Excel + AI + VBA (₹13,500). The core program takes about 1 month, with weekday and weekend batches. The branch opens in October 2026.
Excel skills that show up in real jobs
Go past SUM and VLOOKUP. Clean data, build MIS reports and dashboards, use AI to work faster, and automate with VBA if you want.
Core Advanced Excel
Advanced formulas, XLOOKUP, INDEX-MATCH, PivotTables, charts and data validation.
Power Query included
Import, clean, merge, append and refresh data without manual copy-paste.
AI for Excel
Use AI to write and fix formulas, clean data and draft insights (Excel + AI and complete packages).
MIS reports and dashboards
Sales MIS, employee MIS, financial and inventory analysis, and KPI dashboards.
Optional VBA automation
Macros, loops and automated MIS report generation in the complete package.
Certificate and placement help
Course certificate, resume support and career guidance. It is assistance, not a job guarantee.
What you will learn in Advanced Excel
Twelve core modules for every student. AI and VBA content is added by package.
- MIS Executive
- MIS Analyst
- Reporting Executive
- Data Analyst
- Business Analyst
- Operations Executive
- Finance Executive
- HR Analyst
01Excel fundamentals and productivity
- Interface, workbook management and formatting
- Number, date and text formats
- Freeze panes, views and shortcuts
02Essential and advanced formulas
- Relative, absolute and mixed references
- SUMIFS, COUNTIFS, IF, AND, OR, IFERROR
- Text and date functions
03Advanced lookup functions
- VLOOKUP, HLOOKUP, XLOOKUP
- INDEX + MATCH and multiple-criteria lookups
- Lookup error handling
04Data cleaning and preparation
- Remove duplicates, Text to Columns, Flash Fill
- Standardising data, blanks and errors
- Excel Tables and named ranges
05Data validation and conditional formatting
- Drop-down and dependent lists
- Custom validation rules
- Formula-based and duplicate highlighting
06Sorting, filtering and data management
- Multi-level sorting and advanced filters
- Structured references
- Managing large datasets
07PivotTables and PivotCharts
- Grouping, calculated fields
- Slicers and timelines
- Interactive reporting
08Charts and data visualisation
- Column, bar, line, pie and combo charts
- Dynamic charts and sparklines
- Choosing the right chart
09Power Query for Excel
- Import Excel and CSV data
- Split, merge, append and merge queries
- Refreshable data-cleaning workflows
10MIS reporting
- Daily, weekly and monthly reports
- Sales, HR and attendance MIS
- Management and business reports
11Excel dashboards
- Dashboard planning and KPI design
- Pivot-based dashboards
- Interactive charts and layout
12Excel for job and business applications
- Sales, employee, financial and inventory analysis
- MIS Executive tasks
- Interview practice
13AI for Excel (Excel + AI and complete packages)
- Generate and explain formulas with AI
- Fix formula errors and assist data cleaning
- AI-assisted analysis, KPIs and Power Query
- Reusable prompts for Excel work
14VBA and macros (complete package)
- Macro recording and the VBA editor
- Variables, conditions and loops
- Workbook, Worksheet and Range objects
- Automated MIS reports and AI-assisted VBA
Pick a schedule that fits your week
Exact start dates for the first Banashankari batch are shared when you pre-register.
| Batch | Schedule | Best for | Where |
|---|---|---|---|
| Weekday | Flexible weekday slots | Students and job seekers | Classroom or online |
| Weekend | Saturday and Sunday | Working professionals | Classroom or online |
| Online | Live sessions, timings on request | Start today, or learn from anywhere | Online |
Choose your Excel package
The final schedule can vary by package, batch and project. Ask about current admission offers.
Advanced Excel
- Advanced formulas and lookups
- PivotTables, charts and Power Query
- MIS reporting and dashboards
- Practical projects and certificate
Advanced Excel + AI
- Everything in Advanced Excel
- AI-assisted formulas and troubleshooting
- AI for data cleaning, analysis and KPIs
- Practical AI + Excel project
Excel + AI + VBA
- Everything in Advanced Excel + AI
- Macros and VBA fundamentals
- Automated MIS report generation
- Final Excel automation project
Made for people like you
Students and commerce graduatesB.Com, BBA and BBM students who want MIS and reporting skills.
MIS and finance professionalsMove from basic sheets to Power Query, dashboards and automation.
HR, sales and operations teamsBuild reports and analysis without waiting for others.
Entrepreneurs and analystsAnalyse your own data and automate repetitive work.
Phillos, Kathriguppe, Banashankari 3rd Stage
On Outer Ring Road next to Max, serving students from Kathriguppe, Banashankari, JP Nagar, Uttarahalli, Srinagar and nearby areas.
Kathriguppe, Banashankari 3rd Stage,
Bengaluru – 560085
Areas we serve
- Kathriguppe
- Banashankari 3rd Stage
- Banashankari 2nd Stage
- Hosakerehalli
- Kumaraswamy Layout
- JP Nagar
- Uttarahalli
- Srinagar
- Girinagar
- Padmanabhanagar
Not nearby? Join an online batch from anywhere in Bangalore.
Questions students ask before joining
Need something else? Message us on WhatsApp and we will reply with batch and fee details.
Ask on WhatsAppWhat is the fee for the Advanced Excel course in Banashankari?
How long is the course?
Does the course include VBA?
Does Phillos teach AI for Excel?
Is Power Query included?
Can beginners join?
When does the Banashankari branch open?
Are certification and placement help provided?
Reserve your seat in the first Banashankari batch
Pre-register today, start online if you like, and move to the Kathriguppe classroom in October 2026.