Book your Intermediate Microsoft Excel 2007™ Training Course
This one day course is being run 22 times between Tuesday 21st February 2012 and Thursday 20th December 2012 in London,
Book this course with us today from as little as £199.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.
See all courses provided by ReedExpert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Location | Rating | Price | ||
|---|---|---|---|---|---|
| Tuesday 21 February 2012 | London |  | £199.00+VAT | ||
| Wednesday 07 March 2012 | London | | £199.00+VAT | ||
| Friday 23 March 2012 | London | | £199.00+VAT | ||
| Tuesday 10 April 2012 | London | | £199.00+VAT | ||
| Tuesday 24 April 2012 | London | | £199.00+VAT | ||
| Thursday 10 May 2012 | London | | £199.00+VAT | ||
| Friday 25 May 2012 | London | | £199.00+VAT | ||
| Wednesday 13 June 2012 | London | | £199.00+VAT | ||
| Thursday 28 June 2012 | London | | £199.00+VAT | ||
| Wednesday 11 July 2012 | London | | £199.00+VAT | ||
| Wednesday 25 July 2012 | London | | £199.00+VAT | ||
| Tuesday 07 August 2012 | London | | £199.00+VAT | ||
| Tuesday 21 August 2012 | London | | £199.00+VAT | ||
| Friday 07 September 2012 | London | | £199.00+VAT | ||
| Thursday 20 September 2012 | London | | £199.00+VAT | ||
| Wednesday 03 October 2012 | London | | £199.00+VAT | ||
| Tuesday 16 October 2012 | London | | £199.00+VAT | ||
| Monday 29 October 2012 | London | | £199.00+VAT | ||
| Friday 09 November 2012 | London | | £199.00+VAT | ||
| Friday 23 November 2012 | London | | £199.00+VAT | ||
| Wednesday 05 December 2012 | London | | £199.00+VAT | ||
| Thursday 20 December 2012 | London | | £199.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 OutlineSummary:
This course follows on from our Office Excel 2007 introduction course with more complex formulas and functions. There is a recap session at the start for delegates who may have completed the introduction in a previous version.
Audience:
This intermediate course is designed for users who are already confident in the basic features of Microsoft Excel (any version but preferably Office 2007) and wish to further their knowledge and understanding. In this course we will focus on working with large amounts of data.
Objectives:
You will learn how to utilise database functionality, create lookups to obtain range and precise data. Gain an understanding on how to add ‘IF’ statements and using validation to restrict access to cells, rows and columns.
- Recap on User Interface, Environment and Shortcuts
- Absolute References
- Naming Cells and Ranges
- Referring to named cells and ranges in formulae
- Editing Named Cells and Ranges
- Setting up entire workbooks with Group Editing
- Using Lookup statements to retrieve data
- Editing Lookups and ensuring accuracy in returned data
- Linking spreadsheets and Workbooks together with formulas and functions
- Utilising If Statements to assist decision making
- If statements and Calculations
- Analysing Data with the all new Conditional Formatting Features
- Databases in Excel understanding Fields and Records
- Sorting data numerically and alphabetically
- Filtering Data for range and precision analysis
- Setting up data Validation to ensure integrity of the data
- Attaching Security to a spreadsheet
- Selective protection i.e.: Protecting formulas while allowing data entry
- Setting up and utilising Templates
- Creating and Formatting Charts
- Adding Trend lines to the chart
- Utilising Custom Chart Types
Description:
This course follows on from our Office Excel 2007 introduction course with more complex formulas and functions. There is a recap session at the start for delegates who may have completed the introduction in a previous version.
Reed
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.
Want to leave your own testimonial? click Here
No Testimonials have been left for this course.