CIA 135 - Excel

Number of Credits: 4
Develop and manipulate electronic worksheets and charts while using the Microsoft Excel software package. Apply skills to create and manage worksheets, workbooks, cells, ranges, charts, objects, and Excel tables, and perform operations with formulas and functions. Manage workbook options and settings; apply custom data formats and layouts. This course prepares students to complete the MOS Microsoft Excel Associate and Expert 2019 Certification exams. The MOS Excel Associate exam is completed as the final exam. Certification is not guaranteed. An additional $80 fee is required. Students can complete the Expert exam for an additional fee. Basic technology skills are recommended. (Formerly offered as OFFC-235; credit will not be awarded for both).(Spring)Four hours lecture each week. Four Credits. Four billable hours.

Pre-requisite(s): exemption/completion of ENG 001 plus MAT 094 , MAT 015 , or MATH 113 .

Course Outcomes: Upon successful completion of this course, students will be able to:
1. Manage worksheets and workbooks using Microsoft Excel software. Specific skills include import data into workbooks, navigate and format workbooks, customize workbook options and views, configure content for collaboration, configure language options.
2. Manage cells and ranges using Microsoft Excel software.Specific skills include manipulate data, format cells and ranges, define and reference named ranges, apply conditional formatting and filtering, validate data, and summarize data visually.
3. Manage tables and table data using Microsoft Excel software. Specific skills include create, format, modify, filter and sort data in tables. Create and modify PivotTables.
4. Perform operations with formulas, functions, and macros using Microsoft Excel software. Specific skills include insert references, calculate and transform data, format and modify text, perform logical operations, use lookup data functions, use data and time functions, perform data analysis, troubleshoot formulas,
and create and modify simple macros.
5. Manage charts and PivotCharts using Microsoft Excel software. Specific skills include create, modify, and format charts. Create and format Pivot Charts.
6. Utilize cloud computing concepts and manipulate cloud applications to create and share information.