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 teaching hours, anticipate a further 10 hours of self directed learning – homework, practice)
This Microsoft Excel NZQA Level 1 course introduces spreadsheet concepts to students. Participants learn to make formatting adjustments, freeze columns and panes, and 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 teaching hours, anticipate a further 19 hours of self directed learning – homework, practice)
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.