100% NZ Owned and Operating since 1994
Cathi Barker
Mobile: 027 285 23 89
Software Solutions
Microsoft Excel
We appreciate the many different learning styles that people have and so we offer face-to-face in-person instructor-led Courses as well as attending the course remotely using Microsoft Teams. Below are the Course Outlines detailing what is covered in each course and the Course Dates until the end of the year as well as a link to book yourself on a Course or contact me directly. Alternatively, teach yourself completely in your own time and pace by enrolling in the Online Classroom option for each course.
We offer six MS Excel courses below.
The Essentials
Level 1: The Essentials skills all Excel users should have to effectively work with Excel.
Attend face to face or remote video via MS Teams.
​
Cost: $295+GST per person
Duration: 8:30 am to 1:00pm
Class size: 1-5 attendees
Dates:
-
Wednesday, 7 August 2024
-
Friday, 16 August 2024
-
Friday, 23 August 2024
-
Friday, 6 September 2024
-
Tuesday, 24 September 2024
-
Friday, 11 October 2024
-
Friday, 25 October 2024
-
Tuesday, 12 November 2024
-
Tuesday, 3 December 2024
Functions, Charts & More
Level 2: Learn about a variety of functions to analyse data, and then protect and present that data on a chart dashboard.
Attend face to face or remote video via MS Teams.
​
Cost: $295+GST per person
Duration: 8:30 am to 1:00pm
Class size: 1-5 attendees
-
Thursday, 1 August 2024
-
Thursday, 8 August 2024
-
Wednesday, 21 August 2024
-
Thursday, 29 August 2024
-
Wednesday, 11 September 2024
-
Friday, 27 September 2024
-
Wednesday, 9 October 2024
-
Tuesday, 29 October 2024
-
Wednesday, 13 November 2024
-
Wednesday, 27 November 2024
-
Wednesday, 11 December 2024
-
Wednesday, 18 December 2024
Data Manipulation
Level 3: Learn how to report off large lists with advanced filtering, pivot tables, outlining and custom view and automate with macros .
Attend face to face or remote video via MS Teams.
Level 2 is not a pre-requisite.
​
Cost: $350+GST per person
Duration: 8:30 am to 1:00pm
Class size: 1-5 attendees
-
Thursday, 1 August 2024
-
Wednesday, 14 August 2024
-
Thursday, 22 August 2024
-
Tuesday, 3 September 2024
-
Friday, 13 September 2024
-
Wednesday, 25 September 2024
-
Thursday, 10 October 2024
-
Wednesday, 16 October 2024
-
Wednesday, 30 October 2024
-
Thursday, 7 November 2024
-
Wednesday, 20 November 2024
-
Thursday, 5 December 2024
-
Tuesday, 17 December 2024
Get & Transform Data (Power Query)
Level 4: Connect to external files and transform in Excel using the Power Query engine.
Attend face to face or remote video via MS Teams.
​
Cost: $350+GST per person
Duration: 8:30 am to 1:00pm
Class size: 1-5 attendees
-
Friday, 2 August 2024
-
Thursday, 15 August 2024
-
Friday, 23 August 2024
-
Tuesday, 17 September 2024
-
Thursday, 3 October 2024
-
Tuesday, 8 October 2024
-
Friday, 1 November 2024
-
Thursday, 21 November 2024
-
Tuesday, 10 December 2024
Data Analysis & Insights (Power Pivot)
Level 5: Connect to external files and transform and using Power Pivot create a data model and pivot tables off a data model.
Attend face to face or remote video via MS Teams.
​
Cost: $350+GST per person
Duration: 8:30 am to 1:00pm
Class size: 1-5 attendees
-
Friday, 16 August 2024
-
Tuesday, 27 August 2024
-
Wednesday, 18 September 2024
-
Friday, 4 October 2024
-
Tuesday, 15 October 2024
-
Thursday, 31 October 2024
-
Friday, 22 November 2024
-
Friday, 13 December 2024
-
Friday, 20 December 2024
Macros & VBA Code (2 Day Course)
Level 6: Adjust the VBA code and build intelligence into your macros.
Attend face to face or remote video via MS Teams.
​
Cost: $650+GST per person
Duration: 8:30 am to 1:00pm on both days
Class size: 1-5 attendees
-
Friday, 2 August 2024 & Tuesday, 6 August 2024
-
Tuesday, 1 October 2024 & Wednesday, 2 October 2024
-
Thursday, 28 November 2024 & Friday, 29 November 2024