Intermediate Excel-ling
Course details
| NZQF Level | 3 |
|---|
About the course
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
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 [email protected].
About the provider
At NMIT, our goal is to ensure you graduate work-ready and confident in your knowledge and skills to step into a successful career. Our wrap-around support services guide you through the process of learning, teaching you skills for life and ensuring your well-being is supported so you can focus on achieving your goals.
NMIT strives to make meaningful and positive change to the businesses and members in our community. For nearly 120 years, we have stood strong as a cornerstone for high-quality tertiary education and community engagement Te Tauihu (the Top of the South).
This means when you join NMIT, you become connected to a network of industry partners and employment opportunities that can open doors for you. Our passionate tutors across multiple study areas are highly regarded and influential in their chosen fields.
Whatever path you wish to pursue, we'll do what we can to help you reach your goal. Our internationally recognised qualifications are yours for the taking, and the journey to get them can be a rewarding and uplifting experience.