giving people the skills to succeed  
search our website
Courses > IT Courses > Microsoft Excel 2007 Intermediate
Microsoft Excel 2007 Intermediate
Target Audience:  

Users who already have some experience of using Excel who need to create spreadsheets which include calculations, multiple sheets and charts.


By the end of the course users will be able to create multiple sheet Workbooks, use logical functions, sort, filter and subtotal data.  Users will also be able to present data in a graphical format.


Users need to be able to design and create simple spreadsheets which include basic formulae and the use of AutoSum.  They should also be able to use simple formatting tools and use cut, copy and paste effectively.

  Duration: 1 Day
  Cost: £150 + VAT
  Course Date Location
  08/01/2014 Bradford
  10/01/2014 Liverpool
  12/02/2014 Bradford
  06/02/2014 Liverpool
  07/03/2014 Bradford
  01/04/2014 Bradford
  28/04/2014 Liverpool
  14/05/2014 Bradford
  11/06/2014 Liverpool

More Formulae & Functions

  • Logical 'IF' Functions

  • Using Dates in Calculations

  • Calculating Percentages

  • Naming Cells & Ranges

Working with Multiple Worksheets

  • Moving Between Worksheets

  • Inserting, Deleting & Renaming Worksheets

  • Moving & Copying Worksheets

  • Using Group Editing

  • Entering Formula Across Worksheets


Worksheet Customisation

  • Conditional Formatting

  • Password Protecting a File

  • Protecting Sheets & Cells


Data List Essentials

  • Introducing Data Lists
  • Splitting a Worksheet into Panes
  • Freezing a List of Data
  • Sorting a List of Data        

  • Filtering Data Using AutoFilter

  • Using Automatic Subtotals

  • Working with Excel Tables


Charting Essentials

  • Creating Charts & Graphs

  • Formatting Charts

  • Modifying the Chart Layout

  • Adding & Removing Chart Elements

  • Using Pie Charts

  • Previewing & Printing Charts