Microsoft Excel: Basics/Intermediate

This is a basic/intermediate level course for those who are mainly self-taught users of Excel and would like to improve their skills and become more proficient users.

Focus is on features that can be applied immediately to your data – especially tables – and make the biggest impact on your use of spreadsheets – whatever type of data you work with.


  • Workbooks/Worksheets:
    • Navigating
    • Auto-fill
    • Moving and copying worksheets
    • Worksheet tabs
    • Number formatting
    • Protecting worksheets/workbooks
  • Excel Tables:
    • Advantages
    • Creating
    • Sorting and filtering
    • Adding data
    • Forms to enter data
    • Themes and styles
  • Introduction to making professional looking Charts:
    • Choosing the correct chart type
    • Creating and editing charts
  • Conditional Formatting:
    • Allows cells to be automatically formatted (e.g. colour of text/cell etc.) if they meet certain criteria set by the user (e.g. over or under a set value, top 10 values etc.)
  • Formulas:
    • Basic arithmetical functions and order of preference
    • AutoSum
    • Sum
    • Counta
    • Count
    • Min
    • Max
    • Average

Read about the Training Provider, Excel Taranaki, and other workshops here

Attendees must bring their own laptops (not Tablets) with full Microsoft Excel, version 2010 or higher.  
To check version, open a spreadsheet, click on File then Account.  
Please inform the training provider if you will be bringing a Mac laptop.

This workshop is interactive and attendees will gain hands-on experience
Raw data to work with and useful summary notes will be provided.

Limited spaces to ensure student-centred learning.
Attendees will require a My Vaccine Pass to attend*

Tea, coffee, water and light refreshments will be provided.
This workshop is fully booked
To be added to a waitlist for a future workshop
contact Julia at call 06 759 9080
Tuesday, 5th July, 2022
9:30 a.m. to 11:30 a.m.
42 Egmont Street, New Plymouth
Single Ticket (Member) incl GST:
Single Ticket (Non-Member) incl GST:

Sorry this event is sold out or no longer available.

Registration Policy:
Payment is required prior to course attendance, and your registration will be confirmed once payment has been made. 

Cancellation Policy:
Any cancellation and/or changes must be made in writing to the Taranaki Chamber of Commerce no less than ten working days prior to the course in order to receive a full refund/credit. No refund or credit will be given for cancellations made after this or for non-attendance at the course.

Taranaki Chamber of Commerce Covid-19 Policy:

  • All Taranaki Chamber of Commerce events follow Government and Ministry of Health guidelines.
  • If you are feeling unwell with cold or flu symptoms, please stay at home.
  • The wearing of face coverings is recommended.