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 182

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 advanced level Excel course.  Students should have a working knowledge of basic and intermediate Excel features or have passed the Microsoft Office Specialist certification exam at the Core level.

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 2007

·        Use the Undo button to undo multiple changes

·        Use passwords to assign protected and unprotected status to a workbook

·        Use the macro recorder to create a macro

·        Execute a macro

·        Understand Visual Basic for Applications code

·        Customize a toolbar by adding a button

·        Customize a menu by adding a command

·        Add controls to a worksheet, such as command buttons, scroll bars, check boxes, and spin buttons

·        Assign properties to controls

·        Use VBA to write a procedure to automate data entry into a worksheet

·        Understand Do-While and If-Then-Else statements

·        Test and validate incoming data

·        Explain even-drive programs

·        Use the Formula Auditing toolbar to analyze a worksheet

·        Trace precedents and dependents

·        Add data validation rules to cells

·        Use trial and error to solve a problem on a worksheet

·        Use goal seeking to solve a problem

·        Use Excel’s Solver to solve a complex problem

·        Password-protect a workbook file

·        Use Excel’s Scenario Manager to record and save different sets of what-if assumptions and the corresponding results

·        Create a Scenario Summary of scenarios

·        Create a Scenario Pivot Table

·        Set and change the properties of a workbook

·        Import data from a text file

·        Import data from an Access database

·        Import data from a Web page

·        Import data from spreadsheet XML

·        Replicate formulas

·        Insert, edit, and remove a comment

·        Explain collaboration techniques

·        Track changes and share a workbook

·        Route a workbook to other users

·        Accept and reject tracked changes made to a workbook

·        Create and format a Pivot Chart and Pivot Table

·        Analyze worksheet data using a Pivot Chart

·        Analyze worksheet data using a Pivot Table

·        Analyze worksheet data using a trend line

·        Merge shared workbooks

·        Add a trend line to a chart

• Explain the concept of exporting data from a workbook