Course Code:10.01
Course Subject:Excel Introduction
Course Title:Excel 2003 Introduction
Aims:Create, enter data into and format Excel Spreadsheets.
Introduction:Excel spreadsheets are incredibly powerful tools that provide the user with a range of features to store and analyse data. The ability to save and return to spreadsheets makes data handling easy and reliable. This course introduces the key skills required to create and edit spreadsheet files as well as enter and format data..
  

Objectives

The learner will be able to:

Assessment Criteria

The learner has achieved this objective because he/she can:

1. Understand the Excel Environment and Specification

  1. Appreciate the variety of uses of Excel

  2. Understand the range of file types

  3. Navigate the Excel Environment

  4. Use and configure the Menu and Tool Bars

  5. Use and configure the Office Assistant

2. Create and Edit Workbooks, Worksheets and Cells

  1. Create and Open Workbooks

  2. Edit and work with Workbooks

  3. Edit and work with Worksheets

  4. Edit and work with Cells

  5. Navigate within a Worksheet

  6. Navigate a Workbook

3. Enter Data correctly and efficiently

  1. Enter Data

  2. Use Time Saving Features

  3. Check Spelling

4. Format and Customise Data

  1. Select Items in Excel

  2. Format Text

  3. Format Numbers

  4. Manipulate Data

  5. Format Columns and Rows

  6. Format with Colours and Patterns

  7. Add and Edit Borders

  8. Use AutoFormat

5. Edit Spreadsheets

  1. Cut, Copy and Paste

  2. Insert and Delete

  3. Use Find and Replace

  4. Use Undo and Redo

6. Use Formulas and Functions

  1. Enter Formulas

  2. Enter Functions

  3. Use Named Cells and Ranges in Formulas

7. Print

  1. Use Print Setup

  2. Set Margins

  3. Set Headers and Footers

  4. Print a Spreadsheets