Microsoft Excel 2007 training | Excel 2007 Upgrade (1 day)

Rather than spend a month finding out gradually about all the features and foibles of this major upgrade, why not do it all in a day? Learn how lists have metamorphosed into tables, what structured references are, how the new page layout view can help you, what new conditional formatting features there are, how charts have evolve and much more!

Excel 2007 Upgrade training - Course Contents

The contents of our Excel 2007 Upgrade course are as follows (any items marked with a * will be covered if time allows). If you aren't sure if this is the right course for you, please either click on one of the content headings below and try some exercises or call or email us to talk through your options. We want you to be on the right Microsoft Excel 2007 training course as much as you do!

Office 2007 interface
  • Using the ribbon
  • Customising the quick access toolbar
  • Customising the status bar
  • The zoom bar
File formats
  • The new file formats
  • Compatibility mode
Formatting your work
  • Inserting/deleting rows/columns
  • Changing fonts
  • Colours and borders
  • Merging and aligning cells
Printing
  • Page break preview
  • Using page layout view
  • Headers and footers
  • Freezing print titles
Linking to other data
  • Linking to Access
  • Linking to web sites
Basic tables
  • Table styles
  • Using calculated columns
  • Header rows and total rows
  • Sorting and simple filtering
Advanced Tables
  • Advanced filters
  • Removing duplicates
  • Creating table styles
Structured references
  • The parts of a table
  • Syntax rules
  • Examples of structured references
Pivot tables
  • Creating pivot tables
  • Swapping rows, columns and pages
  • Grouping fields
  • Drill-down
Charts
  • Selecting data
  • Formatting your chart
  • Quick ways to create charts
Styles and themes
  • Using the default styles
  • Creating custom styles
  • How themes work
Conditional formatting
  • Creating/using cell rules
  • Data bars and colour sets

To help see if this is the right course for you, you can see and download examples of our Excel courseware. You can also look at the differences between Microsoft Excel versions and see on which Excel version we currently train.

Excel 2007 Upgrade training - Pre-requisites

This course is aimed at people who already know a previous version of Excel. The more familiar you are with Excel 2000, 2002/XP or 2003, the more you will get out of this course.

Excel 2007 Upgrade training - Schedule and Prices

Prices for this Microsoft Excel 2007 training course are as follows:

There will be a maximum of 6 people on each course, and each person will have their own computer. Please take a moment to see why our Microsoft Excel 2007 training courses are so different, then use our easy-to-use web-based or telephone booking system to book your course place. Alternatively, call (01457) 858877 or email our training co-ordinator.

Onsite Microsoft Excel 2007 training

In addition to our standard scheduled Microsoft training courses, we also offer onsite Microsoft Excel 2007 training. This allows you to create a Microsoft Excel 2007 training course uniquely tailored to the needs of your staff, covering only those aspects of Microsoft Excel 2007 which they need to learn.

Recommended sites: TechTutorials

All content copyright Wise Owl Business Solutions Ltd 2009.  All rights reserved.