Excel 2003 Level 1
| Date |
Location |
Duration |
Cost |
| 24 Aug 2010 (Tue) | Newcastle | 1 | £ 165 |
| 22 Sep 2010 (Wed) | Washington | 1 | £ 165 |
| 23 Sep 2010 (Thu) | Blyth | 1 | £ 165 |
| 13 Oct 2010 (Wed) | Washington | 1 | £ 165 |
| 08 Nov 2010 (Mon) | Newcastle | 1 | £ 165 |
| 01 Dec 2010 (Wed) | Washington | 1 | £ 165 |
| 13 Jan 2011 (Thu) | Washington | 1 | £ 165 |
| 25 Feb 2011 (Fri) | Washington | 1 | £ 165 |
| 04 Mar 2011 (Fri) | Washington | 1 | £ 165 |
| 06 Apr 2011 (Wed) | Newcastle | 1 | £ 165 |
| 21 Apr 2011 (Thu) | Blyth | 1 | £ 165 |
| 17 May 2011 (Tue) | Washington | 1 | £ 165 |
| 24 Jun 2011 (Fri) | Washington | 1 | £ 165 |
Please contact us to discuss private course dates and locations |
What is Excel?
Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.
Course Overview
This course will enable the delegate to gain a good general understanding of the main features of Excel, giving them the ability to produce their own standard spreadsheets, create their own formulae and format and print spreadsheets.
Prerequisites
- Previous use of a keyboard and mouse is assumed for this course. Delegates should have working knowledge of using a Windows based PC or completed the Introduction to Windows course. Delegates should be able to arrange, size and switch between Windows.
Objectives
Follow on Courses
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
Email Us 
Print