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)

HR Attendance + Performance Tracker

Finance Dashboard (Income vs Expense)

CRM / Lead Management Dashboard

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

Call Us