ON LINE TRAINING ON MICROSOFT EXCEL

Electronic Spreadsheet

Workbook, Worksheet and Tabs

Columns,Rows and Cell

Finding Location

Moving around on the Spreadsheet

Scrolling on the Spreadsheet and Changing Pages

Using the Goto Command

Selecting Cells

Entering Text and Numbers

Editing Data in a Cell

Formulas and Entering Formulas

The Sum Function

The Average Function

Specifying Decimal Places

Designing Sporeadsheet

Designing tips

Help Button

Toolbars

Inserting Dates and Times

Displayinig Dollar, Commas and Percent Signs

Changing Font Size and Text Alignment

Inserting and Removing Page Breaks

Column Width and Row Height

Autoformating document and turning off Grindlines

Adding Headers and Footers

Defining the Print Area and Using Print Preview

Printing and Saving a Worksheet

Statistical Data Analysis

Charts and the Chart Wizard

Keyboard Shortcuts