[X]
Activia Training on LinkedIn
Activia Training on Twitter
Activia Training on FaceBook
The Activia Training Blog
Excel 2003 Training Courses Home               Courses             Prices             Dates             Tools             About Us             About You             News / Blog             Contact            

Excel 2003 Training Courses

Microsoft Excel 2003 for Accounting: Introduction

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 !
Excel 2003 Training 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
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 Introduction training course focuses on the basic functionality of Excel for accounting, including formatting and structuring worksheets, using workbooks, and an introduction to functions and formulas. 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 2003 interface would also be an advantage.

Course Outline

Introduction and Course Overview
Excel Fundamentals
Beginning Excel: • The Standard Toolbar  • The Formatting Toolbar  • Working with Excel Menus  • Exploring Task Panes  • Excel Short-cut Keys 
Explore your Workbook: • Switching Worksheets  • The Active Cell  • Selecting Cells  • Exploring a Worksheet  • The Zoom Feature 
Working with Excel: • Columns, Rows, Cells, and Ranges  • Creating Worksheet Labels  • Entering and Deleting Data  • Printing your Worksheet 
Moving your Data: • Dragging and Dropping Cells  • How to Cut, Copy, and Paste Cells  • How to Cut, Copy, and Paste Multiple Cells and Items  • How to Use Paste Special  • How to Insert and Delete Cells, Rows, and Columns  • Using Undo, Redo, and Repeat 
Modifying Cells and Data: • Changing the Size of Rows or Columns  • Working with the Formatting Toolbar  • Adjusting Cell Alignment  • Rotating Text  • Creating Custom Number and Date Formats 
Formatting, Toolbars and Charts
Basic Excel Features: • AutoFill  • What is AutoSum?  • AutoComplete  • Working with Basic Formulas 
Cell Formatting: • Conditional Formatting  • The Format Painter  • AutoFormat  • Cell Merging and AutoFit  • Find and Replace Formatting 
Modifying Excel’s Toolbars: • Hiding Toolbars  • Showing Toolbars  • Moving Toolbars  • Customizing Toolbars 
Working with Charts: • Creating a Chart  • Formatting a Chart  • Manipulating a Chart  • Enhancing a Chart with Drawing Tools  • Enhancing your Chart with Titles and Tables 
Working with Charts and Data: • Changing the Type of Chart  • Changing the Source Data  • Creating 3-D Charts  • Working with the Chart Axes and Data Series  • Making Custom Charts 
Using Workbooks
Organizing your Workbook: • Inserting and Removing Worksheets  • Renaming, Moving, and Colour-Coding Worksheets  • How to Split and Freeze a Window  • Using Multiple Workbooks and Windows  • Using a Watch Window  • Creating a Custom View 
Printing a Workbook: • Choosing a Print Area  • Setting up Page Breaks  • Choosing Paper Size and Changing Print Scale  • Adding Print Titles and Gridlines 
Workbooks, Worksheets and Templates: • Linking Workbooks  • Consolidating Workbooks  • Combining Worksheets  • Protecting Worksheets  • Using Templates 
Introduction to Functions and Formulas
Using Formulas in Excel: • Understanding Relative and Absolute Cell References  • Practice – Relative Cell References  • Practice – Absolute Cell References  • Relative and Absolute Practice 
Using Formulas in Excel: • Using Formulas With Multiple Cell References  • Using Formulas across Worksheets  • Working across Worksheets Practice 
Using Formulas in Excel: • The Formula Auditing Bar  • Fixing Formula Errors  • Displaying And Printing Formulas 
xploring Excel Functions: • What Are Functions?  • Finding the Right Function  • Some Useful And Simple Functions  • Working across Worksheets Practice 
Using Formulas in Excel: • The Formula Auditing Bar  • Fixing Formula Errors  • Displaying And Printing Formulas 
xploring Excel Functions: • What Are Functions?  • Finding the Right Function  • Some Useful And Simple Functions 

More Information

Prices for
Printer-friendly course content for Microsoft Excel 2003 for Accounting: Introduction

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:

Quality Assured Training

Click for more about our quality assured training.

Quick Course Finder

With truly hundreds of training courses to choose from, we have a Quick Course Finder that will help you to find the subject area and course you need.

Just click on any heading (in black) or section
(in blue) to go straight to where you need to be.

Click to use our Quick Course Finder

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
[ Close ]

Why Activia for Excel 2003 Training Courses ?

Excel 2003 Training Courses in London, Birmingham, Manchester, Leeds, Newcastle, Bristol and the South East

Activia should be your first choice for training for Excel 2003 in the UK.   We provide you with a full range of classes for Introduction to Microsoft Excel 2003 Training.
If you are looking for courses for MS Excel 2003, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Excel 2003 Training Courses at fiercely competitive prices.

Introduction to Microsoft Excel 2003 Training

If your requirement is training for Microsoft Excel 2003, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for classes for 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, Manchester, Leeds, Newcastle, Bristol, Berkshire, Buckinghamshire, Surrey and UK wide

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

Excel 2003 Training Courses in the City of London

Serving the City in Bank and Aldgate, and Canary Wharf from our London Bridge (SE1) centre.

Excel 2003 Training Courses across London

Across West and South West London, in Hammersmith, Baker Street and London Victoria.

Introduction to Microsoft Excel 2003 Training in the centre of Bristol

Serving South West England, covering Bristol, Avon and Bath and Radstock in Somerset as well as Clevedon and Chepstow.

Excel 2003 Training Courses in Birmingham City Centre

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

Introduction to Microsoft Excel 2003 Training in Leeds

Serving Yorkshire and the North of England, covering Leeds, Bradford and Harrogate as well as Halifax, Wakefield and Castleford.

Excel 2003 Training Courses in Manchester

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

Excel 2003 Training Courses in Reading

Serving Berkshire and the Thames Valley, covering Reading, Theale and Newbury as well as Henley and South Oxfordshire.

Excel 2003 Training Courses in Bracknell

Serving Berkshire and the Thames Valley, covering Bracknell, Wokingham and Ascot as well as Crowthrone, Camberley and Woking.

Introduction to Microsoft Excel 2003 Training in Slough

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

Introduction to Microsoft Excel 2003 Training in Milton Keynes

Serving Buckinghamshire, covering Milton Keynes, Aylesbury and Buckingham, as well as Luton, Bedford, Stevenage, St Albans and Welwyn Garden City.

Excel 2003 Training Courses in Newcastle Upon Tyne

Serving Tyneside, also Sunderland and Gateshead, as well as North Shields and South Shields, and Whitley Bay.
Our experienced, high quality trainers will deliver your training to the highest standards and with the maximum effect.

In House Excel 2003 Training Courses across the UK

For in house delivery of Introduction to Microsoft Excel 2003 Training, we have an established national UK network of trainers, as well as fifteen centres in London, Birmingham, Manchester, Leeds, Newcastle, Bristol, Slough, Reading, Bracknell and Milton Keynes. So you can be sure that your training for Excel 2003 will be delivered in a quality assured and cost effective manner.   For in-house training for Microsoft Excel 2003, you need look no further than Activia.


Click for more about Microsoft Excel 2003 training courses UK from Activia
[ Close ]

Quality Assurance

Regus House
268 Bath Road
Slough
SL1 4DX
Sales:   0845 230 6150
Service:   0845 230 6159
Accounts:   0845 230 6150
Training centres in     London     Birmingham     Bristol     Berkshire     Buckinghamshire     Manchester     Leeds     Newcastle
Why Activia?