Intermediate Excel-ling
Level 3

Intermediate Excel-ling

ACE316 Intermediate Excel-ling

  • Course code

    ACE316

  • Locations and dates

    Nelson:

    7 November 2020
    Saturdays, 9am-2pm for 4 weeks, Room G101 (G Block)
    No classes 14 Nov & 5 Dec
    6 March 2021
    Saturdays, 6 Mar, 13 Mar, 27 Mar, 17 Apr, 9am-2pm for 4 weeks, Room G101
    8 May 2021
    Saturdays, 8 May, 15 May, 29 May, 5 Jun, 9am-2pm for 4 weeks, Room G101
  • Fees

    Tuition: $75.00
  • Credits

    2

New programme.

This course aims for learners to develop spreadsheet skills using Excel from an intermediate level towards advanced.

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