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.

See all courses provided by Reed

Expert Help

If you would like
advice, or to book, call
one of our experts on
01920 460232

Open: 9am - 5:30pm
Monday- Friday

Locations/dates for this course
DateLocationRatingPrice
Thursday 23 February 2012London£350.00+VAT
Monday 26 March 2012London£350.00+VAT
Thursday 26 April 2012London£350.00+VAT
Tuesday 22 May 2012London£350.00+VAT
Monday 25 June 2012London£350.00+VAT
Monday 23 July 2012London£350.00+VAT
Thursday 16 August 2012London£350.00+VAT
Tuesday 11 September 2012London£350.00+VAT
Monday 08 October 2012London£350.00+VAT
Thursday 01 November 2012London£350.00+VAT
Monday 26 November 2012London£350.00+VAT
Tuesday 18 December 2012London£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 Outline

Summary: 

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.

Audience: 

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

Description: 

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

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.