Sterling Computer Courses

Microsoft Excel 2000 - Level 2

Duration: Approx. 4 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 such Microsoft Excel 2000 features as working with lists, databases, and functions; formatting and linking worksheets; and using 3-D references and Microsoft Map. Selected areas of instruction include using AutoCorrect and AutoFormat; understanding, using, and customizing templates; and working with data maps. Students will also learn how to use Excel and the Web to save and work with files as Web pages.

Learn To:

This course covers the following topics:

Selecting Cells

Enter text, dates, and numbers

Edit cell content

Go to a specific cell

Use Find and Replace

Create hyperlinks

Use Save

Use Save As (different name, location, format)

Locate and open an existing workbook

Create a folder

Use templates to create a new workbook

Save a worksheet/workbook as a Web Page

Send a workbook via email

Use the Format Painter

Apply autoformat

Rotate text and change indents

Define, apply, and remove a style

Use Web Page Preview

Insert and remove a page break

Hide and unhide rows and columns

Freeze and unfreeze rows and columns

Move between worksheets in a workbook

Rename a worksheet

Insert and Delete worksheets

Move and copy worksheets

Link worksheets & consolidate data using 3D References

Use Paste Function to insert a function

Use date functions (NOW and DATE)

Use financial functions (FV and PMT)

Use logical functions (IF)

Insert, move, and delete an object (picture)

Create and modify lines and objects

Objectives:

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

Use lists, databases, and AutoCorrect

Work with paste, logical, financial, and date functions

Link worksheets

Save files as Web pages

Work with data maps

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