Excel 2007 Intermediate

Date Location Price / Members Price Places Trainer Book Online or Enquire


This course will introduce new and existing users of Microsoft Excel to the basic but fundamental features of Spreadsheets and their use. Delegates are guided through its use from setting up a simple spreadsheet with values, labels and formulae to displaying information in graphical format.



The course will also be of great benefit to those who have been using Excel for some time but who feel that they are not making best use of its  facilities. The course will undoubtedly introduce these users to many shortcuts which they may not have discovered for themselves.


Who Should Attend

  • New, recent or intended users of Excel who want to gain a good overview of the product in a short space of time
  • Existing users of Excel who feel that they are not making best use of its facilities
  • Users who are converting from another Spreadsheet package to Excel or upgrading



  • Using multiple worksheets and workbooks
  • Using multiple workbooks
  • Linking worksheets with 3-D formulas
  • Linking workbooks
  • Managing workbooks


Advanced Formatting

  • Using special number formats
  • Using functions to format text
  • Working with styles
  • Working with themes
  • Other advanced formatting


Outlining and subtotals

  • Outlining and consolidating data
  • Creating subtotals


Cell and range names

  • Creating and using names
  • Managing names
  • Lists and tables Saving workbooks as Web pages
  • Using hyperlinks
  • Distributing workbooks


Advanced charting

  • Chart formatting options
  • Combination charts
  • Graphic elements
  • Documenting and auditing
  • Auditing features
  • Comments in cells and workbooks



  • Workgroup collaboration
  • Templates and settings
  • Application settings
  • Built-in templates
  • Creating and managing templates



  • A working knowledge of PCs and a mouse is assumed.
  • It is also recommended that proposed delegates have attended a Windows 2000 or Windows 2002 course or have obtained comparable knowledge from the workplace.