Table of Contents

  1. Design, Create and Use Spreadsheets
    1. Design Spreadsheets
    2. Practise Spreadsheet
    3. Your Spreadsheet
    4. Insert Rows and Colulmns
    5. Delete Rows and Columns
  2. Formatting
    1. Task 1
    2. Formatted Worksheet
    3. Other Formatting Buttons
    4. The Borders Button
    5. Currency
  3. Calculations
    1. Basic Operators
    2. BODMAS
    3. Functions
    4. Using the Equals Sign
    5. Other Functions
  4. Edit Formula
    1. Edit Formula 2
    2. Edit Formula 3
    3. Copy Functions and Formulas
    4. Task 2
    5. Formula View
    6. Count Functions
  5. Format Cells
    1. Alignment Format
    2. Vertical Alignment
    3. Format Font
    4. Format Borders
    5. Format Patterns
  6. Logical Functions
    1. The IF Function
    2. Relative Cell Referencing
  7. Named Cells
    1. How to Name Cells
    2. Navigate Using Named Cells
  8. Comments
    1. Creating a Comment
    2. Editing a Comment
    3. Delete Comments
    4. Print Comments
  9. Security in Spreadsheets
    1. Protecting a Workbook File
    2. Protect a Worksheet
    3. Protect Part of a Worksheet
  10. Page Setup and Printing
    1. The Margins Tab
    2. Header and Footer
    3. The Sheet Tab
    4. Print Preview
    5. Print Dialog