Advanced Excel Mastery Course – Just ₹699

Quick Recap – Excel Basics Refresher:

• Lesson 1: Excel Interface & Workbook Structure
• Lesson 2: Data Entry Tips – AutoFill, Flash Fill & Shortcuts
• Lesson 3: Formatting Cells Like a Pro (Number, Text, Date)
• Lesson 4: Understanding Rows, Columns, Sheets & Navigation

Mastering Core Excel Tools:

• Lesson 5: Data Validation – Create Professional Dropdowns
• Lesson 6: Conditional Formatting – Highlight Data Smartly
• Lesson 7: Smart Sorting & Filtering (Multi-level & Custom)
• Lesson 8: Freeze Panes, Split View & Tricks for Big Data Handling

Formula & Function Mastery:

• Lesson 9: Logical Formulas – IF, IFS, AND, OR, NOT
• Lesson 10: Text Functions – LEFT, RIGHT, MID, LEN, TRIM, CONCAT
• Lesson 11: Lookup Power – VLOOKUP, HLOOKUP, XLOOKUP (Live Data)
• Lesson 12: Dynamic Excel – UNIQUE, FILTER, SORTBY, WRAPROWS
• Lesson 13: Nesting Formulas – Combine Multiple Functions Smartly

Excel Data Analysis Tools:

• Lesson 14: Creating Pivot Tables from Scratch
• Lesson 15: Using Slicers & Filters in Pivots
• Lesson 16: Creating Eye-Catching Charts (Bar, Pie, Line, Combo)
• Lesson 17: Sparklines – Mini Charts for Quick Insights

Real-World Excel Projects:

• Lesson 18: Salary Sheet with Tax & PF Auto-Calculation
• Lesson 19: Salary Slip Integration with MS Word
• Lesson 20: Attendance Tracker with Conditional Formatting
• Lesson 21: Student Report Card Generator with Formulas
• Lesson 22: Invoice Generator (Auto Date, Client & Product Logic

Dashboard Building & Reporting:

• Lesson 23: Monthly Sales Dashboard – Interactive & Printable
• Lesson 24: Building a Simple Dashboard from Real Sales Data
• Lesson 25: Interactive Dashboard – Monthly Sales Report
• Lesson 26: KPI Summary using Pivot Tables + Charts
• Lesson 27: Slicers & Dropdown-Based Data Filtering
• Lesson 28: Bank Reconciliation Statement with Tally Format