£90+VAT. (Click here for information on the Flexiticket discount scheme - fees as low as £39.60+VAT per place) This course, if booked individually, is available to IT Faculty members  for £60+VAT each.  For details of these other courses click here. Phone 01737 223999 for more details.

The course is designed to address some more advanced Excel features and capabilities that will be of use to those working with financial data. It is based on the very popular '100 ways to make Excel easier course' but, in the few cases where similar techniques are covered, this course will feature different or extended applications of those techniques. Some significant new features in Excel 2007 and 2010 will be covered, but most of the course will be relevant to users of any Excel version. The intention is to cover areas that provide real practical benefits including making spreadsheets more automatic, more reliable and also increasing their impact through improved presentation.

The course will assume a familiarity with some Excel subjects, eg:

• Absolute and relative cell references
• Excel functions such as IF(), VLOOKUP(), SUMIF()
• Basic chart creation
• Basic PivotTables

• Advanced use of functions – including using apparently simple functions to save hours of manual effort
• Excel formulae and techniques – including array formulae, alternatives to array formulae, advanced aspects of range names
• Macros and Visual Basic. Creating user defined functions, editing and writing macros. Increasing interactivity and automating spreadsheets with macros.
• Data analysis tools – working efficiently with external data and using extended data tools and PivotTable features
• Presentation – improving general spreadsheet presentation and making charts better. Using the latest Excel graphics features to create inspirational spreadsheets