ACE316 Intermediate Excel-ling

NMIT is part of Te Pūkenga

This means that you will now graduate with a Te Pūkenga qualification. Read more
Course code

ACE316
Locations and dates

Nelson:

6 April 2024

Dates: 6 April-4 May, Saturdays 9am-1pm, Room G101

5 October 2024

Dates: 5 Oct-2 Nov, Saturdays 9am-1pm, Room G101
Fees

Tuition: 77.00
Credits

2

You already have a good grasp of the basics and are efficient but want to take your Excel skills to the next level. Take full advantage of Excel’s enormous capability – this will be challenging but very rewarding both personally and from a work perspective.

Pre-requisites

Learner should have a good knowledge of basic Excel use including tables, templates, graphs, linking, formulae and basic use of IF functions.

Check out our Beginner Excel-ling short course.

Indicative course content

Assess knowledge and ability of formulae creation as a group
Introduce progressively complex formulae iterations:

Simple formulae
Nested formulae
Multi-sheet formulae
Linked workbooks
Linked external documents

Use various statistical, logical, financial functions
Produce detailed and complex analytical tables and graphs to create and edit pivot tables
Record, edit and run macros in complex scenarios
Basic relationship with database management including csv file importing and management
Manipulation of data for mail merging
Create and use templates
Use Trace Precedents and Trace Dependents

Entry requirements

To be eligible to enrol on this course, you must be:

a New Zealand citizen or resident
16 years of age or over
not a full-time secondary school student

However, if you are a full-time secondary school student, NMIT is able to enrol you if you meet all of the following:

are 16 years of age and over, and
attend this course outside of normal school hours, and
have obtained approval from the relevant school principal, and
have obtained approval from the TEC to enrol in an ACE Course - 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 please contact our enrolments team; enrolments@nmit.ac.nz