Activia for Microsoft Excel 2003 For Accounting (l1)
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 2003 Training Courses from Activia

Excel 2003 Training Courses From Activia

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 !
Introduction to 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 outline 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:

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 ]

Locations for Excel 2003 Training 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 for Microsoft Excel 2003 will get the results you need, at the prices you want.

Activia centres for Microsoft Excel 2003 Training

With seventeen fully equipped training centres , Activia should be your first choice for training for Excel 2003 wherever you are in the UK.
We provide Microsoft Excel 2003 Training 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 2003 Training Courses from Activia across the UK

For in house delivery of Microsoft Excel 2003 Training, you can expect the same standard of training and service for your courses for MS Excel 2003 as you get at our centres, conveniently delivered at your offices.
To book your in-house classes 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