Microsoft Office 2016: Excel Essentials

View Classes

Learn to use Excel with our Microsoft Office 365 courses in Sydney.

Microsoft Excel will help you to solve simple or complex problems with confidence. In doing so, Excel learns your patterns, organising your data to save you time. With Microsoft Excel, you can create spreadsheets with ease from templates or on your own, and perform calculations with modern formulas.

Microsoft Excel 2016 has new charts and graphs that help you present your data in compelling ways, with formatting, sparklines, and tables to better understand your data. Easily create forecasts with just a click to predict trends.

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


After this course you should be able to:

  • 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 several 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

Ideal for

This course is ideal for anyone who has little or no knowledge of spreadsheets or Microsoft Excel. Basic knowledge of the Windows computer operating system is required.

Materials provided

  • Comprehensive course notes

Other Information

This short course is conducted using Microsoft Office 2016 in a Microsoft Windows environment. Due to the comparative complexity of each application in the Microsoft Office Suite, the time spent on each application will not necessarily be equal and will be guided by student needs on the day.


Microsoft Office 2016: Excel Essentials

<p><strong>Learn to use Excel with our <a href="">Microsoft Office 365 courses</a> in Sydney.</

$149 Limited GST free / $119.20 / $134.10

If there isn't a class to suit you, please join our waitlist and we will notify you when we have places available. Join Waitlist

If there isn't a class to suit you, please join our waitlist and we will notify you when we have places available. Join Waitlist

Course testimonials:

  • said: Knowledgeable Tudor, great venue, parking made it very easy.

  • said: Very good interaction. A number of informal tips.

  • said: 4 Stars!

Share this course