Sterling Computer Courses

Microsoft Excel 2000 - Level 1

Duration: Approx. 5 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 familiarizes students with the basic features of Microsoft Excel 2000, including entering text and formulas, moving data, formatting worksheet appearance, and manipulating charts. Beginning with opening a workbook, students will progress to using the Office Clipboard to cut, copy, and paste items. Selected topics include understanding formulas and functions, working with columns and rows, using absolute references, and printing worksheets.

Learn To:

This course covers the following topics:

Looking At Excel

Selecting Cells

Use Undo and Redo

Clear cell content

Enter text, dates, and numbers

Edit cell content

Go to a specific cell

Insert and delete selected cells

Cut, copy, paste, paste special and move selected cells, use the Office Clipboard

Clear cell formats

Work with series (AutoFill)

Use Save

Locate and open an existing workbook

Use the Office Assistant

Apply font styles (typeface, size, color and styles)

Apply number formats (currency, percent, dates, comma)

Modify size of rows and columns

Modify alignment of cell content

Adjust the decimal place

Use the Format Painter

Apply cell borders and shading

Merging cells

Preview and print worksheets & workbooks

Print a selection

Change page orientation and scaling

Set page margins and centering

Set print, and clear a print area

Set up headers and footers

Set print titles and options (gridlines, print quality, row & column headings)

Insert and delete rows and columns

Change the zoom setting

Move between worksheets in a workbook

Check spelling

Enter a range within a formula by dragging

Enter formulas in a cell and using the formula bar

Revise formulas

Use references (absolute and relative)

Use AutoSum

Use Paste Function to insert a function

Use basic functions (AVERAGE, SUM, COUNT, MIN, MAX)

Enter functions using the formula palette

Preview and print charts

Use chart wizard to create a chart

Modify charts

Objectives:

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

Enter and edit data and formulas

Cut, copy, paste, and use fills

Understand absolute and relative cell references

Create and modify charts

Format and print spreadsheets and charts

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.

Existing customer username (e.g.C4U9283479)

Related Links:

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 Sterling Consultancy

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