Excel Essentials - Organise and Calculate Your Data St George & Sutherland Community College

Excel Essentials - Organise and Calculate Your Data

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Prior knowledge of PC’s assumed.

In this course you will learn:

  • Navigate your way around Microsoft Excel 2016
  • Create and work with a new workbook
  • Open and navigate within workbooks and worksheets
  • Make changes to data in a workbook
  • Understand and work with ranges in a worksheet
  • Copy and paste data in Excel
  • Use the fill operations available to fill a data series
  • Move the contents of cells and ranges within and between workbooks
  • Understand, create and work with formulas and functions
  • Understand and use formula cell referencing
  • Use font formatting techniques
  • Align the contents of cells in a number of ways
  • Understand and use the number formatting features in Excel
  • Format rows and columns in a worksheet
  • Work with elements that make up the structure of a worksheet
  • Sort data in a list in a worksheet
  • Filter data in a table
  • Print your workbook data
  • Create effective charts in Microsoft Excel
  • Obtain help for Excel whenever you need it
  • Understand points to consider to avoid problems in your worksheets

What to bring:

  • Pen
  • Paper

The Next Step:

Keen to learn more? We suggest Excel Intermediate.

Other Information:

  • To ensure resources are ready for you at the start of your course, we ask you ideally enrol at least one week before the course commences.
  • All courses need a minimum number of students to run ("we try our hardest to get those") . If your course does not have enough students it will be cancelled before the commencement and you will be informed.

This course has no current classes. Please the waiting list.