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
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

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

• 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

• 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