Microsoft Excel  

Beginner:: This course is designed for people who work with numbers and calculations such as budgets, sales etc. It assumes that you have very little knowledge about spreadsheets and wish to learn the basic operations involved in order to use and set up spreadsheets.

Course Content Available Dates
  • Introduction


  • Copying and pasting data and formulas


  • Basic concepts and spreadsheet terminology


  • Absolute and relative references


  • Entering text and numerical data


  • Different number formats


  • Editing data


  • Deleting and adding columns and rows


  • Simple calculations


  • Formatting data for easy presentation


  • Using simple functions (sum, average)


  • Printing using simple options
  • September 12th 2006
  • October 10th 2006
  • November 14th 2006
  • December 12th 2006
  • January 9th 2007
  • February 13th 2007
  • March 13th 2007
  • April 10th 2007
  • May 15th 2007
  • June 12th 2007
  • July 10th 2007

  • For Bookings and Enquiries Tel:0115 978 4513
    • enquiries@accordia.org.uk

  • Duration: 1 Day

Intermediate: This course is designed for people who work with numbers and calculations such as budgets, sales etc. It assumes that you have some basic experience of EXCEL packages, or that you are converting from other spreadsheet packages, or that you may have completed HSL Excel Beginner Course. The course will expand your knowledge and enhance your ability to work with spreadsheets.

Course Content Available Dates
  • Planning & designing a spreadsheet


  • Creating formulas and using functions


  • Editing, cutting, copying, pasting, paste special


  • Split screen


  • Naming cells and cell ranges


  • Creating charts


  • Formatting numbers and text


  • Protection and security


  • Formatting tables to enhance appearance


  • Printing using customized options


  • September 13th 2006
  • October 11th 2006
  • November 15th 2006
  • December 13th 2006
  • January 10th 2007
  • February 14th 2007
  • March 14th 2007
  • April 11th 2007
  • May 16th 2007
  • June 13th 2007
  • July 11th 2007

  • For Bookings and Enquiries Tel:0115 978 4513
    • enquiries@accordia.org.uk

  • Duration: 1 Day

Advance: This course is designed for people who work with numbers and calculations such as budgets, sales, etc., and have a good knowledge of using spreadsheets but wish to maximise the benefits of Excel.

Course Content Available Dates
  • Plan Spreadsheet
     
  • Enter Data
     
  • Creating Charts and Tables
     
  • Entitle Chart
     
  • Sorting records
     
  • Subtotals
     
  • Pivot tables
     
  • Running a macro
     
  • Protection of workbooks
     
  • Construct Worksheet
     
  • Enter Formula
     
  • Entitle Worksheet
     
  • Create a Macro
     
  • Filter and advanced filter
     
  • Scenarios
     
  • Recording a macro
     
  • Assigning macros
  • September 14th 2006
  • October 12th 2006
  • November 16th 2006
  • December 14th 2006
  • January 11th 2007
  • February 15th 2007
  • March 15th 2007
  • April 12th 2007
  • May 17th 2007
  • June 14th 2007
  • July 12th 2007

  • For Bookings and Enquiries Tel:0115 978 4513
    • enquiries@accordia.org.uk

  • Duration: 1 Day