Call: 0118 3243000
Systematix Training Ltd

Excel 2000 Introduction

Course Overview

Students will learn basic worksheet skills and how to work with data in worksheets.

Prerequisites

Windows Introduction, or equivalent knowledge.

Benefits

Students will learn how to use an electronic spreadsheet to create basic data reports.

Target student

Studentsshould be comfortable in the Windows environment.

We offer a range of Excel training courses

Excel basics
  • The paper spreadsheet
  • The Excel program
  • The workbook environment
Entering data and navigating in a worksheet
  • Entering and correcting data
  • Saving a file
  • Using formulas
  • Opening a second file
  • Navigation and movement techniques
Modifying a workbook
  • Working with ranges
  • Working with functions
  • Editing cell contents
Moving and copying data
  • Inserting rows and ranges
  • Moving data
  • Copying data
  • Absolute references
  • Using the Fill Series feature
Formatting a worksheet
  • Formatting a worksheet
  • Number formats and text alignment
  • Copying and pasting formats
  • Special and custom formatting
Printing a worksheet
  • Checking spelling
  • Using the Print Preview command
  • Printing a large worksheet
  • Additional print options
Introduction to the workbook environment
  • Using a multiple-sheet workbook
  • Creating a chart
  • Outlining
  • Spreadsheet Solutions
Creating Excel web pages
  • Using Excel as a Web Tool
 
Publisher: Microsoft
Version: 2000
Length: 1 day
Course-ID: 074200

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

I really enjoyed the course, and was pleasantly surprised by how much I learned

- Wentworth Golf Club

Microsoft Registered Partner
BSI ISO 9000