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
  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