•  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
    		•
         
         
         
    What is Excel.............
    Multiple Work Sheets
         Renaming a Worksheet
         Inserting and Deleting Worksheets
         Moving and Copying Worksheets
         Grouped Worksheets
         Creating a Link between Excel Spreadsheets
         Pasting Links between other Applications
         Creating a Link in Word
         Breaking a Link
    Inserting Objects
    Further Functions
        Conditional Functions
        Date and Time Functions
        Mathematical Functions
        Rounding
         Long Division Calculations
    Find and Replace
    Absolute and Relative Cell References
         What is meant by Absolute and Relative Addressing?
         Entering Absolute References
         Using Absolute Addressing
    Spreadsheet Security
         Password Protecting a Spreadsheet
         Protecting a Workbook
         Protecting a Worksheet
         Protecting Cells
         Unprotecting a Workbook or Worksheet
    Copying and Moving
         Cut and Paste
         Copy and Paste
         Clear
         Paste Special
        

      Paste Special Options
        

      Paste Link

    Comments
         Inserting a Comment
         Viewing Comments
         Editing a Comment
         Deleting a Comment
    Manipulating Data in Excel
         Sorting Information
         Subtotalling Information
         Filtering Records
    Database Facilities in Excel
         Viewing Information
         Adding Records
         Finding Records
         Deleting Records
    Custom Views
         What is a View?
         Creating a Custom View
         Displaying a Custom View
         Deleting a Custom View
    Scenario Manager
         Setting up a Scenario
         Running a Scenario
         Further Scenario Options
    Report Manager
         Creating a Report
         Running a Report