£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 show you practical, effective ways to analyse, manipulate and present data from your accounting packages using spreadsheets.  Whilst we will be using Microsoft Excel throughout the seminar, much of the content should be useful to you whichever spreadsheet you use.  Please note this is not a ‘hands-on’ course, but will provide practical advice, demonstrated through examples and with comprehensive documentation.

Anyone who needs to analyse and present accounting data.

• Getting at your data – importing from, or linking to your accounting system
• Working with data – data structure fundamentals
• Manipulating the data – useful Excel functions
• Advanced Excel functions and techniques for data analysis
• Unleashing the power of PivotTables – interactive reporting in Excel
• Presentation – formatting the results and using charts