Navigation
ss

Spreadsheets

Lesson 1
Open New Workbook
Open Existing Wbk
Tour of Workspace
Change Font Colour
Background Fill
Change Font Weight
Save vs Save As...
Close Workbook
Close Excel

Lesson 2
Auto Fill
Format Painter
Col Width/Row Height
Undo
Gridlines
Print Preview
Copy/Paste
Background Fill
Format Paint: Multiple
Table Properties

Lesson 3
Text Orientation
Format Painter
Undo
Background Fill
Copy/Paste
Cell Selection
Insert Row
Centre across Cols
Save as Web page

Lesson 4
SUM Formula
Relative Referencing
AVERAGE Forumla
Error Msg: #NAME
Arithmetic Operators
Percentage Format
Absolute Referencing
Error Msg: #VALUE

Lesson 5
Date Format
Currency Format
Arithmetic Operators
Error Msg: ####
Absolute Referencing
Sorting Data

Lesson 6
Insert Image
Resize Image
Move Cells
Format as Currency
Formulas: Arithmetic
Order of Precedence
Different Worksheets
Copy/Paste Worksheets
Ref Cells on Diff Worksheets

Lesson 7
Modify Toolbars
Font Colour, Bold
Zoom
Delete Row(s)
Clear Cell Contents
Undo
Search
Replace
Spell Check

Lesson 8
Insert WordArt
Move WordArt
Insert Word Doc
Format as Currency
Save as Template
Use Template
Decimal Places

Lesson 9
Help Menu
Help on the Web
Help: What's This?
Help: Index Search
Help: Answer Wizard
Help: Contents
Open Multiple Workbks
Move between Workbks

Lesson 10
Simple Charts
Cut/Paste Charts
Customise Charts
Place Chart on Worksheet
Move/Resize Chart
Chart Types
Change Worksheet Order
Modify Charts

Lesson 11
Print: Page Orientation
Print: Scaling
Print: Paper Size
Print: Margins
Print: Headers & Footers
Printer Settings
Print to File
Print Selected Cells
Copy / Paste between Wobooks

Comments/Problems: Webmaster@chalksoft.com
Copyright © 1998-2003, Chalksoft Ltd. All rights reserved.