Microsoft Excel training

Excel for Accounting : Introduction

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 Introduction training course focuses on formatting and structuring worksheets, and on understanding calculations and formulae.
It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.

Who Should Attend?

Anyone who wishes to start using Excel in an accounting environment.
Note: A working knowledge of using PCs in the Microsoft Windows environment is required, and a familiarity with the Microsoft Excel interface would also be an advantage.

Course Outline: Excel for Accounting : Introduction

Formatting a Worksheet

Font styles (typeface, size, colour, styles)
Modify alignment & orientation of cell contents
Merge and unmerge cells
Value formats (currency, percent, date, comma)
Adjust the decimal place
Modify the size of columns and rows
Clear cell content and formats

Borders, Shading and Other Formatting

Apply cell borders and shading
Apply AutoFormat
Use the Format Painter
Modify alignment and orientation of cells
Indent text in a cell

Custom Number & Conditional Formatting

Number formats (accounting, currency, number)
Create a custom number or date format
Use conditional formatting

Creating a Formula

Create simple calculations
Use AutoSum
Enter a formula: typing or using the Formula bar
Revise a formula, Use Insert Function
Functions (AVERAGE,SUM,COUNT,MIN,MAX)
Relative and absolute cell references
Recognise common error messages

Using More Advanced Formulae

Use financial functions
Use date and time functions
Use statistical functions
Use the ROUND function
Use text functions
Use logical functions
Create a formula using nested functions

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 : Introduction

Sorry -- we do not arrange scheduled public courses for our Excel for Accounting : Introduction 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 : Introduction

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 training ?

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

Activia should be your first choice for training 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.

Training in Excel

If your requirement is courses for Microsoft Excel, we can provide you with classes at highly competitive prices. You will find that for Microsoft Excel classes, 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 training 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 training Courses across the UK

For in house delivery of Training 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 training in Excel will be delivered in a quality assured and cost effective manner. For in-house courses for Microsoft Excel, you need look no further than Activia.

[ Close ]