Excel 97: Modifying Worksheets

Synopsis
Excel 97: Modifying Worksheets presents the skills that enable a new user to modify format and print Excel spreadsheets.

Audience
This course is for beginning level Microsoft Excel for Windows users. It will also prepare you for the Microsoft Office User Specialist Excel 97 Proficient exam.

Time
9 hours

Product Code: XCLC02

After completing Excel 97: Modifying Worksheets the user should be able to:

Move and copy data

Change the format of numbers and text

Create and use named ranges

Print all or part of a worksheet

Use Excel toolbars

Sort data

Moving and Copying Data
Inserting and deleting rows columns and cells
Moving cell data
Copying cell data
Entering absolute cell references

Formatting a Worksheet
Changing number formatting
Changing text formatting
Changing column width and row height

Working with Named Ranges
Naming a range of cells
Using names in formulas
Selecting named ranges

Printing a Worksheet
Checking the spelling of a worksheet
Using page setup options
Printing a whole worksheet
Printing a portion of a worksheet

Using Toolbars
Displaying additional toolbars
Tearing off a toolbar option palette
Creating a custom toolbar

Sorting Data
Sorting a list by the values in a column
Sorting by ascending and descending order

This course is distributed with

Exercises with supplied files that allow users to practice in Excel 97

A file containing the text of the exercises

Simulations that allow users to practice course skills even if they don't have access to the Excel 97 product

A Excel 97 Glossary

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.