Excel 2003 Level 1

Objectives

Delegates will be able to:

Create a spreadsheet containing data. Navigate through the spreadsheet using keyboard shortcuts. Add a New Column and Rows and save the spreadsheet.
Create and format a spreadsheet using the main features of the Formatting toolbar.
Performing the following calculations on a range of numbers: addition, subtraction, multiplication and division.
Use the following 5 Functions on a range of numbers: Sum, Average, Count, Min, Max.
Follow on Courses

Excel Level 2
Excel Level 3
Excel Level 4
Training Options

Scheduled public courses at one of our training venues
Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
For further information please contact us on 0191 377 8377
What's Included

1 delegate per computer
Telephone and email support
Relaxed refreshment area at our training venues
Lunch and refreshments when training is delivered at our training venue
Comprehensive course manual and exercises
Course Content

Starting Excel
Opening Excel from the start menu and desktop
Exiting Excel
The Excel screen
Workbooks
Creating a new workbook
Creating a new workbook using a predefined solution
Saving a workbook
Opening a workbook already created
Closing a workbook
Screen options
Changing the view options for Excel
Moving toolbars
Zooming in and out
Viewing different toolbars
Entering information onto a worksheet
Entering text and numbers
Entering numbers as text
Inputting dates and times
Editing the contents of a cell
The fill handle
The undo/redo buttons
Navigating a worksheet
The goto command
The scroll bars
Using the Keyboard
Inserting & deleting columns & rows
Hiding and unhiding columns and rows
Adjusting column widths and row heights
Deleting columns and rows
Inserting columns and rows
Ranges
Highlighting the entire worksheet
Selecting an entire column and row
Selecting more than one range
Selecting a range of cells
Formatting a worksheet
Using merge and centre
Applying or deleting borders to a selection
Applying a date format to a cell or range
Changing the alignment of the contents of a cell
Changing the colour, size and style of a font
Adding a fill colour to a selection
Using autoformat
Using the format painter
Clearing cells (removing formats)
Applying formats using the keyboard
Performing calculations
Entering a simple formula in a cell
Order of operation
Displaying formulae on a worksheet
Using autosum
Other useful functions
Worksheets
Inserting another worksheet in the same workbook
Renaming a worksheet
Deleting a worksheet
Moving and copying a worksheet
Making copies of cell contents
Moving the contents of cells
Spelling and printing
Using the spell checker
Viewing a print preview
Printing the spreadsheet
Printing a section of a worksheet
Setting a print area
Clearing a print area