Microsoft Excel 2002 (XP) - Core

Overview

Learn to manage, create and edit Microsoft Excel spreadsheets.

Target Audience

This course is aimed at users who have little or no experience using Microsoft Excel 2002 (XP), users who have used other spreadsheet applications (like Lotus 123) and wish to convert to Excel or users who have used previous versions of Excel and wish to brush up on the differences in this version.

Prerequisites

It is essential that course participants have successfully completed a Windows Introductory course, or have gained a similar level of knowledge within the work environment. Specifically participants need to be fully conversant in:

  • Basic Keyboarding (Shift, Caps Lock, Ctrl etc).
  • Basic Windows Operating System Navigation.
  • Mouse Skills.

Objectives

Upon completion users will be able to:

  • Apply core skills in creating and managing simple workbooks.
  • Understand and utilise the key components of Excel to increase productivity.
  • Create and print professional workbooks using Excel’s page setup commands.
  • Produce effective spreadsheets through the utilisation of simple formulas.

Duration

1 day.

Course Content

Basic Workbook Features

  • Exploring Excel
  • Manipulating Toolbars and Menus
  • Creating and Opening Spreadsheets
  • Saving and Closing Files
  • Using Task Panes and Smart Tags
  • Working with Ranges
  • Key Data Entry Features
  • Entering and Editing Data
  • Working with Sheets, Columns and Rows
  • Help and ‘Ask a Question’

Simple Formulas

  • Creating and Editing Simple Formula
  • Using Automated Calculation Tools
  • Relative and Absolute Cell Referencing
  • Finding and Fixing Errors

Manipulating Data

  • Cut, Copy, Paste and the Office Clipboard
  • Moving and Copying between Worksheets
  • Undo and Redo

Formatting

  • Using Text and Number Styles
  • Formatting Columns and Rows
  • Applying Borders and Shading
  • Format Painter
  • Using AutoFormat

Customising Display

  • Zoom
  • Splitting and Freezing

Printing and Page Setup

  • Inserting and Removing Page Breaks
  • Headers and Footers
  • Margins
  • Print Options

Back



 
 
 

Download

Download this profile here.
 

What's Next?

Learn to use more advanced formulas (IF, AND, OR) as well as creating Charts and Spreadsheet Templates.
Microsoft Excel 2002 (XP) Proficient
 

Also Available

Microsoft Excel 2002 (XP) Expert
Microsoft Excel 2002 (XP) VBA