Sterling Computer Courses

Microsoft Excel 2002 - Level 2

Duration: Approx. 6 hours.

This product is an online product and is a Single user, 1 Year licence.

Screenshots:

(click on a screenshot for a bigger picture) Images are representative of this product.

Overview:

This course introduces students to an additional set of basic spreadsheet features and acquaints students with the tools used in Microsoft Excel 2002. Students will learn to customize workbooks by changing worksheet attributes, use lists to store and organize worksheet data, use functions in financial and logical formulas, and format worksheets using AutoFormat and predefined styles. In addition, students will learn about objects and their role in worksheet development, 3-D references linking worksheets and workbooks, how to integrate workbooks and the Web, and how to use templates to create new worksheets.

Learn To:

This course covers the following topics:

Rename Worksheets

Change Worksheet Tab Colors

Select And Move Sets Of Worksheets

Copy Worksheets

Insert And Delete Worksheets

Create Named Ranges

Use Save As

Learn About Database Features

Find And Replace Cell Contents

Freeze And Unfreeze Rows

Freeze And Unfreeze Columns

Hide And Unhide Rows And Columns

Sort Lists In Descending Order

Sort Lists In Ascending Order

Understand Filters

Use AutoFilter

Understand Inserting Functions

Explore Logical Functions

Use The IF Function

Use The OR Function

Learn About Financial Functions

Use The FV Function

Use The PMT Function

Use The NOW Function

Understand AutoFormatting

Apply AutoFormats

Modify AutoFormats

Define Styles

Apply And Remove Styles

Indent Text

Rotate Text

Insert Page Breaks

Remove Page Breaks

Find And Replace Cell Formats

Understand Inserting Objects

Insert Graphics

Move And Delete Graphics

Create And Modify Graphics

Add Comments

Edit And Remove Comments

Understand 3-D References

Link Worksheets Using 3-D References

Link Workbooks Using 3-D References

Look At The Web

Understand Hyperlinks

Create And Edit Hyperlinks

Use Web Page Preview

Save Worksheets As Web Pages

Save Workbooks As Web Pages

E-mail Workbooks As Attachments

Understand Web Discussions

Explore Templates

Create Workbooks Based On Templates

Objectives:

Once you have completed this course, you will be able to:

Customize workbooks

Format worksheets

Work with objects

Use 3-D references

Use templates

Price:

~~Normal Price: £80.00 (excl. VAT)~~

Special Offer Price: £50.00 (excl. VAT)

YOU SAVE: £30.00 (37.5%)

To purchase this online course, click the "Buy Now" button below. If you have bought a course from us before please enter your username before clicking "Buy Now". If you are a new customer, leave this field blank.

General:

Home Course Log-in Instructions Contact Us

Online Course Categories:

PC Basics Microsoft Office Microsoft Outlook Misc.

Sister Sites:

Associated Training Corporate Site Associated Training Associated E-Training Sterling Safety Training Sterling Financial Training UK Business Training Sterling Languages Sales Training Courses UK Management Training Courses UK Communication Skills Training Media First

To contact us, please e-mail: contact@sterlingcomputercourses.co.uk

Sterling Computer Courses.co.uk is a division of:

Sterling Consultancy (UK) Ltd
10 Wheatcroft Business Park
Landmere Lane, Edwalton
Nottingham
NG12 4DG

Telephone: 0115 984 9940 | Fax: 0115 921 5352