Microsoft
Excel
Intermediate

COURSE OUTLINE

Home   Back   Disclaimer  

Introduction

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

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

Using financial functions

• using the PMT function, using the FV function
• setting up a financial analysis table

Using logical functions

• using the IF function, nesting IF functions

Using date/time functions

• using the DATE function, using the NOW function

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

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

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

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

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

Final case study

Home   Courses   Word   Excel   PowerPoint   Access   Outlook   Windows   Disclaimer