Advanced Spreadsheeting WebBook.

Here is a list of topic links.

• Advanced Spreadsheeting - Introduction
• 1 Advanced Operations
• 1.1 Windows and Titles
• 1.2 Range Names
• 1.3 Protecting Your Investment
• 1.4 Turning on Protection
• 1.5 Functions
• 1.6 Summing Multiple Sheets
• 1.7 Logical functions - If
• 1.8 Nested IF Functions
• 1.9 Compound IF Statements
• 1.10 Logical functions - Lookup
• 1.10 Operation Firestorm
• 2 Spreadsheet Design
• 2.1 Spreadsheets by Design
• 2.2 Spreadsheets as a Program
• 2.3 Computers Make Mistakes
• 2.4 Skeleton Templates
• 3 Using Excel as a Database
• 3.1 Introduction to Databases
• 3.2 Creating a Database
• 3.3 Sorting the Database
• 3.4 Using a Data Form
• 3.5 Querying Records
• 3.6 Autofiltering records
• 3.7 Moving around a Database
• 3.8 Creating a Criteria Range
• 3.9 Creating Data Subsets
• 3.10 Pivot tables
• 4 Visual Basic Macros
• 4.1 Working with Macros
• 4.2 Creating a simple Macro
• 4.3 The Macro Sheet
• 4.4 Visual Basic For Applications
• 4.5 Learning VBA
• 4.6 Assigning Macros to Buttons
• 4.7 Labeling Buttons
• 4.8 Adding a Scroll Bar
• 4.9 Come in Spinner !
• 4.10 List Boxes
• 4.11 Message Boxes
• 4.12 Pressing Buttons
• 4.13 Add a List Box to a Form
• 4.14 Run a User Form Macro
• 4.15 A La Carte Menus
• 4.16 Cleaning up Your Act
• 4.17 AutoStart Your Application
• 4.18 Adding Comments
• Spreadsheet Exercises
• Spreadsheet Solutions
• Multiple Choice Quiz
• The Major Assignment
• Congratulations !