Microsoft Excel Introduction - course outline

Microsoft Excel is a widely used, powerful spreadsheet package. The primary objective of this one-day Introduction course is to introduce you to the basic operations of Excel. This extremely practical course will provide hands-on experience of many of the features found in this product. By the end of the course you will be competent with the following skills:

Getting started

  • what is Excel?, starting Excel, the Excel application window
  • using the Excel menu system, using the Microsoft Office Button
  • using the Quick Access Toolbar
  • displaying help information
  • exiting from Excel

Modifying an existing worksheet

  • resetting the working folder
  • moving the cell pointer, changing data in a worksheet
  • reversing an edit operation, saving a workbook
  • adding data to a worksheet
  • entering a formula into a worksheet
  • adjusting column width in a worksheet
  • adjusting row height in a worksheet
  • printing a worksheet

Building a new worksheet

  • opening a new workbook
  • using the spelling checker

Editing a worksheet

  • working in edit mode
  • selecting ranges in a worksheet
  • using autofill
  • copying cells, moving cells, clearing cells
  • using autosum
  • inserting and deleting rows and columns
  • inserting and deleting a range of cells

Formatting a worksheet

  • resetting the alignment of cell entries
  • resetting font options for cell entries
  • resetting the number format of cell entries
  • adding borders and shading to a worksheet
  • using autoformat

Enhancing a worksheet printout

  • changing the page setup for a worksheet
  • previewing a worksheet
  • inserting a manual page break into a worksheet
  • printing titles
  • printing selected worksheet entries

Using Excel functions

  • what is a function? using the SUM function
  • using the AVERAGE function, using the MAX and MIN functions
  • using the COUNT function, using the insert function button

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

Target audience
This course is aimed at new or recent users of Excel.

Assumed knowledge
Delegates should be familiar with the Windows operating system, either from attending a Windows Introduction or Getting Started Course or knowledge gained from their own experience. No knowledge of Excel is expected.