Microsoft Excel 2000: Introduction for Beginners (1 day) UK Classes & Lessons (Microsoft)

About this class

By the end of this course you will be able to produce a formatted worksheet, confidently create basic dynamic formulae and create a visual representation of there data, using the provided manual if required.

Who will the lesson benefit?

Users who are new to spreadsheets.

What prerequisites are required

None.

Contents of this class

Excel Basics

Spreadsheet Terminology
Exploring The Excel Window
Opening And Navigating A Workbook
Closing A Workbook

Entering And Editing Data

Creating A New Excel Workbook
Entering And Editing Labels And Values
Entering And Editing Formulas
Saving And Updating A Workbook

Printing

Preparing To Print
Page Set up Options

Modifying A Worksheet

Moving A Copying Data
Moving And Copying Formulas
Using Absolute References
Inserting And Deleting Ranges Using Functions

Entering Functions
Using Autosum
Using AVERAGE, MIN, MAX, And COUNT

Formatting Worksheets

Formatting Text
Formatting Rows And Columns
Number Formatting
Other Formatting Features Creating Charts
Creating A Chart
Printing Charts

Web Features

Saving A Worksheet As A Web Page
Adding Hyperlinks
Sending A Workbook Via Email