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 Term Only) 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 Objectives: 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. (PG1, PG2)
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. (PG1,
PG2)
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 (PG1, PG2)
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. (PG1, PG2, GE2)
5. Manage charts and PivotCharts using Microsoft Excel software.
Specific skills include create, modify, and format charts. Create
and format Pivot Charts. (PG1, PG2)
6. Utilize cloud computing concepts and manipulate cloud
applications to create and share information. (PG1, PG2, PG4)