Microsoft Excel courses

Excel for Accounting : Advanced

A One-Day Training Course

Activia makes your training easier because we give you:

Recognised national quality accreditations
Friendly, capable, flexible service
Genuinely competitive prices

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 manipulating and displaying data, and introduces delegates to productivity tools such as Pivot Tables 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 in an accounting environment who wishes to improve their productivity and quality of work.
Note: A working knowledge of using Microsoft Excel is required.

Course Outline: Excel for Accounting : Advanced

Sorting and Filtering Data

Create a data list
Perform single and multi-level sorts
Apply a filter to a data list

Adding Charts and Pictures to a Workbook

Use the Chart Wizard to create a chart
Move and size worksheet charts
Change the chart type
Format chart elements
Change the source data for a chart
Preview and print charts
Insert, move and delete clip art and picture objects
Create and modify lines and objects

Using Named Ranges

Add and delete a named range
Use a named range in a formula

Importing and Exporting Data in Excel

Use Paste Special to import and manipulate data
Export worksheet data to other applications
Import data from a text file
Import a table from an HTML web page
Round trip HTML data in Excel

Lookup and Reference Functions

Use VLOOKUP and HLOOKUP to get values from multi-column tables
Sort values in rows or from left-to-right
Use the LOOKUP function
Prevent lookup errors

Customising Excel Toolbars

Hide and display a toolbar
Dock and float toolbars
Customise a toolbar
Create a new toolbar

Using Macros in Excel

Record a macro
Run a macro from the menu or the keyboard
Edit a macro
Assign a macro to a toolbar button or a menu
Implement macro virus file protection

Data Management

Extract data using advanced filters
Group and subtotal data using the outlining tools
Use Dfunctions for calculations on a data list
Query a database
Understand and work with a data source
Format external data
Query data from XML data sources

Pivot Table and Pivot Chart Reports

Analyze data using a Pivot Table Report
Create a Pivot Chart Report
Use Pivot Table AutoFormat
Create Pivot Table Lists for the web
Add fields to a Pivot Table using a web browser

Useful Links

Click to:

• Print the course outline

• Get us to call you back
• Request a free brochure

Public Training Courses for Excel for Accounting : Advanced

Sorry -- we do not arrange scheduled public courses for our Excel for Accounting : Advanced course at the moment.

But if you would like to arrange a private training course, please see the section below and contact us – we'll be pleased to discuss the best options for you.

Private & In-House Training Courses for Excel for Accounting : Advanced

We can also deliver private training courses at our training centres or 'in-house' on your premises, on dates to suit you and your staff.

Course content can either follow the standard outline, or be tailored to your requirements at no extra charge.

Although we will organise your training course for as many delegates as you wish, we recommend that any class does not exceed 8 delegates to ensure that learning objectives are met.

Prices
Prices vary according to the size of the class, but can be as low as Ł85 per delegate. See below for more details
At your offices – from Ł399.
At our centres – from Ł449.

Quick Price Calculator

	Total price per day
No. of Delegates	1	2	3	4	5	6	More
Training At an Activia centre	£449	£499	£549	£599	£649	£699	+ £50 each
- Cost per delegate	£449	£250	£183	£150	£130	£116	£100 for 8
Training At your office	£399	£439	£479	£519	£559	£599	+ £40 each
- Cost per delegate	£399	£220	£160	£130	£112	£100	£85 for 8

Please note : all prices exclude VAT

Activia, Regus House, 268 Bath Road, Slough, Berkshire SL1 4DX
Telephone: 0845 230 6150 (local rate)

Excel training courses UK | Why Activia
Copywriting for web sites

Why Activia for Microsoft Excel courses ?

Microsoft Excel courses in West London, Birmingham, Slough, London Heathrow and Aylesbury

Activia should be your first choice for courses in Excel in the UK. We provide you with a full range of classes for job-related Business Skills, HR & supervision, Sales and Management Development as well as IT applications from Microsoft, Sage, Adobe, Macromedia, Crystal Reports and Lotus.If you are looking for MS Excel classes, you will find that Activia offers a level of service that is unrivalled in the market.

Courses in Excel

If your requirement is Microsoft Excel courses, we can provide you with classes at highly competitive prices. You will find that for learning MS Excel, Activia will provide more tailored, flexible and focused solutions, and this enables you to get the most from your budget using the minimum of resources.

Courses in London, the Midlands, Berkshire (Berks), Buckinghamshire (Bucks), Surrey, Middlesex and UK wide

We provide Microsoft Excel courses courses all over the UK, with modern, fully equipped training centres in the following locations:

West London

Serving London, as well as areas like Brentford, Kew, Watford and Richmond.

London Heathrow

Serving Middlesex and Surrey, covering Uxbridge, Staines, Egham, Sunbury, Hounslow and Twickenham.

Birmingham

Serving Warwickshire and the Midlands, covering Solihull, Dudley and Wolverhampton as well as Coventry, Telford and Worcester.

Slough

Serving Berkshire and the Thames Valley, covering Slough, Reading, Windsor and Maidenhead as well as Bracknell, Newbury and Basingstoke.

Aylesbury

Serving Buckinghamshire, covering Aylesbury, Milton Keynes and High Wycombe, as well as Oxford, Luton and Hemel Hempstead.
Our experienced, high quality trainers will deliver your training to the highest standards and with the maximum effect.

In House Microsoft Excel courses across the UK

For in house delivery of Courses in Excel, we have an established national UK network of trainers, as well as centres in London, Birmingham, Slough, London Heathrow and Aylesbury, so you can be sure that your courses in Excel will be delivered in a quality assured and cost effective manner. For in-house Microsoft Excel courses, you need look no further than Activia.

[ Close ]