Activia for Microsoft Excel 2007 For Accounting (l2)
Bookings and Enquiries:                   0845 230 6150
Customer Service:                            0845 230 6159
We're here to help!     Click for a  FREE CALLBACK

Click to see the UK coverage of Excel 2007 Courses from Activia

Excel 2007 Courses From Activia

Microsoft Excel 2007 for Accounting Advanced

A One-Day Training Course

Your training is easier with Activia because we have:
  • Recognised national quality accreditations
  • Training businesses since 1995
  • Friendly, capable, flexible service
  • Dedicated training advisors
  • Unique tools and backup
  • Fiercely competitive prices !
Advanced Excel 2007 Courses from Activia
We'd like to discuss how we can give you the best service you will find.
Early Bird Prices from £199
Prices shown on schedules
Click image for more details
Want to know more ?
Call us on 0845 230 6150
or click below to
Request a Callback

Course Content

Course Aims

Microsoft Excel is probably the most useful office tool available to accounting functions for the simple analysis and manipulation of data. This Advanced training course focuses on more advanced functions, list management, as well as productivity tools such as PivotTables and Macros. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.

Who Should Attend

Anyone with a basic understanding of Excel 2007 in an accounting environment who wishes to improve their productivity and quality of work. Note : A working knowledge of using Microsoft Excel 2007 is required.

Course Outline

Excel Functions and Formulas
• Using Functions in Excel  • Working with Names and Ranges  • Working with Array Formulas 
Managing Tables
• Working with Tables  • Working with Records and Fields  • Working with Tables and Filters  • Using Excel as a Database 
Getting the Most from your Data
• Getting the Most from your Data  • PivotTables  • More About PivotTables  • Exploring Scenarios  • What If Analysis 
Advanced Excel Tasks
• Creating and Using Shared Workbooks  • Using Custom AutoFill Lists  • Using the VLOOKUP Function  • Linking, Consolidating, and Combining Workbooks 
Introduction to Macros
• Recording and Playing Macros  • Copying and Deleting Macros 

More Information

Prices for
Printer-friendly course outline for Microsoft Excel 2007 for Accounting Advanced

Related Courses

We also run the following related courses which may be of interest to you.
Click for full details of content, prices and dates:

Contact Us

Activia Training
Head Office:
    Regus House, 268 Bath Road
    Slough,   SL1 4DX

Sales:       0845 230 6150
Service:    0845 230 6159
Accounts: 0845 230 6157
Microsoft Excel 2007 for Accounting Advanced Training Courses from Activia

Feedback from Delegates on our Microsoft Excel 2007 for Accounting Advanced Courses


Average Review 5.0/5 based on 1 reviews.

"The course was usefull and enjoyable."     Tom Giles     Apr 18 2013    

Microsoft Excel 2007 for Accounting Advanced Training Courses from Activia
[ Close ]

Locations for Excel 2007 Courses from Activia

With our quality accreditations for ISO9001, IITT, ILM and the ILP, and a uniquely flexible service, you can be sure that your training course in Microsoft Excel 2007 will get the results you need, at the prices you want.

Activia centres for Microsoft Excel 2007 Course

With seventeen fully equipped training centres , Activia should be your first choice for courses for Excel 2007 wherever you are in the UK.
We provide Microsoft Excel 2007 Course courses in the following locations:

  • London
    We have six centres in London, serving the City in Bank and Liverpool Street, and Canary Wharf from our London Bridge (SE1) centre, as well as North, West and South West London, in Finchley, Baker Street and London Victoria.
  • Surrey and Sussex
    Our Croydon centre serves Croydon, Reigate and Redhill as well as Crawley, Gatwick and Brighton.
  • Berkshire
    We serve Berkshire and the Thames Valley with three centres in Reading, Slough and Bracknell.
  • Bristol
    Covering Bristol, Avon, Bath and South West England
  • Milton Keynes
    Serving Buckinghamshire, covering Milton Keynes, Aylesbury and High Wycombe, as well as Luton and Bedford.
  • Birmingham
    Serving Warwickshire and the Midlands: Birmingham, Walsall and Dudley, as well as Wolverhampton, Solihull and Tamworth.
  • Nottingham
    Serving Nottingham, Long Eaton and Derby, as well as Loughborough, Melton Mowbray and Leicester.
  • Manchester
    Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.
  • Sheffield
    Serving South Yorkshire, covering Sheffield, Barnsley and Doncaster as well as Chesterfield and Wakefield.
  • Leeds
    Serving Yorkshire and the North of England, covering Leeds, Bradford and Harrogate as well as Halifax, Wakefield and Castleford.
  • Newcastle Upon Tyne
    Serving Tyneside, also Sunderland and Gateshead, as well as North Shields, South Shields and Whitley Bay.

In House Excel 2007 Courses from Activia across the UK

For in house delivery of Microsoft Excel 2007 Course, you can expect the same standard of training and service for your MS Excel 2007 classes as you get at our centres, conveniently delivered at your offices.
To book your in-house learning Microsoft Excel 2007, you need look no further than Activia.


Click for more about MS Excel 2007 training courses UK from Activia


[ Close ]

Quality Assurance