Advanced Excel Complete Syllabus
Become a data analysis expert – formulas, pivot tables, macros, dashboards, and automation with real-world projects.
Duration: 2 Months
40+ hours practical
Govt. Certificate
NSDC & ISO certified
Data Analytics
Power Pivot, Power Query
Placement Support
MNCs, Finance, Analytics
📈 Industry-Aligned Advanced Excel Syllabus
Master data skills from fundamentals to advanced automation, specially crafted for data analysts, finance experts, and modern business managers to boost productivity and decision-making efficiency.
1
Excel Fundamentals & Data Management
- Cell referencing, data types, formatting
- Sorting, filtering, advanced filters
- Data validation, drop-down lists, custom rules
- Remove duplicates, text to columns, flash fill
- Protecting sheets, cells, and workbooks
2
Advanced Formulas & Functions
- Logical: IF, AND, OR, IFS, SWITCH
- Lookup: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH
- Text functions, date & time calculations
- Mathematical & statistical: SUMIFS, COUNTIFS, AVERAGEIFS
- Array formulas & dynamic arrays (FILTER, SORT, UNIQUE)
3
Data Visualization & Charts
- Column, bar, line, pie, area, scatter charts
- Combination charts & secondary axis
- Gantt chart, waterfall chart, funnel chart
- Sparklines, conditional formatting visuals
- Dynamic named ranges & interactive charts
4
Pivot Tables & Pivot Charts
- Creating Pivot Tables from large datasets
- Grouping, slicers, timelines, calculated fields
- Pivot Charts & dashboards
- GETPIVOTDATA function
- Power Pivot & Data Model introduction
5
Power Query & Data Transformation
- Import data from CSV, web, databases
- Merge, append, and clean data
- Unpivot, pivot, and split columns
- Conditional columns & custom transformations
- Load to worksheet or data model
6
Macros & Automation (VBA Basics)
- Recording & editing macros
- Understanding VBA editor, modules, procedures
- Variables, loops, and conditional statements
- User-defined functions (UDFs)
- Creating automated reports & buttons
7
Dashboard & Financial Modeling
- Design interactive executive dashboards
- Key Performance Indicators (KPIs) & scorecards
- Advanced Excel decision tools including What-If Analysis
- techniques such as Goal Seek, Scenario Manager, and Data Tables
- for smart forecasting and data-driven problem solving.
- Solver for optimization problems
- Loan amortization, NPV, IRR, financial functions
Live Capstone Project
- ✅ Interactive sales dashboard featuring key performance indicators (KPIs),
- ✅ smart slicers, and dynamic visual charts for real-time
- ✅ business insights and decision tracking.
- ✅ Financial model for a startup (P&L, cash flow, break-even analysis)
- ✅ Automated report using macros and Power Query
- ✅ Final assessment & certificate project evaluation
Why B Perfect for Advanced Excel?
✔️ Hands-on training with real datasets & business cases
✔️ Excel 2021 / Microsoft 365 latest features
✔️ Resume & interview prep for data analyst roles
✔️ Flexible batches: weekday/weekend/online
Master Data Analysis & Automation
Limited seats per batch. Get certified & placed with B Perfect Institute.
📍 CIDCO, Chhatrapati Sambhajinagar | Also available online & weekend batches