Microsoft Excel Training – Spreadsheets

Spreadsheeting Training

Learn how to use the Microsoft Excel programme for all your spreadsheet requirements from basic formulas to functions.

Our courses are excellent preparation if you need to enter data or to keep track of clients or stock (such as storeroom-type work).

Many businesses use Excel as an accounting system.

All of our spreadsheeting courses can be customised, and targeted without needing to sit the full course or NZQA Unit Standard

Contact us on 0800 783 729 to book today!

Courses / Training

NZQA Unit Standard 18743 – Produce a spreadsheet from instructions using supplied data

NZQA Level 1 – 2 credits (9.5 hours)

This Microsoft Excel NZQA Level 1 course introduces spreadsheet concepts to students. Participants learn how to make formatting adjustments, freeze columns and panes, basic formulas and charts.

  • Advantages of using spreadsheets
  • Moving around spreadsheets & entering data
  • Formulas and functions
  • AutoSum and AutoSum options
  • Worksheet data alignment
  • SmartArt Diagrams and Organisational charts

NZQA Unit Standard 29770 – Create and use a computer spreadsheet to solve a problem

NZQA Level 2 – 3 credits (11 hours)

This Microsoft Excel NZQA Level 2 course introduces more intermediate spreadsheet concepts to students. Participants learn how to create templates, follow a spreadsheet brief, more advanced formulas, and formatting techniques.

  • Advantages of using spreadsheets
  • Following a brief and drawing a specification plan
  • More formulas and functions
  • Appropriate legibility, presentation, accuracy & data integrity
  • Organisational charts

Introduction Course in Spreadsheets Now Offered! 

This short course has been designed to give an introduction of how to use a spreadsheet and apply basic functions. The training provides learners with skills and competence while entering data into a spreadsheet and to produce a simple pie chart.