Microsoft Office training - Advanced Excel (2 days)

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

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 training - Course Contents

The contents of our Advanced Excel 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 call or email us to talk through your options. We want you to be on the right Microsoft Office training course as much as you do!

Recording Macros
  • Absolute/relative recording
  • Where macros are stored
  • Assigning macros to buttons
Charts
  • Selecting data
  • Formatting your chart
Advanced charts
  • Combination charts
  • Picture charts
  • Custom chart types
  • Regression and trendlines
Lists
  • Sorting lists
  • Filtering lists
  • Extracting subtotals
  • The definition of a list
Pivot tables
  • Creating pivot tables
  • Swapping rows, columns and pages
  • Grouping fields
  • Drill-down
Multiple worksheets
  • Copying, moving and renaming sheets
  • The dangerous group mode
  • Summing across worksheets
  • 3-D range names
Consolidation (*)
  • Using formulae
  • Using arrays
  • Using data consolidation
  • Using pivot tables
Range names and absolute references
  • Absolute references ($ symbol)
  • Fixing only the row/column
  • Creating range names
  • Labelling ranges automatically
  • The amazing 40% rule
IF and LOOKUP functions
  • The conditional (IF) function
  • Nested IFs are evil
  • Lookup tables
  • The mysterious fourth lookup argument
Number formatting
  • Conditional number formats
  • The four parts of a format
  • Creating custom formats
  • Formatting dates and times
Styles (*)
  • Creating formatting styles
  • Using the style drop-down box
  • The NORMAL style
Validation and protection
  • Setting cell validation
  • Protecting cells/worksheets
  • Cell comments
Other techniques (*)
  • Goal-seeking
  • Creating scenarios

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.

Advanced Excel training - Pre-requisites

Delegates should already have a good working knowledge of Excel.

Advanced Excel training - Schedule and Prices

Prices for this Microsoft Office 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 Office 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 Office training

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

All content � Wise Owl Business Solutions Ltd 2007.  All rights reserved.  Design by Branches.