Microsoft Excel 2007 training | Advanced Excel 2007 (2 days)

This course is for Microsoft Excel 2007 - we also run an equivalent Advanced Excel 2003 training course for versions up to 2003.

If you have been using Microsoft Excel for a while now, maybe it is time to move on a bit. This two-day course shows how you can use Excel to manage a database, create advanced charts, use some of the advanced functions in Excel and much more besides! Why not spend two days finding out just what Excel can do?

Advanced Excel 2007 training - Course Contents

The contents of our Advanced Excel 2007 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!

Number formatting
  • The four parts of a format
  • Creating custom formats
  • Scaling numbers
Dates and times (*)
  • How dates and times are stored
  • Useful date/time functions
  • Formatting dates and times
Conditional formatting
  • Creating/using cell rules
  • Data bars and colour sets
Styles and themes (*)
  • Using the default styles
  • Creating custom styles
  • How themes work
Validation and protection
  • Setting cell validation
  • Protecting cells/worksheets
  • Cell comments
  • Grouping and outlining
Range names and absolute references
  • Absolute references ($ symbol)
  • Fixing only the row/column
  • Creating range names
  • Labelling ranges automatically
Multiple worksheets
  • Copying, moving and renaming
  • The dangerous group mode
  • Summing across worksheets
  • 3-D range names
IF and LOOKUP functions
  • The conditional (IF) function
  • Nested IFs are evil
  • Lookup tables
Advanced lookup functions (*)
  • Using MATCH to find values
  • Combining MATCH and INDEX
  • Using OFFSET
  • The feared INDIRECT function
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
Advanced charts
  • Combination charts
  • Picture charts
  • Custom chart types
  • Regression and trendlines
  • Creating chart templates
Consolidation (*)
  • Using formulae
  • Using arrays
  • Using data consolidation
  • Using pivot tables
Recording Macros
  • Absolute/relative recording
  • Where macros are stored
  • Assigning macros to buttons

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

Advanced Excel 2007 training - Pre-requisites

Delegates should already have a good working knowledge of Excel.

Advanced Excel 2007 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.