Course Code:70.01
Course Subject:Excel Introduction
Course Title:Excel 2010 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. Introduction to Excel

  1. Understand and use the Ribbon

  2. Use the Title Bar

  3. Use and Manage the Status Bar

  4. Start a New Workbook

  5. Open a recently used Workbook or look in a recently used folder

  6. View Information on the current workbook

  7. Change/View Excel Options

  8. Use the Quick Access Toolbar

2. Create and Edit Workbooks, Worksheets and Cells

  1. Edit and Work with Workbooks

  2. Edit and Work with Worksheets

  3. Edit and Work with Cells

  4. Navigate within a Worksheet

  5. 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. Format Columns and Rows

  5. Format with Colours and Patterns

  6. Add and Edit Borders

5. Edit Spreadsheets

  1. Cut, Copy, Paste, Move and Paste Special

  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. Control the Sheet layout

  5. Print and Preview Spreadsheets

8. Understand the uses of and variety of file types

  1. Appreciate the variety of uses of Excel

  2. Understand the range of file types