Microsoft Excel 2003 Courses

Microsoft Excel 2003 for Accounting: Advanced

A One-Day Training Course


Your training is easier with Activia because we have:
  • Recognised national quality accreditations
  • Friendly, capable, flexible service
  • Fiercely competitive prices !
advanced excel 2003 courses from activia
We'd like to discuss how we can give you the best service you will find.

Want to know more ?

Call us on 0845 230 6150

or click below to

Course Information

Click on the links below for more information about the Microsoft Excel 2003 for Accounting: Advanced course.
[NOTE: links open in a new window.]

Related Courses

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

Contact Us

Do you have the information you need?

Call us on 0845 230 6150 or ask us to call you
– we'd like to discuss the best options for you.

Alternatively you can request a free brochure


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, scenarios and what if analysis, 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 in an accounting environment who wishes to improve their productivity and quality of work. Note : A working knowledge of using Microsoft Excel is required.

Quick Course Outline: Microsoft Excel 2003 for Accounting: Advanced

Introduction and Course Overview


Working with Functions and Formulas

Using Functions in Excel: • Inserting Functions  • Using Functions And Autofill To Perform Difficult Calculations  • Using The IF Function  • Working With Nested Functions 
Working with Names and Ranges: • What Are Range Names?  • Defining And Using Range Names  • Selecting Nonadjacent Ranges  • Auto Calculate 
Working with Array Formulas: • What Are Array Formulas  • Using Basic Array Formulas  • Using Functions with Array Formulas  • Using the IF Function in Array Formulas 
Introduction to Financial Functions: • PMT Function  • FV Function 
Using Functions in Excel: • Inserting Functions  • Using Functions And Autofill To Perform Difficult Calculations  • Using The IF Function  • Working With Nested Functions 
orking with Names and Ranges:
orking with Names and Ranges: • What Are Range Names?  • Defining And Using Range Names  • Selecting Nonadjacent Ranges  • Auto Calculate 
orking with Array Formulas: • What Are Array Formulas  • Using Basic Array Formulas  • Using Functions with Array Formulas  • Using the IF Function in Array Formulas 
troduction to Financial Functions: • PMT Function  • FV Function 

Managing Lists

Working with Lists: • What Is A List?  • Creating Lists  • Modifying Lists  • What Is The Total Row? 
Working with Records and Fields: • What Are Records And Fields?  • Adding Fields By Inserting Columns  • Adding Records By Inserting Rows  • Adding Records With A Data Form  • Finding And Deleting Records 
Working with Lists and Filters: • Sorting A List  • What Is An Autofilter  • Custom Autofilters  • Using An Advanced Filter  • Copying Filtered Records 
Using Excel as a Database: • Filtering With Wild Card Characters  • Validating Your Data  • What Are Database Functions?  • What Are Lookup Functions? 
Working with Lists: • What Is A List?  • Creating Lists  • Modifying Lists  • What Is The Total Row? 
orking with Records and Fields: • What Are Records And Fields?  • Adding Fields By Inserting Columns  • Adding Records By Inserting Rows  • Adding Records With A Data Form  • Finding And Deleting Records 
Working with Lists and Filters: • Sorting A List  • What Is An Autofilter  • Custom Autofilters  • Using An Advanced Filter  • Copying Filtered Records 
sing Excel as a Database: • Filtering With Wild Card Characters  • Validating Your Data  • What Are Database Functions?  • What Are Lookup Functions? 

Grouping Data and Using PivotTables

Outlining and Grouping your Data: • Using Automatic Outlining  • Displaying And Collapsing Levels  • Grouping Data Manually  • Creating Subtotals 
PivotTables: • PivotTables  • Creating A PivotTable Frame  • Specifying Data in a PivotTable  • Rearranging PivotTable Data 
More on PivotTables: • Modifying PivotTable Calculations  • Formatting A PivotTable  • Refreshing A PivotTable  • Charting A PivotTable  • Creating a PivotTable based on Data from an External Database 
Outlining and Grouping your Data: • Using Automatic Outlining  • Displaying And Collapsing Levels  • Grouping Data Manually  • Creating Subtotals 
PivotTables: • PivotTables  • Creating A PivotTable Frame  • Specifying Data in a PivotTable  • Rearranging PivotTable Data 
More on PivotTables: • Modifying PivotTable Calculations  • Formatting A PivotTable  • Refreshing A PivotTable  • Charting A PivotTable  • Creating a PivotTable based on Data from an External Database 

Scenarios and What If Analysis

Exploring Scenarios: • What Is A Scenario?  • Creating A Scenario  • Creating a Scenario Summary Report  • Saving Multiple Scenarios 
What if Analysis: • Using A One And Two Input Data Table  • Using Goal Seek  • Using Solver 
Exploring Scenarios: • What Is A Scenario?  • Creating A Scenario  • Creating a Scenario Summary Report  • Saving Multiple Scenarios 
What if Analysis: • Using A One And Two Input Data Table  • Using Goal Seek  • Using Solver 

Using Simple Macros in Excel

Creating Macros in Excel: • What Is A Macro?  • Creating A Macro  • Playing A Macro  • Assigning A Shortcut Key To Macro  • Macros, Buttons, And Toolbars 
Creating Macros in Excel: • What Is A Macro?  • Creating A Macro  • Playing A Macro  • Assigning A Shortcut Key To Macro  • Macros, Buttons, And Toolbars 

Microsoft Excel 2003 for Accounting: Advanced

A One-Day Training Course

Prices for Microsoft Excel 2003 for Accounting: Advanced

Activia's prices are always among the best in today's market, and if you are offered a lower price for a like-for-like course, then we will match it.   Click for details of the Activia Price Promise.

Scheduled Public Classes

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

Private & In-House Training Courses

We can deliver private training courses at one of our training centres or on your premises:
 
Total price per day (all delegates)
No. of Delegates
1
2
3
4
5
6
More
Training At an Activia centre
£499
£549
£599
£649
£699
£749
+ £50 each
 - Cost per delegate
£499
£274
£200
£162
£140
£125
£106 for 8
Training At your office
£449
£489
£529
£569
£609
£649
+ £40 each
 - Cost per delegate
£449
£244
£176
£142
£122
£108
£91 for 8

Please note : all prices exclude VAT

Microsoft Excel 2003 for Accounting: Advanced

A One-Day Training Course

Dates for Microsoft Excel 2003 for Accounting: Advanced

Scheduled Public Classes

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

Private & In-House Training Courses

We can deliver private training courses at one of our training centres or on your premises:
  • Very competitive prices
  • Dates arranged to suit your availability
  • Content can be or tailored to your needs at no extra charge
  • Our unique Bespoke Course Builder is available
  • Class sizes to suit you  (we recommend a maximum of 8)


Activia, Abbey House, 18-24 Stoke Road, Slough, SL2 5AG
Telephone: 0845 230 6150 (local rate)
[ Close ]

Why Activia for Microsoft Excel 2003 Courses ?

Microsoft Excel 2003 Courses in London, Berkshire, Buckinghamshire, Hampshire and Birmingham

Activia should be your first choice for courses in Excel 2003 and 2007 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, MS Office, Sage, Adobe, Macromedia, Crystal Reports and Lotus. If you are looking for Microsoft Excel 2003 classes, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Microsoft Excel 2003 Courses at fiercely competitive prices.

MS Excel 2003 Training Course

If your requirement is Microsoft Excel 2003 spreadsheet software courses, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for learning Microsoft Excel 2003 , 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), Hampshire (Hants), Surrey, Middlesex and UK wide

We provide MS Excel 2003 Training Course courses all over the UK, with modern, fully equipped training centres in the following locations:

Microsoft Excel 2003 Courses in the City of London

Serving the City and West End of London, as well as areas like Leytonstone, Walthamstow, Barking, Chingford and Ilford.

Microsoft Excel 2003 Courses in West London

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

MS Excel 2003 Training Course at London Heathrow

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

Microsoft Excel 2003 Courses in Birmingham City Centre

Serving Warwickshire and the Midlands, covering Birmingham, Walsall and Dudley as well as Wolverhampton, Telford and Tamworth.

MS Excel 2003 Training Course in Birmingham South

Serving Warwickshire and the Midlands, covering Solihull, Halesowen and Redditch as well as Coventry, Kidderminster and Worcester.

Microsoft Excel 2003 Courses in Manchester

Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.

Microsoft Excel 2003 Courses in Reading

Serving Berkshire and the Thames Valley, covering Reading, Theale and Newbury as well as Henley, Bracknell and Basingstoke.

MS Excel 2003 Training Course in Slough

Serving Berkshire and the Thames Valley, covering Slough, Windsor and Maidenhead as well as Gerrards Cross, Uxbridge and Watford.

Microsoft Excel 2003 Courses in Aylesbury

Serving Buckinghamshire, covering Aylesbury, High Wycombe and Hemel Hempstead, as well as Oxford, Bicester and Buckingham.

MS Excel 2003 Training Course in Milton Keynes

Also serving Buckinghamshire, covering Milton Keynes, Luton and Bedford, as well as Stevenage, St Albans and Welwyn Garden City.

Microsoft Excel 2003 Courses in Basingstoke

Serving Hampshire, covering Basingstoke, as well as Camberley, Farnborough, Aldershot to the east, and Newbury, Andover and Winchester to the west.

Our experienced, high quality trainers will deliver your training to the highest standards and with the maximum effect.

In House Microsoft Excel 2003 Courses across the UK

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

[ Close ]

Activia Home page

 Home

Activia courses

 Courses

Activia prices

 Prices

Course dates

 Dates

Activia locations

 Locations

Private Individuals

 Private
 Individuals

Let's talk about quality assured, flexible Microsoft Excel 2003 Courses.
Call Activia to discuss your requirements for MS Excel 2003 Training Course.