Getting
Started
Concepts
Screen Layout
Move Around Cells
Editing
Spreadsheet
Enter/Edit
Selection Techniques
Cut/Copy/Paste
Undo/Redo
Fill by Example
Basic
Formulae
Enter/Edit Formulae
Arithmetic Operators
Autosum
Presentation
Number Display
Font Type/Size
Align Data
Patterns/Colours
Adjust Col/Row
Borders
File
Procedures
Save/Save As
Open/Close
Printing
Print Preview
Define Print Area
Printing Worksheet
Page
Setup
Orientation/Scaling
Centring Horiz/Vert
Headers/Footers
Sheet Options
|
Managing
Formulae
Order of Precedence
Relative v. Absolute
Formula to Valve
Functions
Min/Max
Average/Count
Sum
IF
Comparison Operators
Range
Names
Create & Define
Going to a Range
Printing a Range
Use in Basic Formula
Spreadsheet
Efficiency
Cell Notes
Sorting
Page Breaks
Freeze Titles
Control Large Sheets
Charts
Create
Chart Types
Autoformat
Re-size/Move
Legends & Titles
Basic
Filtering
Autofilter
Select Filter
Sort
Remove Filter
|
