When you’ve taken the plunge and upgraded to Excel 2007, you will almost certainly benefit from some training. Which type of training you choose depends on your existing experience in using the program. However, in general, the ideal course will first of all rid you of the disorientation most Excel users feel when faced with the Excel 2007 interface. In addition, your Excel 2007 training course should show you how to make the most of the new features version 2007 has to offer.

One of the first things you should look for in having training on Excel 2007 is a full explanation of how the new interface works. You should be shown the new way of working and learn useful tips and shortcuts which will enable you to become at least as productive in Excel 2007 as you were in 2003.

In addition to this, however, you will want to learn the new features that Excel 2007 has to offer: the stuff that either wasn’t available in previous versions or which has undergone considerable enhancement.

The number of cells in an Excel 2007 worksheet is now about 1000 times bigger than in previous versions. If you book training on Excel 2007, you should learn ways of taking advantage of this new space and also pick some tips on efficient navigation and management of this huge area.

Pivot tables are a key area where Excel 2007 has made improvements. Ensure that any Excel 2007 training that you book includes first of all an explanation of pivot table essentials (pivot tables often confuse users) and then moves on to the new ways of creating and manipulating pivot tables offered in Excel 2007.

Charts have been given a big overhaul in version 2007. So be sure your training includes coverage of the special effects available in Excel 2007 charting and graphics. Your training course should cover such features as the format, design and layout ribbons and how to use SmartArt graphics and shapes. If charting is particularly important in your organisation, then make sure your training covers things like trendlines, scatter charts and pivot charts.

Another feature that has been developed in Excel 2007 is conditional formatting. Be sure that any training you have on Excel 2007 includes some insight into the use of Excel 2007′s powerful new conditional formatting features especially Data Bars and Color Scale.

An Excel spreadsheet without formulas and functions is not much use to anyone. Functions are what Excel is all about. Microsoft have improved the way in which function are entered and edited and added several new functions. When you book training on Excel 2007, make sure that your course will include coverage of new functions like SumIfs, IfError and AverageIf as well as a demonstration of the improvements to the editing of formulas.