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

    Nelson:

    11 November 2023
    Dates: 11 November-02 December, Saturdays 9am-2pm, Room G101
  • Fees

    Tuition: 75.00
  • 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. Take full advantage of Excel’s enormous capability – this will be challenging but very rewarding both personally and from a work perspective.

Pre-requisites

Learner 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
    • 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