Brochure
Enquire
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
certificate availability
Yes
certificate providing authority
Careerera
The syllabus
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
Articles
Popular Articles
prev
next
Latest Articles
prev
next
