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 Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.

Weekend Sat, 4-Sep-10 10:00 - 16:30 £125
Weekday Tue, 7-Sep-10 09:30 - 16:30 £125
Weekday Thu, 7-Oct-10 09:30 - 16:30 £125
Weekend Sat, 16-Oct-10 10:00 - 16:30 £125
Weekday Fri, 5-Nov-10 09:30 - 16:30 £125
Evening Mon, 15-Nov-10 and Tue, 16-Nov-10 18:30 - 21:30 £125
Weekday Tue, 7-Dec-10 09:30 - 16:30 £125
Weekend Sat, 11-Dec-10 10:00 - 16:30 £125
Weekday Tue, 4-Jan-11 09:30 - 16:30 £125
Evening Mon, 17-Jan-11 and Tue, 18-Jan-11 18:30 - 21:30 £125
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £375
 

 

 

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