Activia for Microsoft Excel 2003 For Accounting (l1)
speedy course booking with Activia Training
Bookings and Enquiries:                   0845 230 6150
Customer Service:                            0845 230 6159
We're here to help!     Click for a  FREE CALLBACK

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 !

To find out more, call us on 0845 230 6150
We'd like to discuss how we can give you the best service you will find.

Introduction to Excel 2003 Training Courses from Activia

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
Microsoft Excel 2003 for Accounting: Introduction Training Courses from Activia

Feedback from Delegates on our Microsoft Excel 2003 for Accounting: Introduction Courses


Average Review 5.0/5 based on 1 reviews.

"Lara was very helpful and presented the course well. She responded positively to my requirements and was knowledgeable and professional."     Deirdre Porter     Mar 7 2013    

Microsoft Excel 2003 for Accounting: Introduction Training Courses from Activia

Excel 2003 Training Courses from Activia

We can provide training for Excel 2003 at any of our seventeen centres UK wide, or we can come to your offices.
We have been training since 1995 with a philosophy of high quality, flexible and cost effective provision, so you can be confident that we have the expertise, and the experience, to give all you need with courses for MS Excel 2003.
Call us now on 0845 230 6150 or request a free callback.

Quality Assurance