Employers and Manufacturers Association (EMA) Northern - Business Intelligence Using Excel

Business Intelligence Using Excel

Learn how to analyse your data, and present it in a visual way – all within Excel

Who’s this course for?

Advanced: Analyse, Create and Evaluate 

If you are an Excel user wanting to increase your current skill level, this is the session for you.

What you’ll learn:

This half day course will build on the Excel knowledge you already have, and build on it to show you how to take your data into a visual platform all within Excel.

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
  • Analyse and report on multiple sets of data with PowerPivot
  • Connect to and transform data with Power Query
  • Build a dashboard with Power View
What's included?

This session will help you get more from your Excel programme:
  • ​Analysing Data
  • Pivot Tables and Charts
  • Quick Analysis *
  • Power Pivot
  • Get and Transform / Power Query
  • Power View


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

Access a range of online learning options such as self-paced eLearning modules or live webinars in the areas of compliance, legislation, health and safety and technology. Get training that is modern, engaging, targeted and cost-effective.
Read full story
Give your business a spring clean. Have enforceable up-to-date policies that align with best practice, to ensure you are compliant with what the Authority and Courts expect of you.
Read full story
Read full story
EMA Learning offers training on everyday Microsoft Office applications such as Word, Excel, Outlook, etc and Cloud tools such as Sharepoint.
Read full story
Read full story