Our Team Leadership and Management Programmes are recognised by the ILM.
This course is suitable for people who have good knowledge and understanding of Excel or have attended the Excel Intermediate course and would like to learn about automation and other advanced features.
Spreadsheets can become very complex with one formula calculating from the results of several others. This course covers the tools to trace problems with complex formulae and methods for consolidating several worksheets.You will also learn about the analytical tools in Excel and how to use them for goal seeking. You will learn about macros, how to create templates for commonly used worksheets and how to protect data using security features.
The auditing tools
Validation of data
Consolidation and linking of spreadsheets
Data tables and lookup tables
Goal seeking from formulae and charts
Solving from a complex formula
Using scenarios
Array formulae
Macros
Security
Hiding workbooks and worksheets
Creating and using templates
1 day, normally between 9:30 and 4:30
This course is offered as an in-house option either at your offices or one of our IT suites. If you choose to use one of our venues room hire and catering would be charged at our specially negotiated rates.
The cost of an in house course including all training materials for up to 12 delegates is £1125 + VAT.
We also offer 1-to-1 training at your premises for £450 + VAT.
To celebrate the Queen’s 60 years on the throne, we are offering our “Diamond Jubilee Mates Rate” for all courses running in June. Book one full price place and send a second person on the same course for only £60 per day (+ VAT)
for completing our customer survey. The winner of the draw for a free one day open course place was Pepenbury, a local charity supporting adults with learning disabilities.
Thu, 07/06/2012
Book now £805 (+ VAT) per person on scheduled course including ILM registration. £2250 (+VAT) for training at your premises for a group of staff + £75 per person ILM registrationMon, 11/06/2012
Book now £365 (+VAT) per person on scheduled course. £1125 (+VAT) for training at your premises for a group of staff.Tue, 12/06/2012
Book now £1170 (+VAT) per person on a scheduled course including ILM certification. This course can be run in-house for up to 12 delegates over 3 days for £3375 + £75 per person ILM certification fee + VAT.
Kent Trainers. Business training in South East England