Microsoft Excel

Excel is the workhorse application for accountants, though many are self-taught and use only a small part of its potential. Seven courses are currently available, covering Microsoft Excel 97, Microsoft Excel 2000, Microsoft Excel 2002, and Microsoft Office Excel 2003.

Practical Excel 97 for Accountants Duration Level View syllabus
8 hours Intermediate Practical Excel 97
This course assumes no prior knowledge of Excel 97 and teaches to an intermediate level. It uses an extended trial balance and cashflow forecast as the basic training documents, and is geared towards teaching finance and accounts staff to use Excel 97 in their working environments. The course is equally relevant for the Excel novice and the more practiced user who wants more from this world leading spreadsheet.

Practical Excel 2000 for Accountants Duration Level View syllabus
8 hours Intermediate Practical Excel 2000
This course assumes no prior knowledge of Excel 2000 and teaches to an intermediate level. It uses an extended trial balance and cashflow forecast as the basic training documents, and is geared towards teaching finance and accounts staff to use Excel 2000 in their working environments. The course is equally relevant for the Excel novice and the more practiced user who wants more from this world leading spreadsheet.

Practical Excel 2002 Duration Level View syllabus
8 hours Intermediate Practical Excel 2002
This course assumes no prior knowledge of Excel 2002 and teaches to an intermediate level. It uses a monthly budget as the basic training documents, and is geared towards teaching the use of Excel 2002 in home and working environments. The course is equally relevant for the Excel novice and the more practiced user who wants more from this world leading spreadsheet. The course is a complete rewrite of its predecessor on Excel 2000, and covers many new areas.

Practical Excel 2003 Duration Level View syllabus
8 hours Intermediate Practical Excel 2003
This course assumes no prior knowledge of Excel 2003 and teaches to an intermediate level. It uses a monthly budget as the basic training documents, and is geared towards teaching the use of Excel 2003 in home and working environments. The course is equally relevant for the Excel novice and the more practiced user who wants more from this world leading spreadsheet.

Adding Value with Excel 2000 Duration Level View syllabus
16 hours Advanced Adding Value with Excel 2000
This is an advanvced course on Excel 2000, which is equally suitable for users of Excel 97. It is designed for those who need to take Excel that bit further in practice. You may need to analyse financial data for reporting purposes, prepare management and consolidation accounts, or undertake advanced reporting on databases. This courses shows you how to harness the power of ODBC, Microsoft Query, Pivot Tables, VBA Macros, and other facilities and functions to achieve all of this. Complete this course and you can consider yourself to be a highly competent Excel user.

Advanced Excel 2002 Duration Level View syllabus
16 hours Advanced Advanced Excel 2002
This is an advanvced course on Excel 2002. It is designed for those who need to take Excel that bit further in practice. You may need to analyse financial data for reporting purposes, prepare management and consolidation accounts, or undertake advanced reporting on databases. This courses shows you how to harness the power of ODBC, Microsoft Query, Pivot Tables, VBA Macros, and other facilities and functions to achieve all of this. Complete this course and you can consider yourself to be a highly competent Excel user.

Advanced Excel 2003 Duration Level View syllabus
16 hours Advanced Advanced Excel 2003
This is an advanvced course on Excel 2003. It is designed for those who need to take Excel that bit further in practice. You may need to analyse financial data for reporting purposes, prepare management and consolidation accounts, or undertake advanced reporting on databases. This courses shows you how to harness the power of ODBC, Microsoft Query, Pivot Tables, VBA Macros, and other facilities and functions to achieve all of this. Complete this course and you can consider yourself to be a highly competent Excel user.