|
Getting Started - New, Opening,
Saving and Closing Files; Moving Around a
Workbook; Viewing a Spreadsheet; Working
with Toolbars; Entering Text and Using
Numbers; Using Help; Selecting Cells; Adding
Numbers up with AutoSum; Typing the Sum
Function to Add Numbers Up; Entering Simple
Formulae; Using Undo; Correcting Mistakes;
Editing Formulae.
Editing a Worksheet - Copying and Moving
Data with Drag and Drop; Using More than One
Worksheet; Using AutoFill to Copy Text and
Formulae; Find and Replace; Checking the
Spelling; Symbols and Special Characters;
Sorting.
Functions and References - Using Absolute
Cell References; Finding the Average; Print
Preview and Printing a Worksheet; Printing
Ranges and More than One Copy; Margins; Page
Setup; Creating Headers and Footers.
Formatting Worksheets - Inserting and
Deleting Rows; Resizing Columns and Rows;
Changing the Font and Font Size; Changing
the Number Format; Changing the Alignment;
Changing the Text Colour; Applying Borders;
Rotating Text.
Charts - Creating a Chart; Moving, Resizing
and Deleting Charts; Formatting Charts;
Using the Chart Toolbar; Changing Chart
Options; Printing Charts.
Saving in Other File Formats - Saving a
Spreadsheet as HTML; Creating and Editing
Templates; Importing from and Exporting to
Other Applications; Saving in Other Formats. |
|