Extend your Excel knowledge into some of the more specialized and advanced capabilities. You will customize your workbook to include cell restrictions, custom number formatting. Learn how to define ranges, create templates, audit a worksheet, subtotal and outline a worksheet, and collaborate with others using shared workbooks.

Prerequisites

Microsoft Excel 2003 - Part 2 or equivalent knowledge. 

---

Objectives

After completing this course, students will be able to:

• Find and replace a specific entry in a worksheet
• Create and apply a style
• Use options in the Paste Special dialog box
• Use alignment options in the Format Cells dialog box
• Enter an absolute cell reference into a formula
• Use the IF function
• Use the PMT and FV functions
• Use the DATE and NOW functions
• Plot a chart
• Modify and enhance a chart
• Sort the records of a list
• Filter the records of a list
• Insert a new worksheet in a workbook
• Delete a worksheet from a workbook
• Enter a formula to link related worksheets in a workbook
• Format multiple worksheets in one operation
• Split the Workbook window into panes
• Hide rows and columns of a worksheet
• Change the zoom level for a worksheet
• Insert a picture into a worksheet
• Insert a diagram into a worksheet

---

Course Materials

The courseware (book) and student data files are included with the class. The courseware is Microsoft Approved Courseware. The courseware has been reviewed and approved to satisfy Microsoft Office Specialist certification exam standards.

[Part 1]  [Part 2]  [Part 3]  [Part 4]

Top of Page