ACE304 Start Excel-ing

NMIT is part of Te Pūkenga

This means that you will now graduate with a Te Pūkenga qualification. Read more
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

Entry requirements

To be eligible to enrol on this ACE Course, you must be:

*If you are a full-time secondary school student, you may be able to enrol on this course if:

you are 16 years of age or over
attend this course outside of normal school hours
have obtained approval from the relevant school principal and
have obtained approval from the TEC to enrol – please allow NMIT at least 14 working days before course start date to obtain approval from TEC. If approval is not gained before the course start date, you will be shifted to the next available intake.

For more information contact our enrolments team; enrolments@nmit.ac.nz