Advanced Excel
with Dashboards &
Live Projects
by Brand Blower – Learn from Industry Experts
About Course.
Duration: 1 to 1.5 Months | Mode: Offline / 1:1
Sessions: 16–18 (1.5 hrs each, 3 Days/Week)
Language: Hindi + English | Location: New Delhi
Weekly Course Structure.
Week 1
Basics, Shortcuts, Formatting, Sorting, Printing
Week 2
IF, AND, OR, CONCATENATE, Date/Time Formulas
Week 3
LOOKUP, XLOOKUP, INDEX+MATCH, IFERROR
Week 4
Pivot Tables, Charts, Validation, Analysis
Week 5
Dashboard Design, Form Controls, Interactivity
Week 6
Macros, Export to PDF, Security, Final Project
Live Project Samples.
Sales Dashboard (Dynamic)
- Sales Dashboard (Dynamic)
HR Attendance + Performance Tracker
- HR Attendance + Performance Tracker
Finance Dashboard (Income vs Expense)
- Finance Dashboard(Income vs Expense)
CRM / Lead Management Dashboard
- CRM/Lead Management Dashboard
Inventory Tracker with Alerts
- Inventory Tracker with Alerts
Tools And Features Covered
VLOOKUP & XLOOKUP
Master advanced lookup functions
INDEX + MATCH
Advanced nesting techniques
Pivot Tables
Dynamic analysis with slicers
Advanced Charts
Line, Bar, Combo visualizations
Macros & Automation
Streamline repetitive tasks
Data Validation
What-If analysis & controls
What Students
Will Get.
50+ Practice Excel Files
PDF Notes + Shortcuts Sheet
Completion Certificate
Interview Questions for Excel
Resume Help for Freshers
Frequenctly Asked Questions
Q: Do I need prior Excel knowledge?
A: No, we start from the basics and build up to advanced concepts.
Q: Will I get a certificate?
A: Yes, a certificate of completion is provided upon course completion.
Q: Are the projects industry-based?
A: Yes! Projects are mapped to real-world scenarios in HR, Sales, Finance, and more.
Contact & Location
Institute
Brand Blower
Website
www.brandblower.in
Week 3
+91 92665 65299
Week 4
Metro Pillar No. 773, Plot 18, GF, Near Dwarka Mor, Sewak Park, Nawada, New Delhi – 110059
