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 create pivottable and pivotchart reports and audit worksheets, use data analysis, solver, and scenario features, use macros and Visual Basic, import external data from other applications, and prepare a workbook for collaboration and distribution. Prerequisite: exemption/completion of OFFC-135. Three lecture hours each week. Three credits. Three billable hours.

Course Objectives and Grading Information

OBJECTIVES:
Upon successful completion of this course, students will be able to:
1.Create pivottable and pivotchart reports and audit worksheets using Microsoft Excel software. Specific skills include: create and edit pivottable and pivotchart reports, use filters, trace precedents, and error checking tools. (General Education Goal #4, Program Goal # 5)

2.Use the data analysis, solver, and scenario features in Microsoft Excel software. Specific skills include: calculate moving averages, project income and expenses, determine break-even points, use solver, and create scenarios using the scenario manager. (General Education Goal #4, Program Goal #5)

3.Use macros and Visual Basic in Microsoft Excel software. Specific skills include: record, modify, and assign macros, and write VBA procedures to insert, modify, and test Active X controls. (General Education Goal #4, Program Goal #5)

4.Import External data from other applications and create side-by-side tables using Microsoft Excel software. Import information from Access, Web pages, Text and XML files, create query, filter, and sort data, use DAVERAGE, DSUM, DCOUNT, DGET functions, insert and manage side-by-side tables. (General Education Goal #4, Program Goal #5)

5.Collaborate with others and prepare workbooks for distribution using Microsoft Excel software. Specific skills include: modify properties, activate track changes, manage workbook revisions, inspect, encrypt, and mark as workbook as final, and upload a workbook to SkyDrive. (General Education Goal #4, Program Goal #5)

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