Create and modify PivotTables (PG1, PG2)Ĥ. Specific skills include create, format, modify, filter and sortĭata in tables. Manage tables and table data using Microsoft Excel software. Specific skills include manipulate data, format cells and ranges,ĭefine and reference named ranges, apply conditional formattingĪnd filtering, validate data, and summarize data visually. Manage cells and ranges using Microsoft Excel software. Views, configure content for collaboration, configure languageĢ. Navigate and format workbooks, customize workbook options and Specific skills include import data into workbooks, Manage worksheets and workbooks using Microsoft Excel Ĭourse Objectives: Upon successful completion of this course, students will be able to:ġ. Pre-requisite(s): exemption/completion of ENG 001 and MAT 095. (Spring Term Only) Four hours lecture each week. (Formerly offered as OFFC-235 credit will not be awarded for both). Students can complete the Expert exam for an additional fee. The MOS Excel Associate exam is completed as the final exam. This course prepares students to complete the MOS Microsoft Excel Associate and Expert 2019 Certification exams. Manage workbook options and settings apply custom data formats and layouts.

Apply skills to create and manage worksheets, workbooks, cells, ranges, charts, objects, and Excel tables, and perform operations with formulas and functions. Tweet this Page (opens a new window) Add to Personal Bookmarks (opens a new window)ĭevelop and manipulate electronic worksheets and charts while using the Microsoft Excel software package.

Excel associate exam