top of page

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: 9 am to 1:00pm

Class size: 1-5 attendees

 

Course Outline

Dates:

  • Tuesday, 21 January 2025

  • Friday, 28 February 2025

  • Thursday, 20 March 2025

  • Thursday, 17 April 2025

  • Tuesday, 29 April 2025

  • Thursday, 22 May 2025

  • Friday, 30 May 2025

  • Thursday, 26 June 2025

  • Friday, 4 July 2025

  • Wednesday, 30 July 2025

  • Thursday, 7 August 2025

  • Tuesday, 2 September 2025

  • Wednesday, 10 September 2025

  • Friday, 3 October 2025

  • Tuesday, 14 October 2025

  • Thursday, 6 November 2025

  • Friday, 14 November 2025

  • Wednesday, 10 December 2025

  • Thursday, 18 December 2025

If these dates do not suit you please contact me for alternatives

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: 9 am to 1:00pm

Class size: 1-5 attendees

 

Course Outline

  • Wednesday, 29 January 2025

  • Thursday, 27 February 2025

  • Wednesday, 2 April 2025

  • Wednesday, 7 May 2025

  • Tuesday, 10 June 2025

  • Tuesday, 15 July 2025

  • Friday, 15 August 2025

  • Thursday, 18 September 2025

  • Wednesday, 22 October 2025

  • Tuesday, 25 November 2025

If these dates do not suit you please contact me for alternatives

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: 9 am to 1:00pm

Class size: 1-5 attendees

 

Course Outline

  • Friday, 7 February 2025

  • Friday, 7 March 2025

  • Friday, 4 April 2025

  • Tuesday, 20 May 2025

  • Tuesday, 24 June 2025

  • Friday, 25 July 2025

  • Thursday, 28 August 2025

  • Wednesday, 1 October 2025

  • Tuesday, 4 November 2025

  • Friday, 5 December 2025

If these dates do not suit you please contact me for alternatives

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: 9 am to 1:00pm

Class size: 1-5 attendees

 

Course Outline

  • Wednesday, 12 February 2025

  • Thursday, 13 March 2025

  • Thursday, 10 April 2025

  • Friday, 18 April 2025

  • Thursday, 15 May 2025

  • Friday, 23 May 2025

  • Wednesday, 18 June 2025

  • Friday, 27 June 2025

  • Wednesday, 23 July 2025

  • Thursday, 31 July 2025

  • Tuesday, 26 August 2025

  • Wednesday, 3 September 2025

  • Friday, 26 September 2025

  • Tuesday, 7 October 2025

  • Thursday, 30 October 2025

  • Friday, 7 November 2025

  • Wednesday, 3 December 2025

  • Thursday, 11 December 2025

If these dates do not suit you please contact me for alternatives

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: 9 am to 1:00pm

Class size: 1-5 attendees

 

Course Outline

  • Thursday, 13 February 2025

  • Friday, 14 March 2025

  • Friday, 11 April 2025

  • Thursday, 1 May 2025

  • Friday, 16 May 2025

  • Tuesday, 27 May 2025

  • Thursday, 19 June 2025

  • Tuesday, 1 July 2025

  • Thursday, 24 July 2025

  • Friday, 1 August 2025

  • Wednesday, 27 August 2025

  • Thursday, 4 September 2025

  • Tuesday, 30 September 2025

  • Wednesday, 8 October 2025

  • Friday, 31 October 2025

  • Tuesday, 11 November 2025

  • Thursday, 4 December 2025

  • Friday, 12 December 2025

​If these dates do not suit you please contact me for alternatives

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: 9 am to 1:00pm on both days

Class size: 1-5 attendees

 

Course Outline

  • Tuesday, 18 February & Wednesday, 19 February 2025

  • Wednesday, 19 March & Thursday, 20 March 2025

  • Wednesday, 23 April & Thursday, 24 April 2025

  • Wednesday, 28 May & Thursday, 29 May 2025

  • Wednesday, 2 July & Thursday, 3 July 2025

  • Tuesday, 5 August & Wednesday, 6 August 2025

  • Friday, 5 September & Tuesday, 9 September 2025

  • Thursday, 9 October & Friday, 10 October 2025

  • Wednesday, 12 November & Thursday, 13 November 2025

  • Tuesday, 16 December & Wednesday, 17 December 2025

If these dates do not suit you please contact me for alternatives

© Copyright All Rights Reserved Software Solutions Rotorua Limited | NZBN: 876835 

bottom of page