PCO 448 - Microsoft Office Specialist (MOS) Expert Certification Training - Module 1

10 Continuing Education Units (CEU). This course is not for Credit(s).

This continuing education course is designed for students in professional settings to develop skills in the use of the Microsoft Office suite of products, specifically Microsoft Excel. Students will be prepared to earn the Microsoft Office Specialist (MOS) Expert certification. Topics to be covered include: creating and editing workbooks and worksheets; constructing rows and columns; common functions; lists and tables; advanced formatting; pivot tables; advanced functions; and macros.

Course Objectives

Upon completion of this course the student will be able to:

1. create a basic Microsoft Excel workbook;
2. formulate data in Microsoft Excel worksheets;
3. edit Microsoft Excel worksheets;
4. construct worksheets with rows and columns;
5. utilize common functions;
6. construct lists and tables;
7. use advanced formatting;
8. use pivot tables;
9. implement advanced functions; and
10. utilize recording and use macros.