This course expands upon the skills you learned in the Excel Part 1 class. Learn to use additional functions that include financial, conditional and date functions. Also learn to create and modify charts, filter lists, work with related worksheets, create styles and work with templates.

Prerequisites

Microsoft Excel 2003 - Part 1 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