Advanced Excel

Equipment:
- Desktop PC
- Fast internet connection
- Lab exercises/activity

Duration: 9am to 5pm
2 days training
16 hours

Inclusion (face-to-face training): Lunch Meal and snack
Certificate of completion
Training handout
Free flowing coffee

Inclusion (Online Training): Certificate of completion
Training handout (soft copy)

Day 1


• Text Manipulation
   Upper, lower, Proper
   Trim , Round & Truncate, 
   Replace & Substitute,
   Left, Mid, Right
• Advance Cell Formatting
• Working with Basic Excel
  Formulas
• Cell Reference
    Relative
    Absolute
    Mixed
• Data Validation
• Conditional Formatting
• Concatenation 

Day 2


• Text to Columns
• IF, IFAnd, IFOr, IFNested
• Count, CountIF, CountIFS
• Sum SumIF SumIFs
• Lookup, HLookup, VLookup
• Charts
• Sparklines
• Pivot Table
• Slicer
• Consolidate
• Recommended Charts
• Macros
• VBA