By appointment.

It is best to contact me via the course discussion board or email.  I will respond to email within two working days.  If you use Excel HELP in your subject line, I will give your e-mail top priority.

Prerequisite - OIT 181

Before enrolling in this course, the student should be familiar with basic touch-typing fundamentals and have some experience working in a windows environment with a mouse. You will need access to a computer with Office 2007 and an Internet Browser.

This is an Intermediate level Excel course.  Students should have knowledge of the basic functions of Excel before enrolling in this course.  You should be able to create a spreadsheet with a chart.  You also need to be able to for with formatting functions, formulas, and if statements.

Required on campus sessions:   0

Special labs or practicum:  0

Number of assignments:  Seven assignments which consist of 3-4 problems.

Estimated time per week:  2-3 hours

Group interaction required:  None

Scheduled activities or self paced:  self paced

Requirements: 

Students must have access to the following:

• Equipment:  You will need a computer that is able to access and interact with the Web. For best results, a Pentium or PowerMac with a 56 Kbps or faster modem and 256 MB or more of RAM should be considered the minimal system.
• Software:  You will need one of the following Internet browsers: Microsoft Internet Explorer 6 or higher; Firefox; Mac users may use Safari or Firefox.
• Internet connection: Home users need Internet access through an Internet Service Provider (ISP) that offers a reliable connection to the Internet.

Other requirements: Excel 2003

·        Control the color and thickness of outlines and borders

·        Assign a name to a cell and refer to the cell in a formula by using the assigned name

·        Determine the monthly payment of a loan using the financial function PMT

·        Create a data table to analyze data in a worksheet

·        Add a pointer to a data table

·        Create an amortization schedule

·        Determine a present value of a loan using the PV function

·        Analyze worksheet data by changing values

·        Add a hyperlink to a worksheet element

·        Use names and the Set Print Area command to print sections of a worksheet

·        Set print options

·        Protect and unprotect cells in a worksheet

·        Use the formula checking features of Excel

·        Create a worksheet database

·        Add computational fields to a database

·        Use the VLOOKUP function to look up a value in a table

·        Change the range assigned to a named database

·        Use a data form to display records, add records, delete records, and change field values in a worksheet database

·        Sort a worksheet database on one field or multiple fields

·        Display automatic subtotals

·        Use a data form to find records that meet comparison criteria

·        Filter data to display records that meet comparison criteria

·        Use the advanced filtering features to display records that meet comparison criteria

·        Apply database functions to generate information about a worksheet database

·        Print a database

·        Create and use a template

·        Utilize custom format codes

·        Define, apply, and remove a style

·        Add a worksheet to a workbook

·        Create formulas that use 3-D references

·        Consolidate data within the same workbook

·        Draw a 3-D cylinder chart

·        Use WordArt to create a title

·        Create and modify lines and objects

·        Add comments to cells

·        Add a header or footer to a workbook

·        Change the page margins

·        Insert a page break

·        Use the Find and Replace commands

·        Search for files on disk

·        Create and use a workspace file

·        Consolidate data by linking workbooks

• Link an Excel Worksheet to a Word Document