Call: 0118 3243000
Systematix Training Ltd

Excel 2002 Introduction

Course Overview

Students will create, edit, format and print basic worksheets and charts in Excel.

Prerequisites

Windows Introduction, or equivalent knowledge.

Benefits

Students will learn how to use an electronic spreadsheet to create basic worksheets and charts.

Target student

A user who has worked with personal computers and used Windows to manage information, run programs, and access the Web.

We offer a range of Excel training courses

Getting Started
  • Enter Data in a Worksheet
  • Edit Data
  • Change Text Appearance
  • Save a Workbook
  • Obtain Help
  • Editing Your Worksheet
Editing Your Worksheet
  • Move Data to Other Cells
  • Copy Data to Other Cells
  • Fill Cells with a Series of Data
  • Insert and Delete Rows and Columns
  • Undo and Redo an Entry
  • Find and Replace Numbers
  • Enter Data in a Range
  • Verify Data in a Range
Performing Calculations
  • Sum a Range of Data
  • Use a Built-in Function
  • Copy a Formula
  • Create an Absolute Reference
Formatting
  • Specify Numeric Format
  • Create a Custom Numeric Format
  • Change Font Size and Type
  • Create and Apply Styles
  • Add Borders to Cells
  • Find and Replace Formats
  • Change Column Width and Row Height
  • Shrink Text to Fit
  • Align Cell Contents
  • Merge and Split Cells
  • Apply an AutoFormat
Working with Multiple Worksheets
  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Copy Worksheets
  • Change the Number of Worksheets
Setting Page Display and Printing Options
  • Freeze and Unfreeze Rows and Columns
  • Set Print Titles
  • Set Page Margins
  • Create a Header and Footer
  • Change Page Orientation
  • Insert and Remove a Page Break
  • Print a Range
 
Publisher: Microsoft
Version: 2002 (XP)
Length: 1 day
Course-ID: 084200

Printer Friendly Version
Download Outline As PDF
Request A Quote Ask Us A Question

Each of us returned extremely positive and motivated - the arrangements, as usual, ran like clockwork - we certainly felt the course was of benefit

- Local Charity

Microsoft Registered Partner
BSI ISO 9000