Course Code:10.02
Course Subject:Excel Intermediate
Course Title:Excel 2003 Intermediate
Aims:Provide the Excel user with the skills to create and maintain sophisticated 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 covers the intermediate level skills associated with Formatting, Formulas, Functions, Databases, Charts, Drawings, Pictures and integrating Excel with other applications..
  

Objectives

The learner will be able to:

Assessment Criteria

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

1. View Worksheets

  1. Customise View Options

  2. Display and Customise Toolbars

  3. Hide Workbooks and Worksheets

  4. Freeze Panes

  5. Split Panes

  6. Group and Ungroup Worksheets

2. Use Formatting Techniques

  1. Use Styles

  2. Apply Conditional Formatting

  3. Use the Format Painter

  4. Use Guidelines

  5. Hide and Display Cells

3. Use Formulas and Functions

  1. Use Series Command

  2. Use the Insert Function Wizard

  3. Explore and Function Categories

  4. Correct Formulas

  5. Use the Formulas Error Checker

  6. Use the Formula Auditing Toolbar

  7. Use the Watch Window

4. Utilise Database and List Management Tools

  1. Understand the nature of spreadsheet databases

  2. Create and edit a spreadsheet database

  3. Sort a Database

  4. Use AutoFilters

  5. Use the Advanced Filter

  6. Work with Filtered Data

  7. Use DataForms

5. Create Charts

  1. Use the Chart Wizard

  2. Use the Chart Toolbar

  3. Work with Charts

  4. Format Charts

6. Work with Drawing and Picture Objects

  1. Use the Drawing Toolbar

  2. Work with AutoShapes

  3. Create Text Boxes

  4. Add Pictures

  5. Layer Objects

  6. Group and Ungroup Objects

7. Use Excel with Other Applications

  1. Convert Files from other Applications

  2. Copy Data from other Applications

  3. Embed and Link Objects

  4. Insert Hyperlinks

  5. Manage Links