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
No start dates are currently available. Register to be informed when new dates are added.
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 and speed of development, including AI development - whilst AI is part of the learning, the course concentrates on the 'how and why' of generating solutions.

This will be challenging but very rewarding both personally and from a work perspective.

Pre-requisites

Learners 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
- AI generated solutions
- 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 | Domestic students

If you are over 16 years of age, please click on the Apply Now button to enrol.

If you are new to NMIT, please provide us with a verified copy(external link) of your ID upon application or enter your NSN (National Student Number). If your NSN is unverified, we will request a verified copy(external link) of your ID.

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 your school principal (or approval from your home school supervisor if you are homeschooled).

Please email your documents to enrolments@nmit.ac.nz.

Entry requirements | International students

If you live in New Zealand, please click on the Apply Now button to enrol.

If you are new to NMIT, please provide us with a verified copy(external link) of your ID including your visa upon application or enter your NSN (National Student Number). If your NSN is unverified, we will request a verified copy(external link) of your ID.

Please note that you will be required to pay insurance(external link) if you wish to attend this course.

Please email your documents to enrolments@nmit.ac.nz.