Microsoft Courses > Microsoft Excel 2002 Level 1 Training Course
Microsoft Excel 2002 Level 1 Course Outline - this course is no longer scheduled to run. Please refer to schedule for current course titles.
Course Description
Excel 2002 Level 1, is the first course in a series. This course will give you the skills to create, edit, format, and print basic worksheets and charts in Excel.
You will create basic worksheets and charts.
This course is designed for persons desiring to prepare to be a certified Microsoft Office User Specialist (MOUS) in Excel, and who already have knowledge of Microsoft Windows 98 or above operating system, and desire to gain the skills necessary to create, edit, format, and print basic worksheets and charts in Excel.
Course pre-requisites:
A good general understanding of PC Skills. Basic awareness of the Microsoft Office Application package.
This course is rated as a Fundamentals Course, suitable for novice computer users and beginners.
Topics covered on the 2 day Microsoft Excel 2002 Level 1 course
Getting Started
- Identify What You Can Do with Excel
- Enter Data in a Worksheet
- Edit Data
- Change the Appearance of Data
- Save a Workbook
- Obtain Help
Editing Your Worksheet
- Moving Data to Other Cells
- Copy Data to Other Cells
- Fill Cells with a Series of Data
- Insert and Delete Rows and Columns
- Undo and Redo an Entry
- Find and Replace Numbers
- Enter Data in a Range
- Verify Data in a Range
Performing Calculations
- Sum a Range of Data
- Use a Built-in Function
- Copy a Formula
- Create an Absolute Reference
Formatting
- Specify Number Formats
- Create a Custom Number Format
- Change Font Size and Type
- Apply Styles
- Add Borders and Color to Cells
- Find and Replace Formats
- Change Column Width and Row Height
- Align Cell Contents
- Merge and Center Cells
- Apply an AutoFormat
Working with Multiple Worksheets
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Copy Worksheets
- Change the Number of Worksheets
Creating and Modifying Charts
- Create a Chart
- Modify Chart Items
- Format a Chart
- Change the Chart Type
Setting Page Display and Printing Options
- Freeze Rows and Columns
- Set Print Title
- Set Page Margins
- Create a Header and Footer
- Change Page Orientation
- Insert and Remove Page Breaks
- Print a Range
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
| October 2008 |
November 2008 |
December 2008 |
| - | - | - |
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 2002 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
|