Microsoft Excel Training
(2007, 2003, 2002 (XP), 2000, 97)
Excel Introduction (2 days)
£1,180, plus VAT, for up to 10 delegates
Delegates on our Introduction to Microsoft Excel will learn the basics of a spreadsheet application and will be able to create and modify spreadsheets containing data and formulas. The course covers the creation of simple worksheets and charts, entering, manipulating and formatting data and creating formulas.
The course is suitable for people who need to know how to create spreadsheets or work on existing Excel spreadsheets, using formatting and calculation tools.
No prior experience of Excel is expected. Although delegates with limited experience on other spreadsheet applications will have a slight advantage. A working knowledge of the Windows operating system and use of the mouse and keyboard is essential.
Excel Advanced (1 day)
£590, plus VAT, for up to 10 delegates
Delegates on this course will learn advanced Excel features allowing them to use look-up tables, pivot tables, data analysis tools such as Goal Seek, Scenarios and Solver as well as importing and linking to external data.
The course is suitable for competent Excel users who may be experiencing difficulties in realising some of their spreadsheet aspirations and therefore need to learn advanced tools and techniques.
Delegates should have attended the Intermediate course or be competent Excel users regularly using complex functions and formulas.
Excel VBA Programming (2 days)
£1,180, plus VAT, for up to 10 delegates
This two day course covers the automation of Excel using macros and Visual Basic for Application (VBA) programming. Delegates will be shown how to write simple VBA code and assign their macros to screen items.
This course is suitable for Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users' work) using macros.
No previous knowledge of VBA or of programming is required for this course.