Apply now

Start Excel-ling

  • Locations and dates

    Nelson:

    13 February 2018
    1 May 2018
    24 July 2018
    16 October 2018
  • Fees

    $75

    Fees listed are for each year of the programme, indicative only and may vary with course selection. Exact fees provided on request or application.

Develop spreadsheet skills using Excel to an intermediate level.

This course is run over 6 weeks, on our Nelson campus.

You'll learn

  • How to produce computer spreadsheets that include inputting text and numbers, and formulae.
  • How to use a standard spreadsheet application that includes the formatting of a spreadsheet, the use of 'with absolute' and relative referencing.
  • How to link spreadsheet cells to Word Documents and other spreadsheet worksheets.
  • How to create and use templates.
  • To record, edit and run a macro.
  • To use various statistical, logical, financial functions.
  • How to filter and sort data in a spreadsheet.
  • To create and edit pivot tables.
  • How to analyse spreadsheet data and create a pivot report and graph.
  • How to series fill with Autofill and Flashfill.
  • How to use Trace Precedents and Trace Dependents.

Note: There is a maximum of 12 places available on this course

Please contact us if you have any questions.(external link)

Fetching data...
Close drawer