Start Excel-ing
Level 3

ACE304 Start Excel-ing

  • Course code

    ACE304

  • Locations and dates

    No start dates are currently available. Register to be informed when new dates are added.
  • Credits

    2

Develop spreadsheet skills using Excel to an intermediate level.

This course is available at our Marlborough and Nelson campuses.

You'll learn

  • How to produce computer spreadsheets that include inputting text and numbers, and formulae.
  • How to use a standard spreadsheet application that includes the formatting of a spreadsheet, the use of 'with absolute' and relative referencing.
  • How to link spreadsheet cells to Word Documents and other spreadsheet worksheets.
  • To use various statistical, logical, financial functions.
  • How to filter and sort data in a spreadsheet.
  • How to series fill with Autofill and Flashfill.
  • How to use Trace Precedents and Trace Dependents.
  • Introduction on how to create and use templates.
  • Introduction on how to record, edit and run a macro.
  • Introduction on how to create and edit pivot tables.
  • Introduction on how to analyse spreadsheet data and create a pivot report and graph.

Note: There is a maximum of 12 places available on this course

Please contact us if you have any questions.(external link)

Close drawer

a page loading spinner