Course Details

  • Home
  • Course Details

Topics for This Course

  • Session 1 – Introduction & Excel interface
  • Session 2 – Data entry & basic formatting
  • Session 3 – Fill handle, Flash Fill, and basic editing
  • Session 4 – Simple formulas & error handling
  • Session 5 – Basic text & number formatting tasks
  • Session 6 – Introduction to functions (why functions?)

  • Session 7 – SUMIF, SUMIFS, COUNTIF, COUNTIFS
  • Session 8 – Date & time basics
  • Session 9 – DATEDIF, WORKDAY, NETWORKDAYS
  • Session 10 – Lookup basics (VLOOKUP practical)
  • Session 11 – Advanced lookup (INDEX + MATCH)
  • Session 12 – Nested lookups & error handling (IF + ISERROR)

  • Session 13 – Flash Fill deep dive & text functions
  • Session 14 – Sort data (single & multi level)
  • Session 15 – AutoFilter & advanced filtering
  • Session 16 – Subtotal function & structure
  • Session 17 – Data validation & protection basics
  • Session 18 – Conditional formatting basics

  • Session 19 – PivotTable basics
  • Session 20 – PivotTable advanced
  • Session 21 – PivotChart basics
  • Session 22 – Conditional formatting for PivotTables
  • Session 23 – Standard charts (column, line, pie, bar)
  • Session 24 – Dashboard concepts (simple)

  • Session 25 – XLOOKUP (Excel 365 style)
  • Session 26 – Advanced lookup patterns (nested, multiple criteria)
  • Session 27 – Conditional formatting creative rules
  • Session 28 – Power features overview (Power Query / Power Pivot)
  • Session 29 – Newest Excel features (2023–2025 style)
  • Session 30 – Final project + recap

Teaching Faculty

Author Images
Ajay Patil
Faculty (MBA Finance)

MBA professional with a strong foundation in Finance and IT, and 10+ years of experience in teaching Tally. Tally Trainer Trained over 500+ students and professionals in Tally ERP, enhancing their accounting and business skills. Developed customized training modules for businesses, improving efficiency in accounting processes.

Courses

Course Includes:

  • Price: Rs. 5000
  • Faculty: Ajay Patil
  • book iconLessons: 5
  • Duration: 30 Days
  • Timing: 6.30 PM - 7.30 PM
  • Language: Eng/Hin/Mar
  • Certificate: Yes
Register Now