Microsoft Excel 2003 Level 1 Course
Course Description
You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Excel 2003 to manage, edit, and print data.
Course pre-requisites:
To ensure your success, we recommend you have a basic knowledge of how to use a computer, mouse (etc).
This course is rated as a Fundamentals Course, suitable for novice computer users and beginners.
Topics covered on the 2 day Microsoft Excel 2003 Level 1 course
Getting Started with Excel
- An Overview of Excel
- Navigate in Excel
- Select Data
- Enter Data
- Save a Workbook
- Obtain Help
Modifying a Worksheet
- Move and Copy Data Between Cells
- Fill Cells with Series of Data
- Edit Cell Data
- Insert and Delete Cells, Columns, and Rows
- Find, Replace, and Go To Cell Data
- Spell Check a Worksheet
Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Create an Absolute Reference
Formatting a Worksheet
- Change Font Size and Type
- Add Borders and Colour to Cells
- Change Column Width and Row Height
- Merge Cells
- Apply Number Formats
- Create a Custom Number Format
- Align Cell Contents
- Find and Replace Formats
- Apply an AutoFormat
- Apply Styles
Developing a Workbook
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
- Copy a Workbook
Printing Workbook Contents
- Set a Print Title
- Create a Header and a Footer
- Set Page Margins
- Change Page Orientation
- Insert and Remove Page Breaks
- Print a Range
Customizing Layout
- Split a Worksheet
- Arrange Worksheets
- Freeze and Unfreeze Rows and Columns
- Hide and Unhide Worksheets
|
(click button to view / download course outline in printer friendly format)
(may take a few seconds to load)
|
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Applications Training Course
Course Fee = £410 (excl.VAT)
Scheduled course dates
| May 2008 |
June 2008 |
July 2008 |
August 2008 |
September 2008 |
| 27-28 | 23-24 | 28-29 | 18-19 | 22-23 |
|
|
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
The Microsoft Excel 2003 Level 1 course qualifies for the PTR SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.
View SAVE IT Scheme Details
PTR Associates Limited
21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk
|
|
