giving people the skills to succeed  
search our website
Courses > IT Courses > What's New in Microsoft Excel 2007
 
   
 
What's New in Microsoft Excel 2007
 
Target Audience:  

Current users of a previous version of Microsoft Excel who are upgrading to Microsoft Office 2007.

 
   
Objectives:  

By the end of the course users will be familiar with the layout of Excel 2007 and be able to use new and improved features to create, format and analyse data in a spreadsheet.

 
   
Prerequisites:  

Users should have a sound working knowledge of a previous version of Microsoft Excel and be able to perform commands such as calculating data using functions, sorting, filtering and formatting data.

 
   
 
       
     
  Duration: Half Day
  Cost: £125 + VAT
     
 
  Course Date Location
     
Demand led
Call to request dates
     
     
         

Microsoft Excel 2007

  • The Excel Screen & Views

  • Creating New Workbooks

  • Formatting Spreadsheets using Themes

  • Working with Conditional Formatting:

  • Using Data Visualisations

  • New Formatting Rules

  • Working with the Rules Manager

 

Sorting & Filtering

  • Sorting by Single or Multiple Columns

  • Identifying & Creating Custom Filters

  • Filter By Colour

  • Removing Duplicate Entries

 
 
   

Formulae, Functions & Naming

  • Working with Formula

  • AutoComplete

  • Working with Functions

  • Naming Ranges

  • Working with the Range Manager

 

What's New with Charts & Pivots

  • Creating & Modifying Simple Charts

  • Building a PivotTable

 

Headers, Footers & Page Layout

  • Headers & Footers

  • Page Layout View & Print Preview