02 4967 5631

0416 056 759

Microsoft® Excel Course Descriptions

Excel Introductory

Excel Intermediate

Excel Advanced

Excel Introductory will give you the essentials of spread sheeting, which will enable you to create functional spreadsheets.

At the end of the course, you should be able to:

  • open and navigate within workbooks and worksheets
  • work with ranges
  • perform calculations with formulas and functions
  • copy and paste data in Excel
  • use formula cell referencing for more complex formulas
  • format worksheets
  • change worksheet page setup
  • print workbook data
  • create effective charts in Microsoft Excel.

This course covers formulas and function techniques, more intricate formatting, using intricate charting features, and working more effectively with existing worksheets and workbooks.

At the end of the course, you should be able to:

  • use the fill operations available
  • work with logical functions in Excel
  • use a range of formula techniques
  • apply a range of number formatting
  • apply conditional formatting
  • apply more advanced page setup
  • use a range of find and replace techniques
  • sort and filter data in a list in a worksheet
  •  enhance charts.

Excel Advanced will show you how to create lookup functions, set Excel options, enhance charts, protect worksheet data, and perform advanced data operations.

At the end of the course, you should be able to:

  • use a range of lookup functions
  • customise the formatting of charts in Excel
  • use labels and names
  • protect data in worksheets and workbooks
  • create summaries  using subtotals
  • link data within worksheets and workbooks
  • use Data Consolidation feature to combine data from several workbooks into one
  • create PivotTable reports
  • create  a PivotChart
  • use Goal Seek
  • use Solver
  • create recorded macros in Excel.

Versions:  2007 * 2010 * 2013 * 2016

Duration: 7 hours

Cost: 490.00

Versions: 2007 * 2010 * 2013 * 2016

Duration: 7 hours

Cost: 490.00

Versions: 2007 * 2010 * 2013 * 2016

Duration: 7 hours

Cost: 560.00

Find out more

Find out more

Find out more