Book your Advanced Microsoft Excel 2007 Training Course
This one day course is being run twelve times between Thursday 23rd February 2012 and Tuesday 18th December 2012 in London,
Book this course with us today from as little as £350.00 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
THE COURSEBOOKERS PRICE GUARANTEE
The CourseBookers price guarantee means that if you find your course cheaper online before booking we will match price. Unlike many other booking administration companies, we have no booking fees! We've also negotiated special rates on your behalf with all of our training providers, and in some cases we can offer very competitive late booking discounts. These are always ready to view on our web site when available and are updated daily.
Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday

| Date | Location | Rating | Price | ||
|---|---|---|---|---|---|
| Thursday 23 February 2012 | London | ![]() ![]() ![]() | £350.00+VAT | ||
| Monday 26 March 2012 | London | ![]() ![]() ![]() | £350.00+VAT | ||
| Thursday 26 April 2012 | London | ![]() ![]() ![]() | £350.00+VAT | ||
| Tuesday 22 May 2012 | London | ![]() ![]() ![]() | £350.00+VAT | ||
| Monday 25 June 2012 | London | ![]() ![]() ![]() | £350.00+VAT | ||
| Monday 23 July 2012 | London | ![]() ![]() ![]() | £350.00+VAT | ||
| Thursday 16 August 2012 | London | ![]() ![]() ![]() | £350.00+VAT | ||
| Tuesday 11 September 2012 | London | ![]() ![]() ![]() | £350.00+VAT | ||
| Monday 08 October 2012 | London | ![]() ![]() ![]() | £350.00+VAT | ||
| Thursday 01 November 2012 | London | ![]() ![]() ![]() | £350.00+VAT | ||
| Monday 26 November 2012 | London | ![]() ![]() ![]() | £350.00+VAT | ||
| Tuesday 18 December 2012 | London | ![]() ![]() ![]() | £350.00+VAT |
Book your course now with Coursebookers!

Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Download Course OutlineDelegates should have a good grounding in Excel (any version but Excel 2007 is preferable) either from experience or attending training courses. If your job involves manipulating and analysing data in Excel you will find this course very advantageous. Also, if you spend most of your work day in Excel and you would like to fill in gaps in your knowledge you will find this course really useful.
Delegates should have a good grounding in Excel (any version but Excel 2007 is preferable) either from experience or attending training courses. If your job involves manipulating and analysing data in Excel you will find this course very advantageous. Also, if you spend most of your work day in Excel and you would like to fill in gaps in your knowledge you will find this course really useful.
- Text Functions in Excel 2007
- Count Functions
- Advanced ‘If’ statements
- Auditing Worksheets
- Trace Cell Precedents & Cell Dependents
- Locate Errors in Formulas
- Locate Invalid Data and Formulas
- Watch and Evaluate Formulas
- Goal Seek to reverse calculate a formula
- Creating Single Input Data Tables
- Dual Input Data Tables
- Setting up and manipulating scenarios for What-If? Analysis
- Consolidating Data by position
- Consolidate by Label
- Group And Outline Features
- Create a Pivot Table Reports from new
- Analysing Data with Pivot Tables
- Manipulate the Pivot Table
- Formatting Pivot Tables
- Creating Pivot Charts
- Grouping data in Pivot Tables
- Importing Text Files
- Setting Up Database Queries
- Connecting Excel to the Web to Import Data
- Recording Macros
- Edit a Macro
- Creating Buttons to Run the Macros
- Customize Access to Excel Commands
- Adding Icons to the Toolbars
- Creating your own Menu
- Editing Menus
- Adding Options to Menus to run Macros
Delegates should have a good grounding in Excel (any version but Excel 2007 is preferable) either from experience or attending training courses. If your job involves manipulating and analysing data in Excel you will find this course very advantageous.
Reed Learning has offered high quality professional business and management training since 1995, offering 100,000 days of training annually across the UK. Reed Learning is committed to having the most passionate business and management course trainers in the UK and it is because of this they can offer training courses of an award winning standard.
Main menu
Software Vendor
IT Technical
Business Skills
- Project Management (163)
- ITIL (21)
- PRINCE2 (48)
- Reporting (18)
- HR (25)
- Health and Safety (3)
- Management (71)
- Business Development (4)
- Strategic Management (3)
- Personal Development (202)
- Leadership (70)
- Administration (21)
- Finance (32)
- Sales and Marketing (58)
- IT Service Management (83)
- Customer Service (21)
- Legal (8)

