What you’ll learn:

This half-day course is designed to build on the intermediate skills you have and help you use advanced functions within Excel to analyse data to give you valuable insights into patterns and trends for your work or your business.

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 repoprt on multiple sets of data with PowerPivot
  • Connect to and transform data with Power Query
  • Insert Form Controls to customise worksheets
  • Record and run macros to automate actions.

No results found.

  • Member (Standard) $290.00 + GST
  • Non Member (Standard) $350.00 + GST

Next Sessions

  • Excel for Advanced Users 10/06/2021 - 10/06/2021
    EMA Northern 145 Khyber Pass Road Grafton Auckland NEW ZEALAND
    Register
  • Excel for Advanced Users 19/08/2021 - 19/08/2021
    Nationwide Nationwide NEW ZEALAND
    Register
  • Excel for Advanced Users 10/11/2021 - 10/11/2021
    EMA Waikato 103 Tristram Street Hamilton NEW ZEALAND
    Register
  • Excel for Advanced Users 25/11/2021 - 25/11/2021
    EMA Northern 145 Khyber Pass Road Grafton Auckland NEW ZEALAND
    Register

No results found.

You may also be interested in:

  • Excel Fundamentals June 1st Get an introduction to Excel and its key features Computer Training Book a Ticket 
  • Excel Fundamentals June 1st Get an introduction to Excel and its key features Computer Training Book a Ticket 
  • Excel for Intermediate Users June 3rd Move beyond basic Excel skills to become a more proficient user Training Virtual Event Book a Ticket 



Save on courses by becoming an EMA member

Learn more Join EMA