Microsoft® Excel® Intermediate - course outline

Microsoft Excel is a widely used, powerful spreadsheet package. The primary objective of this one-day Intermediate course is to broaden your knowledge of Excel. This practical course allows you to appreciate the full potential of Excel. You will be encouraged to discuss your individual requirements relevant to your work. By the end of the course you will be competent with the following skills:

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 options in the paste special dialog box

using alignment options in the format cells dialog box

Using absolute cell references

entering an absolute column and absolute row cell reference into a formula

entering an absolute column or absolute row cell reference into a formula

Using logical functions

using the IF function, nesting IF functions

using the AND and OR functions

Using date/time functions

using the DATE function, using the NOW function

Creating a chart

what is a chart? plotting a chart

modifying and enhancing a chart

previewing and printing a chart

including non-contiguous data ranges in a chart

Working with a list

what is a list? sorting the records of a list

filtering the records of a list

specifying a range of values as criteria for a filter operation

Linking worksheets within a workbook

renaming worksheets in a workbook

moving the cell pointer from one worksheet to another

inserting and deleting worksheets

entering a formula to link related worksheets in a workbook

formatting multiple worksheets in one operation

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

opening a new workbook / arranging open workbook windows

changing the zoom level of a worksheet

Additional intermediate Excel features

using an Excel template to create a workbook

hiding an entire worksheet and an entire workbook

inserting a hyperlink into a worksheet, using the research feature

inserting comments into a worksheet

This course outline is a guide. All our courses can be tailored to customer requirements.

Target audience
This course is aimed at anyone who has some experience of Excel and wishes to examine some of the more advanced features.

Assumed knowledge
Delegates should be familiar with the basics of Excel, either from attending our Introduction Course or knowledge gained from their own experience.