Excel 2000: Introduction for Beginners (2 day)

Scheduled Dates Locations filtered. Show all UK course locations.

Course Overview

This course will cover all of the listed examination topics for Excel 2000.

Audience

Any PC user who wishes to attain MOUS certification, or who wish to develop basic spreadsheet skills using Microsoft Excel 2000.

Prerequisites

Delegates must have attended the Introduction to Windows course, or be proficient in the use of a personal computer running the Windows graphical environment.

Course Outline

Working with 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
• Use Find and Replace
• Clear cell formats

Work with series (AutoFill)

• Create hyperlinks

Working with Files

• 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 Office Assistant

Formatting Worksheets

• Apply font styles (typeface, size, colour 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 autoformat
• Apply cell borders and shading
• Merging cells
• Rotate text and change indents
• Define, apply, and remove a style

Page Setup and Printing

• Preview and print worksheets and workbooks
• Use Web Page Preview
• Print a selection
• Change page orientation and scaling
• Set page margins and centering
• Insert and remove a page break
• Set print, and clear a print area
• Set up headers and footers
• Set print titles and options (gridlines, print quality, row and column headings)

Working with Worksheets and Workbooks

• Insert and delete rows and columns
• Hide and unhide rows and columns
• Freeze and unfreeze rows and columns
• Change the zoom setting
• Move between worksheets in a workbook
• Check spelling
• Rename a worksheet
• Insert and Delete worksheets
• Move and copy worksheets
• Link worksheets and consolidate data using 3D References

Working with Formulas and Functions

• 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
• Use date functions (NOW and DATE)
• Use financial functions (FV and PMT)
• Use logical functions (IF)

Using Charts and Objects

• Preview and print charts
• Use chart wizard to create a chart
• Modify charts
• Insert, move, and delete an object (picture)
• Create and modify lines and objects

Follow On Courses

• Microsoft Excel 2000 Intermediate
• Microsoft Excel 2000 Advanced

Excel 2000: Introduction for Beginners (2 day) / MEX00-12