Excel 2003 Level 1
 Course Outline

DURATION 1 day
PREREQUISITES Basic PC knowledge required
DESCRIPTION If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features.  Even if you have been using Excel for a little while, you will find the time saving features covered in this course useful!
COURSE DATES Special: Four Days of MS Office training for the price of Three!

Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Weekday Mon, 13-Feb-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 15-Feb-12 and Thu, 16-Feb-12 18:30 - 21:30 £200.00 +VAT
Weekday Wed, 29-Feb-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 17-Mar-12 10:00 - 16:30 £200.00 +VAT
Weekday Thu, 12-Apr-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 16-Apr-12 and Tue, 17-Apr-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 1-May-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 16-May-12 and Thu, 17-May-12 18:30 - 21:30 £200.00 +VAT
Weekday Wed, 13-Jun-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 16-Jun-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 2-Jul-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 16-Jul-12 and Tue, 17-Jul-12 18:30 - 21:30 £200.00 +VAT
Weekday Wed, 1-Aug-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 15-Aug-12 and Thu, 16-Aug-12 18:30 - 21:30 £200.00 +VAT
Weekday Fri, 7-Sep-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 15-Sep-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 1-Oct-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 15-Oct-12 and Tue, 16-Oct-12 18:30 - 21:30 £200.00 +VAT
Weekday Thu, 1-Nov-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 5-Nov-12 and Tue, 6-Nov-12 18:30 - 21:30 £200.00 +VAT
Weekday Thu, 13-Dec-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 15-Dec-12 10:00 - 16:30 £200.00 +VAT
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £375.00 +VAT

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

INTRODUCTION TO MICROSOFT EXCEL

  • What Is Excel?

  • Excel File Types

  • Excel Environment

  • Toolbars

  • Office Assistant

WORKBOOKS AND WORKSHEETS

  • Creating And Opening Workbooks

  • Working With Workbooks

  • Working With Worksheets

  • Working With Cells

  • Navigating Within A Worksheet

  • Navigating The Workbook

  • Understanding Dates

  • Inserting and deleting rows, columns, cells

  • Cutting, Copying, And Pasting

  • Using Find And Replace

  • Using Undo And Redo

  • Spell Check

FORMULAS AND FUNCTIONS
  • Creating Maths formulas
  • Using Paste Function
  • Entering Functions
    • Sum, count, max, min, average
  • Percentages
  • Using the F4 key to lock cell references (Absolute referencing)
  • Creating Named Ranges to use in formulas

FORMATTING AND CUSTOMISING DATA

  • Selecting Items In Excel

  • Formatting Text

  • Formatting Numbers

  • Manipulating Data

  • Formatting Columns And Rows

  • Formatting With Colours And Patterns

  • Adding And Editing Borders

  • Using AutoFormat

  • Using the format painter

PRINTING

  • Using Page Setup

  • Margins

  • Headers And Footers

  • Printing A Spreadsheet

CHARTS

  • Chart Wizard

  • Chart Toolbar

  • Working With Charts

  • Formatting the Chart