Why Study/Key Benefits

• Improve Microsoft Excel skills for budgeting, forecasting, expense management, data analysis and tender pricing.

• Develop from basic Excel knowledge towards more advanced spreadsheet functions.

• Learn practical ways to work faster with large spreadsheets and manage data more effectively.

• Improve accuracy, spreadsheet security and the reliability of calculations.

• Suitable for people who are self-taught, regularly use Excel or want to refresh and improve their existing skills.

Programme Structure and Subjects/Topics

The workshop covers practical Excel functions and techniques, including:

• Workbook and worksheet navigation to improve workflow.

• Selection techniques and mathematical rules.

• Conditional functions for data analysis.

• Text functions, including splitting and combining text.

• Named ranges and cells.

• Hiding rows, columns and formulas.

• Protecting workbooks, worksheets and formulas.

• Lookup tables and lists for faster data entry.

• Automating entries and recording macros.

• Formula auditing and identifying errors.

• Using multiple worksheets and applying formulas across worksheets.

• Conditional formatting and data validation.

• Sorting, filtering and subtotalling data.

• Pivot Tables, Pivot Charts and Slicers.

• Data tables, grouping and outlining spreadsheet information.

• Consolidating worksheets and workbooks into summary files.

Disciplines/Specialisations

The course is focused on Microsoft Excel and practical spreadsheet applications, particularly:

• Business and administration.

• Budgeting and financial planning.

• Forecasting and expense management.

• Data analysis and reporting.

• Tender pricing and project-related calculations.

• Spreadsheet automation and data management.

Programme Highlights

• Live online training with a presenter and other participants.

• Six hours of scheduled instruction over two days.

• Trainer: Mary-Ellen Batchelor.

• Practical coverage of intermediate and advanced Excel features.

• Certificate awarded after completing both sessions.

• Participants need their own computer or laptop, camera and internet access.

Career Outcomes

The course is designed to strengthen workplace productivity and practical spreadsheet skills. The knowledge may be useful in roles involving:

• Administration and office support.

• Accounts and finance assistance.

• Business operations.

• Project coordination.

• Data reporting and analysis.

• Estimating, budgeting and tender administration.

Latest Updates/Special Requirements

• The brochure was last updated on 10 September 2026.

• The current advertised intakes are December 2026 and March 2027.

• Attendance at both sessions is compulsory to complete the course and receive the certificate.

• A computer or laptop with a camera and reliable internet access is required.

• The course is delivered live through Zoom, so participants should check their time-zone arrangements before registering.

• The official page does not publish a separate international-student admission process or a minimum English-language test score.

 

International Student Visa Requirements

This course is delivered online, so an international participant attending from outside New Zealand, such as from India, does not need a New Zealand visa simply to join the Zoom sessions.

If an applicant plans to travel to New Zealand for any in-person study or related activity, the visa position must be checked against the actual travel purpose and course arrangements:

• Immigration New Zealand allows people holding an appropriate Visitor Visa, work visa or NZeTA to study for up to 3 months in any 12-month period.

• A Visitor Visa allows study for up to 3 months, but does not permit ordinary employment in New Zealand.

• For a Visitor Visa, the published application cost starts at NZD $441, with 80% of applications processed within 2 weeks. These are current published figures and may change.

• Applicants paying their own expenses generally need at least NZD $1,000 per month for living costs, or NZD $400 per month if accommodation has already been paid. They must also show they can leave New Zealand at the end of their visit.

• If a person intends to study in New Zealand for more than 3 months, they will generally need an appropriate student visa and an offer of place from an eligible education provider.