Excel 2007 Basic

Course Outline

Excel Basics:

Spreadsheet Terminology

Exploring the Excel Window

Opening and Navigating a Workbook

Closing a Document 

Entering and Editing Data:

Creating a new Excel Workbook

Entering and Editing labels and values

Entering and Editing formulas

Saving and updating a workbook

Modifying a worksheet

          Moving and copying data

          Moving and copying formulas

          Using absolute references

          Inserting and deleting ranges

Using Functions:

Entering Functions

Using AutoSum

Using Average, Minimum, and Maximum

Formatting Worksheets:

Formatting Text

Formatting rows and columns

Number Formatting

Other Formatting Features

Printing Worksheets:

          Previewing a worksheet

          Page Setup options

          Printing

Creating Charts:

          Creating a Chart

          Modifying charts

          Printing charts

Web Features:

          Saving a worksheet as a web page

          Adding Hyperlinks

          Workbooks & Email

Excel 2007 Basic Course Details

Lecture Hours/Week:  6 hours – One Day Workshop

Lab Hrs/Week:

Contact Hours:  6

Course Description:  Create, analyze and share important data quickly with MS Excel, the Office spreadsheet program. Discover spreadsheet uses and terminology as well as how to make the worksheet work for you.

Course Competencies:  Upon successful completion of this course, the student should be competent to perform the following tasks:

·         Start Microsoft Excel: identify the main components of the Excel window and an Excel workbook; use the Help feature; and navigate worksheets

·         Enter and edit text, values, and formulas: insert pictures in a worksheet; use AutoFill; and save and update a workbook.

·         Move and copy data; insert and delete ranges; and work with relative and absolute references when creating and copying formulas.

·         Use the SUM function, the AutoSum button, and the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to perform calculations in a worksheet.

·         Format text, numbers, row, and columns in a worksheet; check spelling; find and replace data; print a worksheet; and set and clear a print area.

·         Create, format, modify, and print charts based on worksheet data.

·         Manage large worksheets and multiple worksheets.

Course Requirements: 

Attendance Requirements:  80%

Evaluation Strategies/Grading:  Students evaluated by Instructor at completion of class

Entry-Level Skills:  Basic Computer Literacy

Prerequisites:

Co-Prerequisites:

Book/Instructional Material Requirements:  Excel Basic 2007 Workbook

Method of Instruction:  Instructor Led; Hands-on environment