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:

    6 April 2024
    Dates: 6 April-4 May, Saturdays 9am-1pm, Room G101
    5 October 2024
    Dates: 5 Oct-2 Nov, Saturdays 9am-1pm, Room G101
  • Fees

    Tuition: 77.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