Advanced Excelwith Dashboards &Live Projects by Brand Blower – Learn from Industry Experts About Course. Duration: 1 to 1.5 Months | Mode: Offline / 1:1Sessions: 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 StudentsWill Get. 50+ Practice Excel Files PDF Notes + Shortcuts Sheet Completion Certificate Interview Questions for Excel Resume Help for Freshers Investment: Basic Excel ₹4,000 | Advanced Excel ₹8,000 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