We will organise on-site (in-house), customised training on Microsoft Excel anywhere in the UK. We train on all versions of Excel (97, 2000, 2002, 2003 and Excel 2007). We offer a highly competitive rate of just £695, plus VAT per day.
Microsoft Excel combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Delegates will learn the basics of creating, editing, and saving worksheets. They will work with formulas and functions to calculate and return values. Delegates will learn to change the appearance of a page, including adding headers and footers, format data and create charts.
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.
This course is designed for existing users of Excel. It show delegates how to work with multiple worksheets, create and format charts, work with complex formulas and use advanced formatting techniques.
The course is suitable for those who are comfortable working with Excel spreadsheet and who know how to enter and edit data and create formulas.
Our advanced Excel course will show experienced Excel users how to work with lists (databases), create macros and user-defined functions, perform what-if analysis, use advanced analysis tools and work with external data.
The course is suitable for those with a good knowledge of all of Excel's basic and intermediate features and shortcuts.
This course is aimed at experienced Excel users and focuses on the creation of formulas using the most useful functions in each of Excel's main function categories. Delegates will also be shown how to use nested functions to build complex formulas, how to audit formulas and handle formula errors.
The course is suitable for those with a good knowledge of Excel basics. Functions are at the core of Microsoft Excel and provide much of its power. However, many users find working with functions and formulas confusing and frustrating.
This introduction to VBA programming will familiarise delegates with the core features of Microsoft Excel VBA. At the end of the training, delegates will understand VBA syntax and structure and be able to write and deploy basic macros using VBA.
The course is suitable for those with a good knowledge of all of Excel's basic and intermediate features and techniques.
This in-depth two-day course provides Excel VBA developers with a more in-depth knowledge of Excel VBA objects: application, workbooks, worksheets, ranges, and user forms.
The course is suitable for those with good knowledge of Excel and familiarity with basics of VBA.
This advanced course shows experienced Excel VBA developers how to develop Excel applications and work with VBA complex objects and concepts such as pivot tables, charts and class modules.
The course is suitable for those with good knowledge of Excel and experience of developing macros using VBA.