Course Catalog

Intermediate to Excel 2002

Topics

• Introduction
• Getting started
• Intermediate editing and formatting techniques
• finding a specific entry in a worksheet
• finding and replacing a specific entry in a worksheet
• creating a new style/applying a style
• 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
• 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
• including non-contiguous data ranges in a chart, plotting a pie chart
• adding new data to an existing chart
• Working with lists
• what is a list ? filtering a list
• specifying a criteria range in a filter operation
• 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 for a worksheet
• Adding drawings and pictures to a workbook
• creating a drawing on a worksheet
• inserting a picture into a worksheet
• Additional intermediate Excel features
• using an Excel template to create a workbook
• previewing and saving Excel data as a web page
• inserting a hyperlink into a worksheet
• inserting comments into a worksheet, creating a discussion
• Final case study

Course Length

For More Information

Other Excel 2002 Courses: