Course Abstract Details

OFFC-235, Advanced Excel

Credits: 3

Course Description

OFFC-235, Advanced Excel, allows students to apply advanced skills to electronic worksheets and charts while using the Microsoft Excel software package. Students manage and share workbooks, apply custom formats and layouts, create advanced formulas, and create advanced charts and tables. Upon successful completion of this course students will be prepared to complete the Microsoft Excel 2013 Expert Certification Exam. It is suggested
that students possess basic technology skills to be successful in this course. Prerequisite:
exemption/completion of OFFC-135. Three lecture hours each week. Three credits. Three billable hours.

Course Objectives and Grading Information

COURSE OBJECTIVES:
1. Manage and share worksheets and workbooks using Microsoft Excel software. Specific skills 83 include: manage multiple workbooks, prepare workbooks for review, manage workbook changes, and share workbooks using Web tools. (General Education Goal 4,
Program Goal 4)
2. Apply custom formats and layouts using Microsoft Excel software. Specific skills include: apply custom data formats, apply advanced conditional formatting and filtering, apply custom styles and templates, and prepare a workbook for internationalization and accessibility. (General Education Goal 4, Program Goal 4)
3. Create advanced formulas using Microsoft Excel software. Specific skills include: use logical, nested, look up, advanced time and date functions and formulas, and create data scenarios. (General Education Goal 2, 4, Program Goal 4)
4. Create advance charts and tables using Microsoft Excel software. Specific skills include: apply trendlines, dual axis, chart templates, and animations to charts. Create and manage PivotTables and PivotCharts. (General Education Goal 4, Program Goal 4)
5. Automate workbooks using Microsoft Excel software. Specific
skills include: record and write VBA macros. (General Education
Goal 4, Program Goal 4)


Learning Goals

The abbreviations in parentheses represent Learning Goals which have been identified for this course and program of study:

Bookmark, Share, or Email this page Get Help