Intermediate Excel-ling
Level 3

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

New programme.

You already have a good grasp of the basics and are efficient but want to take your Excel skills to the next level.

start excel ling

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
Close drawer

a page loading spinner