Basic Spreadsheeting WebBook

Here is a list of topic links.

• Contents - Select a Topic
• 1 Introduction to Spreadsheeting
• 1.1 What is a Spreadsheet?
• 1.2 A brief History of Spreadsheets
• 1.3 Introduction to Excel
• 1.4 Parts of the Excel screen
• 1.5 Spreadsheet Components
• 1.6 Rows and Columns
• 1.7 Home on the Range
• 1.8 Moving around in Excel
• 2 Basic Spreadsheet Operations
• 2.1 Creating your first spreadsheet
• 2.2 Building a real spreadsheet
• 2.3 Building a formula
• 2.4 Saving your work
• 2.5 Selecting cells
• 2.6 Copying cells
• 2.7 Summing Rows and Columns
• 2.8 Inserting Rows
• 2.9 Adding the Overheads
• 2.10 Relative Vs Absolute Addresses
• 2.11 Formatting your spreadsheet
• 2.12 Format for Currency
• 2.13 Changing Column Widths
• 2.14 Lines and Outlines
• 2.15 Text on the spreadsheet
• 2.16 'What If' calculations
• 3 Spreadsheet Charts
• 3.1 Excel Graphics
• 3.2 The Charting Wizard
• 4 Advanced Spreadsheet Functions
• 4.1 Windows and Titles
• 4.2 Range Names
• 4.3 Protecting Your Investment
• 4.4 Functions - Inbuilt Functions
• 4.5 Summing across Worksheets
• 4.6 Logical functions - If
• 4.7 Nested IF Functions
• 4.8 Compound IF Statements
• 4.9 Logical functions - Lookup
• Sink the Fleet Quiz
• Spreadsheet Exercises
• Spreadsheet Exercises - Solutions
• Congratulations