Course Code:10.03
Course Subject:Excel Advanced
Course Title:Excel 2003 Advanced
Aims:Provide the Excel user with the skills to create and maintain advanced 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.
  

Objectives

The learner will be able to:

Assessment Criteria

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

1. Import Data

  1. Understand the issues related to importing data

  2. Import Text Files

  3. Import Database data using Microsoft Query

  4. Import Data from the World Wide Web

  5. Refresh external data manually and automatically

2. Use Templates and Styles

  1. Work with Templates

  2. Work with Styles

3. Analyse Data

  1. Perform What-if Analysis

  2. Implement Goal Seeking

  3. Use Data Tables

  4. Use the Scenario Manager

  5. Use the Solver

  6. Create and manage Pivot Tables

4. Record and Run Macros

  1. Record Macros

  2. Run Macros

  3. Add Custom Controls

5. Secure and Proof Spreadsheet

  1. Understand the range of Security features

  2. Protect Files

  3. Protect Worksheets

  4. Work with Digital Signatures

  5. Check Spelling

  6. Use Data Validation

  7. Use Text to Speech conversion

  8. Produce documentation

6. Customise Excel

  1. Configure Excel 2003 options

  2. Customise the Excel Environment

  3. Save and Open Workspaces

7. Collaborate and Consolidate

  1. Share Workbooks

  2. Send Workbooks

  3. Consolidate data