Microsoft® Excel® Further Use - course outline

Microsoft Excel is a widely used, powerful spreadsheet package. The primary objective of this half-day Further Use course is to broaden your knowledge of Excel. This practical course allows you to appreciate the full potential of Excel. By the end of the course you will be competent with the following skills:

Using Excel functions

  • what is a function?
  • using the SUM, AVERAGE, MAX and MIN functions
  • using AUTOCALCULATE

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

Filtering and summarizing worksheet data

  • adding subtotals to a list
  • applying an advanced filter to a list

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
  • previewing and printing multiple worksheets in one operation

Linking multiple workbooks

  • entering a formula to link multiple workbooks
  • creating a workspace

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

Analyzing worksheet data

  • creating a pivottable report
  • resetting a summary function in a pivottable report

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 or Getting Started Course or knowledge gained from their own experience.