| |
|
|
Introduction
|
|
|
Explanation of the Worksheet Screen |
|
|
Entering & Editing Data & Values
|
|
|
Creating Formulae
|
|
|
Rapid Data Entry
|
|
|
Open/Close & Save Files
|
|
|
Printing Worksheets
|
|
|
|
|
Modifying
the Worksheet
|
|
|
Inserting Rows & Columns
|
|
|
Aligning Data
|
|
|
Using Cut, Copy & Paste
|
|
|
Changing Row & Column Widths
|
|
|
Formatting Values
|
|
|
|
|
Presentation
|
|
|
Enhancing the Layout & Text
|
|
|
Working in Preview
|
|
|
Headers & Footers
|
|
|
|
|
Cell
Referencing
|
|
|
Relative Cell Reference
|
|
|
Absolute Cell Reference
|
|
|
|
|
Basic
Statistical Functions
|
|
|
|
|
Sorting
Data
|
|
|
|
|
Customising
the Screen
|
|
|
|
|
|
|
|
|
|
Simple
Graphics
|
|
|
Creating Charts
|
|
|
Enhancing Charts
|
|
|
Printing Charts
|
|
|
|
|
Worksheets
|
|
|
Adding & Removing Worksheets
|
|
|
Working with Multiple Worksheets
|
|
|
|
|
Functions
|
|
|
Using Paste Function
|
|
|
More Statistical Functions
|
|
|
Conditional Functions
|
|
|
Calendar Functions
|
|
|
|
|
Presentation
|
|
|
Adding Borders & Shading
|
|
|
Formatting Data
|
|
|
Autoformats
|
|
|
|
|
Data
Management
|
|
|
Setting up Lists
|
|
|
Sorting Data
|
|
|
Using Filters
|
|
|
|
|
Additional
Features
|
|
|
Autocorrect & Spellchecker
|
|
|
Find & Replace
|
|
|
Paste Special
|
|
|
Adding Comments
|
|
|
Range Names
|
|
|
|
|
|
|
|
|
|
Databases
|
|
|
Sorting Data
|
|
|
Creating Queries
|
|
|
Using Database Functions
|
|
|
|
|
Functions
|
|
|
Using the Function Wizard
|
|
|
Statistical Functions
|
|
|
Logical Functions
|
|
|
Calendar Functions
|
|
|
Financial Functions
|
|
|
|
|
Worksheets
|
|
|
Working with Multiple Worksheets
|
|
|
Linking Files
|
|
|
|
|
Macros
|
|
|
Creating Macros
|
|
|
Running Macros
|
|
|
Editing Macros
|
|
|
Creating Macro Buttons
|
|
|
|
|
Lookup
Tables
|
|
|
|
|
Pivot
Tables
|
|
|
|
|
Presentation
& Protections
|
|
|
Print Borders
|
|
|
Split Windows
|
|
|
Protecting & Hiding Data
|
|
|
|
|
What-If
Analysis
|
|
|
Goal-Seeker
|
|
|
Solver
|
|
|
1 & 2 way "What If" Tables
|
|
|
|
