Excel Training Courses

Excel Training Courses

  1. We provide Online Coaching,In -person
  2. Weekdays-Weekend Classes as per your ease
  3. Not more than 5 Students in one Batch
  4. Programme equipped with HardCore EXCEL Assignments
  5. Projects Making
  6. Online help even after the Training- Forever
  7. Arrangement of Videos for the revision of each Subject
  8. You may choose your Topics and we can design the training accordingly
  9. Easy EMI Options available
  10. 2 Days free Classes
  11. 100% Money Back Gurantee

Course Contents, For weekly new Videos,Subscribe to my YOUTUBE Channel:www.youtube.com/c/ajaykumarparmar

Day 1

  • Introduction To Excel
  • Ribbons Introduction
  • Options
  • Shortcuts
  • Remove Dupliocates
  • Cell Formating
  • Protection
  • Paste Special
  • Goto

Day 2

  • Error Handling
  • Upper/Lower/Proper
  • Vlookup
  • Hlookup
  • Match
  • Column & Row
  • Trim
  • Len
  • Find
  • Search
  • Left
  • Right
  • Mid

Day 3

  • Index
  • Lookup
  • Vlookup (Approx)
  • Rand
  • Randbetween
  • Round, Rounddown, Roundup
  • Advance filter
  • choose
  • MOD
  • INT
  • Rank
  • MIN
  • MAX
  • Large
  • Small
  • ABS

Day 4

  • Count
  • CountA
  • CountBlank
  • Countif & Countifs
  • Sumif & Sumifs
  • AverageIf & Averageifs
  • Sumproduct

Day 5

  • Substitute
  • Lower
  • Upper
  • Proper
  • Replace
  • Rept
  • Adv Filter

Day 6

  • Date
  • DateValue
  • Day & Month & Year
  • Now & Today
  • Text
  • Weekday
  • Networkdays & Workdays

Day 7

  • Time Formulas
  • IF
  • Nested IF
  • ABS
  • Address
  • Complete Discussion on Charts

Day 8

  • Indirect
  • Data Validation
  • Name Manager & Creation of Dynamic Range
  • Pivot Table Study in Depth
  • Slicers
  • Build formula in Pivots
  • GetpivotData
  • Array Formula

Day 9

  • Conditional Formating
  • D Family

Day 10

  • Goal Seek
  • Importing Data from external Source
  • Export feature