Microsoft Excel Intermediate/Advanced - course outline

Microsoft Excel is a widely used, powerful spreadsheet package. The primary objective of this one-day Intermediate/Advanced 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:

Editing and formatting techniques

  • Finding and replacing specific formatting in a worksheet
  • Using options in the paste special dialog box
  • Applying conditional formatting to a worksheet
  • Inserting a hyperlink into a worksheet
  • Inserting comments into a worksheet

Ensure accurate data entry using data validation

  • Restricting cell entries to specific numbers, dates or times
  • Restricting cell entries to specific entries in a list

Working with a Table

  • What is a Table
  • Dos and don'ts when working with Tables
  • Sorting the records of a Table
  • Filtering the records of a Table
  • Top tips when working with Tables

Summarising data using PivotTables

  • Creating a PivotTable report
  • Resetting the summary function in a PivotTable report
  • Creating a PivotChart report
  • Top tips when working with PivotTables

Using absolute cell references

  • Avoid the pitfalls of relative cell references using absolute cell references
  • Entering an absolute column and absolute row cell reference into a formula

Naming ranges

  • Defining a range name
  • Using a range name in a formula
  • Selecting a named range

Save time using Functions

  • Using the IF function, nesting IF functions
  • Using the AND and OR functions
  • Using the VLOOKUP function

Creating a chart

  • Plotting a chart
  • Modifying and enhancing a chart
  • Previewing and printing a chart
  • Including non-contiguous data ranges in a chart

Linking multiple worksheets and multiple workbooks

  • 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
  • Entering a formula to link multiple workbooks

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.