MS Excel Basics(14 Hours)

• Excel Setting
• Formatting
  • Style
  • Conditional Formatting
  • Table Formatting
  • Themes
• Working with Worksheet
  • Sort
  • Filter
  • Text To Columns
  • Hyperlinks
  • Protection
  • Remove Duplicates
  • Validation
• Simple Functions
  • Math & Statistical Functions
  • Date & Time Functions
  • Text Functions
  • Logical Functions
  • Lookup Functions

Intermediate (10 Hours)

Integration (2 Hours)

• Link
• PDF

Excel Charts (8 Hours)

• Basic Charts
• Charting
• Advanced Charts

MS Excel Advanced (20 Hours)

• Advance Formatting
• Advanced Functions
• Database
• What-If Analysis
• Data Analysis
• Advanced Tools
• Power Pivot and Power Map (2 Hours)
  • PowerPivot
  • Power Map
  • Power Query

Excel VBA

• Macro Security (30 min)
• Macros (2 Hr)
• Knowing VBE (2 Hr)
• VBA (Starting to writing your own Macro Code) (2 Hrs)
• Functions and Conditional Logic (2 Hrs)
• Understand Programming (4 Hrs)
• Working with Objects (6-8 Hrs)
• Working with Methods & Events (3 Hrs)
• Working with Forms/User Interface (2 Hrs)
• Debugging and Error Handling (2 Hrs)
• Working with Add-Ins & Templates (2 Hrs)