Employers and Manufacturers Association (EMA) Northern - Excel for Advanced Users

Excel for Advanced Users

Reinforce your competency in Excel to achieve complex tasks

Who’s this course for?

Advanced: Analyse, Create and Evaluate 

If you’re in a
management, accounting, sales or other leadership roles, this advanced course will give you an edge in analysis. From productivity to performance, from sales to safety, if you want to produce reports with real insight this is the course for you.


What you’ll learn:
Being able to master Excel’s powerful analysis tools will give any organisation an edge. This half-day course is designed to build on the intermediate skills you have, to help you use advanced functions within Excel. You’ll learn how to analyse data in ways that will give you valuable insights into patterns and trends, to keep your business ahead of the competition or your organisation at the forefront of knowledge.

After, you’ll be able to…

  • Set up and refresh data connections to call in data from external sources
  • Analyse and report on key data with pivot tables and charts, and use PowerPivot on 
  • multiple sets of data
  • Connect to and transform data with Power Query
  • Insert Form Controls to customise worksheets
  • Record and run macros to automate actions.​

Join Us.

Together we're building businesses, communities and opportunities for all
New Zealand

Download PDF form here
View subscription rates

Related Events & Training

If you feel constantly stressed by your workload and consider yourself time-poor, this workshop will get you back in control. Brush up on your time management skills or send a colleague.
Find out more
This introductory to intermediate-level workshop is designed for anyone responsible for managing employee leave records. It will equip you to ensure full compliance with current employment legislation, reducing risks to your organisation.
Find out more
This introductory to intermediate workshop is designed for people new to HR as well as managers, HR advisors and business partners. Certain employer obligations are essential under the Act and this workshop provides the working knowledge you need.
Find out more
If you need to be more effective in finding out-of-the-box solutions to problems, this challenging and interactive workshop is just what you need.
Find out more
If you are responsible for managing people, an HR Advisor or Business Partner, this practical course is for you. To get the most out of this course, participants should already have a working knowledge of procedural fairness.
Find out more

Related Services

The accreditation systems available for EMA courses include unit standards assessed according to the requirements of the Government’s New Zealand Qualifications Authority (NZQA) – including for EMA short courses.
Read full story
This section provides background information for making the most of our training courses and events, such as registration and cancellation policies, how to become accredited and certified in your field of expertise.
Read full story
These courses are recognised New Zealand wide - in any industry - as evidence of your increasing knowledge, experience and value in your workplace. These Certificates broaden your skills and provide independent evidence of your abilities.
Read full story
EMA offers training in digital advertising, content marketing, SEO, cybersecurity and other areas critical to the success of business in the digital age.
Read full story
Using a non-technical approach, our practical workshops give you a thorough understanding of the various components of better business management, arming you with the latest techniques to help give your business a competitive edge.
Read full story