yScarborough UK computer training company, database development, internet trainingSoftware Computer Training Word Excel Access PowerPoint Outlook InternetDevelopment of Access databases and visual basic programsDeveloping Microsoft Access DatabasesWindows NT and Windows 2000 by qualified MCSE EngineerInternet installation and training.  Connecting companies to the internet

Excel 2000 - Introduction

Access 2000

 

A First Look at Excel 2000

  • The advantages of Using Excel 2000

  • What are Workbooks and Worksheets?

  • Creating and Opening Workbooks

  • Entering Data

  • Further Data Entry Techniques

  • AutoCorrect

  • AutoComplete

  • Using the Pick List

  • Navigating in the Worksheet

  • Selecting Items Within Excel 2000

  • Inserting and Deleting Cells, Rows and Columns

  • Saving Workbooks

  • Moving Between Worksheets

  • Using the Spelling Checker

  • Closing an Excel 2000 Workbook

  • Exiting Excel 2000

A closer look at the Excel 2000 Screen

  • The Standard Toolbar

  • The Formatting Toolbar

  • Selecting Worksheet Views

  • Undo and Repeat

  • The Office Assistant

Formatting and Customizing Data

  • Formatting Options Within Excel 2000

  • Alignment

  • Data Indentation and Rotation - Introduced With Excel 2000

  • To Center Items in a Cell/Cells

  • Using Fonts

  • Formatting Numbers

  • Decimal Places

  • Formatting Columns and Rows

  • Deleting Cells, Formats, Objects and Worksheets

  • Adding, Editing and Removing Borders

  • Using AutoFormat

  • Copying Data

  • Copying Data Using Drag and Drop

  • Copying Columns and Rows

Formulas, Functions and Named Ranges

  • Formulas

  • Operator Evaluation Order Within Excel 2000

  • Functions

  • Functions (continued)

  • Using the SUM Function

  • Other Commonly Used Functions

  • Using Paste Function

  • Naming Cells and Ranges

  • Using Named Ranges With Formulas

Introducing Charts

  • Creating a Chart

  • Manipulating Charts

  • Changing the Chart Type

Printing

  • Page Setup

  • Margins

  • Centering Printed Output

  • Headers and Footers

  • Sheet Printing Options

  • Choosing a Printer and Changing Settings

  • Printing a Worksheet

  • Printing Multiple Files

 

Excel 2000

Word 2000

PowerPoint 2000

Windows

Miscellaneous

 

Office 97