Training Topic : Fundamental Microsoft Excel
Duration : 6 hours
Media : Offline
Vendor : Nusa Consultant
Maximum : 20 Participants
Target Participants : All employees
Investments : to be updated
Location : Auditorium 5th floor
Time : On Schedule
The objectives of this training :
Participants get a complete overview of the features and capabilities of Ms Excel.
Participants can make optimal use of MS Excel features.
1. Excel Introduction
2. Excel Basic Formula and Function
3. Lookup Function : VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH
4. Aggregate Function : SUMIF, SUMIFS
5. Conditional Formatting
6. Pivot Table
7. Excel Chart