Office II

Learning Outcomes

At the end of this course, the students will be able to: Operate Microsoft Office specifically Microsoft Excel by combining features, formulas and functions existing in Microsoft Excel.

Topics

1. Introduction to Microsoft Excel
2. Working with Microsoft Excel’s formula and basic function
3. Selection, calculation and Array function
4. Advanced functions which are combined with searching function (H/Vlookup)
5. Advanced functions which are combined with searching function (H/Vlookup and Match)
6. Consolidate, making graph and using toolbar drawing
7. Sorting function and data grouping in Microsoft Excel
8. Data selection by Using Filter Advanced Filter
9. Pivot Table
10. Pivot Table with Grouping
11. Import Data, Validation, Data Formatting
12. Macro and material review.