|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
926 Excel events in the next 12 months, live dates & pricing here |
Who is this course for?
Advanced users of Excel with extensive knowledge & use of nesting functions. Those looking to share experiences and experiment in an interactive workshop format.
Prerequisites
Attendance or familiarity with of our Excel Advanced Part 2 course.
Objectives
- Discover new ways to analyse your data by using the Analysis ToolPak add-in program
- Use Excel forms to improve data input, speed up data selection and navigation
- Functional Macros that help you make global changes, return queries and improve security
- Opportunity to discuss practical applications & revisions of tools used
Course Syllabus
Analysing Data with the Analysis ToolPak Correlation Using Forms Creating forms containing text box, command button, combo box, check box, option button, list box, scroll bar and spin button controls. | Creating Functional Macros Creating macros to change case, add message boxes, display a form, protect worksheets. Workshop Sessions Practical application and revision of tools used. |
|
||||||||
| Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
|||||||
| Fri 24 May 2013 | Limehouse | 0 | FULL | £350 | ||||
| Fri 2 Aug 2013 | Southwark | 5 | ![]() |
£279 | £290 | £350 | ||
| Tue 24 Sep 2013 | Bloomsbury | 6 | ![]() |
£277 | £287 | £350 | ||
| Mon 28 Oct 2013 | Southwark | 6 | ![]() |
£276 | £287 | £350 | ||
| Fri 29 Nov 2013 | Bloomsbury | 7 | ![]() |
£167 | £178 | £350 | ||
| Fri 20 Dec 2013 | Southwark | 8 | ![]() |
£150 | £160 | £350 | ||
| Fri 24 Jan 2014 | Southwark | 7 | ![]() |
£167 | £178 | £350 | ||
| Mon 24 Feb 2014 | Limehouse | 8 | ![]() |
£150 | £160 | £350 | ||
| Thu 27 Mar 2014 | Bloomsbury | 8 | ![]() |
£150 | £160 | £350 | ||
| Tue 29 Apr 2014 | Limehouse | 8 | ![]() |
£150 | £160 | £350 | ||
| Fri 23 May 2014 | Limehouse | 8 | ![]() |
£150 | £160 | £350 | ||
| Mon 30 Jun 2014 | Southwark | 8 | ![]() |
£150 | £160 | £350 | ||
| Mon 28 Jul 2014 | Limehouse | 8 | ![]() |
£150 | £160 | £350 | ||
| Wed 27 Aug 2014 | Bloomsbury | 8 | ![]() |
£150 | £160 | £350 | ||
What you get
Training is held in our modern, comfortable, air-conditioned suites Modern-spec IT, fully networked with internet access |
"What do I get on the day?" |
Learning tools |
Courses start at 9:30am. |
Contains unit objectives, exercises and space to write notes |
Available throughout the day:
|
Available online. 100+ pages with step-by-step instructions |
Lunch is provided at a local restaurant or pub. Browse the sample menus: |
Your questions answered by Microsoft qualified trainers online. |
Training Formats & Services
|
Some reasons why thousands of businesses trust us
|
|




























