Microsoft Excel Getting Started - course outline

Microsoft Excel is a widely used, powerful spreadsheet package. The primary objective of this half day Getting Started course is to introduce you to the basic operations of Excel.

What's included

  • Handout containing exercises and files to practise what you've learned at your own pace in your own time.
  • A month support on the topics covered after the instructor-led training session.

By the end of the course you will be competent with the following skills:

Getting Started

  • what is Excel?
  • the Excel application window and ribbons
  • resetting the working folder

Modifying an existing worksheet

  • moving the cell pointer, changing data in a worksheet
  • reversing an edit operation, saving a workbook
  • finding and replacing a specific entry in a worksheet
  • adding data to a worksheet
  • entering a formula into a worksheet
  • adjusting column width in a worksheet

Building a new worksheet

  • plan before you build
  • opening a new workbook

Using worksheet shortcuts

  • using autofill
  • copying, moving and clearing cell entries
  • using autosum
  • inserting and deleting rows and columns
  • inserting and deleting a range of cells

Enhancing worksheet appearance

  • working in edit mode
  • adjusting row height in a worksheet, realigning cell entries
  • resetting the font of cell entries and numeric format of cell entries

Enhancing printed output

  • changing the page setup of a worksheet
  • previewing a worksheet
  • printing selected worksheet entries

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 Course or knowledge gained from their own experience. No knowledge of Excel is required.