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.

 
   
Objectives:  

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.

 
   
Prerequisites:  

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
  12/03/2013 Bradford
  08/04/2013 Liverpool
  17/05/2013 Bradford
  21/06/2013 Liverpool
  19/07/2013 Bradford
  31/07/2013 Liverpool
  27/08/2013 Bradford
  02/09/2013 Liverpool
  01/10/2013 Bradford
     
         

More Formulae & Functions

  • Creating an IF Statement

  • Using Dates in Calculations

  • Calculating Percentages

 

Working with Multiple Worksheets

  • Moving Between Worksheets

  • Inserting, Deleting & Renaming Worksheets

  • Moving & Copying Worksheets

  • Using Group Editing

  • Entering Formula Across Worksheets

 

Worksheet Customisation

  • Naming Cells & Ranges

  • Conditional Formatting

  • Creating a Custom Number Format

  • Password Protecting a File

  • Protecting Sheets and Cells

  • Splitting a Worksheet into Panes

  • Freezing Worksheet Titles

  • Inserting a Page Break

 
   

Charting Essentials

  • Creating Charts & Graphs

  • Formatting Chart Objects

  • Modifying the Chart Layout

  • Adding & Removing Data Labels

  • Using Pie Charts

  • Previewing and Printing Charts

 

Data List Essentials

  • Structuring a Data List

  • Sorting A List of Data        

  • Filtering Data Using AutoFilter

  • Using Automatic Subtotals

  • Working with Excel Tables