SCHEDULE

Tutors

Pradeep Pandey

PROGRAM OVERVIEW

Unlock the full potential of Microsoft Excel with our Master Advance Excel Course designed for students, professionals, and data enthusiasts!
इस कोर्स में आप Excel के advanced formulas, data analysis tools और automation techniques सीखेंगे जो आपके काम को तेज, स्मार्ट और professional बनाएंगे।

From VLOOKUP to Power Functions, from Pivot Tables to Dashboards, आप हर skill step-by-step सीखेंगे – आसान भाषा और practical examples के साथ।

🔍 What You Will Learn:

  • Advanced Formulas: IFs, VLOOKUP, INDEX-MATCH, OFFSET

  • Logical, Lookup & Reference Functions

  • Text, Date & Time Manipulation Tricks

  • Data Validation, Conditional Formatting

  • Pivot Table, Power Query & Charts

  • Financial Functions: PMT, FV, etc.

  • Formula Auditing & Troubleshooting

  • Dashboard Preparation & Real Projects

🎯 Why This Course?

✅ हिंदी-English Mix में सिखाया गया
✅ Real-time screen practicals
✅ PDF Notes + Practice Files
✅ Quiz + Certificate after completion
✅ Lifetime access via LMS

🎓 Ideal For:

  • Job seekers preparing for Excel-based roles

  • Data entry operators & accountants

  • Teachers, Students & Freelancers

  • Anyone who wants to upgrade from Basic to Advance Excel

CURRICULUM

  Part 1: Core Tutorials (12 Modules)

  • Converting, Copying Formulas
  • Vlook Up
  • Choose Index Match
  • Count if Sum if Average if
  • Rank Median Average
  • Date Time Weekday Workday
  • Array Frequency
  • Find Data Extract Left Right
  • Replace Substitute Concetanate Upper Lower
  • Pmt and Fv
  • Is Function
  • Offset Data Extract

  Part 2: Formula Bank (9 Quick Lessons)

  • Count Count Blank Count if
  • Dated if, Abs, Average
  • Edate, Len
  • Large, Sum Product
  • Power, Rand Between
  • Repeat, Find
  • Round, Fixed
  • Small Roman and
  • Time, Trim, Year, Today, Now