Courses

Curriculum

  • Sl. No.
  • Chapter
  • Chapter - 1
  • Introduction of Excel
  • Chapter - 2
  • Working with Workbook and Worksheets
  • Chapter - 3
  • Introducing Excel Tables Formulas and References
  • Chapter - 4
  • Formatting Data
  • Chapter - 5
  • Inserting Objects in Worksheets
  • Chapter - 6
  • Managing Data in Excel
  • Chapter - 7
  • Excel Formulas and Functions
  • Chapter - 8
  • References and LOOKUPs
  • Chapter - 9
  • Excel Tables
  • Chapter - 10
  • Working with Charts
  • Chapter - 11
  • Working with Pivot Table
  • Chapter - 12
  • What If Analysis - Goal Seek and Scenario Manager
  • Chapter - 13
  • Data Analysis and Validation
  • Chapter - 14
  • Macros
  • Chapter - 15
  • Printing Excel Workbooks
  • Chapter - 16
  • Managing Excel Files
  • Chapter - 17
  • Visual Basic for Application
  • Chapter - 18
  • Case Study 1 - Editing an Excel Macro in VBA
  • Chapter - 19
  • Case Study 2 – Creating User Forms in VBA
  • Chapter - 20
  • Case Study 3 – Custom Excel Functions
  • Chapter - 21
  • Case Study 4 – Conditional Logic in VBA
  • Chapter - 22
  • Case Study 5 – Create Dynamic Dashboard

Contact Us

Advanced Excel Certification, this Course and batch also available in other locations View

Top