Excel 2000 Core Level
Overall Aim:
This course will cover all of the listed examination topics for the MOUS Core Level for Excel 2000.
Target Group:
Any PC user who wishes to attain MOUS certification, or who wish to develop basic spreadsheet skills using Microsoft Excel 2000.
Pre-requisites:
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