1. Introduction

2. Intermediate editing and formatting techniques
- finding a specific entry in a worksheet
- finding and replacing a specific entry in a worksheet
- creating and applying a new style, using a workbook template
- using alignment options in the format cells dialog box

3. Using absolute cell references
- entering an absolute column and row cell reference into a formula
- entering an absolute column or row cell reference into a formula

4. Using financial functions
- using the PMT function, using the FV function
- setting up a financial analysis table

5. Using logical functions
- using the IF function, nesting IF functions

6. Using date/time functions
- using the DATE function, using the NOW function

7. Creating a chart
- what is a chart ? plotting a basic chart
- modifying and enhancing a basic chart
- previewing and printing a chart
- plotting non-contiguous data ranges, plotting a pie chart
- adding new data to an existing chart

8. Linking worksheets within a workbook
- setting up related worksheets within a workbook
- moving the cell pointer from one worksheet to another
- copying data from one worksheet to another, editing the data
- entering a formula to link related worksheets
- formatting multiple worksheets in one operation
- moving and copying worksheets
- previewing and printing multiple worksheets in one operation

9. Controlling the worksheet display
- splitting the workbook window into panes, freezing window panes
- hiding rows and columns of a worksheet
- changing the zoom level of a worksheet

10. Using Excel Internet features
- accessing the world wide web from Excel
- linking an Excel workbook to a web page, saving Excel date as a web page

11. Additional intermediate Excel features
- using the paste special option, creating a drawing on a worksheet
- inserting a picture into a worksheet, sending Excel data via electronic mail

12. Final case study