Course Abstract Details

OFFC-135, Introduction to Excel

Credits: 3

Course Description

OFFC-135, Introduction to Excel, develops students' ability to create and enhance electronic worksheets and charts while using the Microsoft Excel software package. Students learn and apply skills to create and edit worksheets, chart and analyze data using various chart types and what-if analysis tools, use intermediate functions and formulas, manage large workbooks, and use advanced sorting and filtering methods for evaluating data. It is suggested that students possess basic technology skills to be successful in this course. Upon successful completion of this course students will be prepared to complete the MS Excel 2010 Certification Exam. Prerequisite: exemption/completion of READ-091 and MAT-097. 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 worksheets and chart data using Microsoft Excel software. Specific skills include: create, save, enter data, format cells, chart data, create sparklines, check spelling, construct basic formulas, use relative and absolute cell references, and print, display and hide formulas in Excel workbooks. (General Education Goal #4, Program Goal # 5)

2.Use functions, create tables, and manage large workbooks using Microsoft Excel software. Specific skills include: use basic, statistical, Count, date and time, Now, and If functions, resolve error messages, freeze panes, create, sort and filter tables, clear formatting, use paste options, and group, rename, and print multiple worksheets. (General Education Goal #4, Program Goal #5)

3.Analyze data using charts and what-if analysis tools using Microsoft Excel software. Specific skills include: create, edit, manage, and understand charts. (General Education Goal #4, Program Goal #5)

4.Use financial and lookup functions, define names, and validate data using Microsoft Excel software. Specific skills include: insert payment and lookup functions, use goal seek, use and design data tables, define named ranges, and create validation lists. (General Education Goal #4, Program Goal #5)

5.Manage large workbooks and use advanced sorting and filtering in Microsoft Excel software. Specific skills include: navigate and manage large worksheets, enhance with themes and styles, format worksheets to share with others, save data in CSV, PDF and XPS files, sort multiple columns, and use custom and advanced filters. (General Education Goal #4, Program Goal #5)

6.Create charts, diagrams, and templates using Microsoft Excel software. Specific skills include: create and format sparklines and other charts, enhance with graphics, create and modify organization charts, create and edit templates, and protect worksheets. (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