Course 1

Advanced Excel Certification

• Upcoming Batches
• 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

Read More