Microsoft Excel: Advanced Functions and Formula

This workshop covers some of the most important formula and functions to help you use Excel effectively and creatively in your business. The ultimate power of the functions comes from using them in combinations – nesting them.  An advanced user is not only aware of these functions, but is able to use them to solve problems quickly and effectively.

Skills needed:

This is an advanced level workshop.  Attendees will be confident users of Excel with a good knowledge of how basic formula work.  Please contact the trainer if you are unsure of your level, here

Skills covered:

Functions:

  • LOOKUP
  • VLOOKUP
  • HLOOKUP
  • IFERROR
  • CONTIFS
  • SUMIFS
  • CHOOSE
  • AVERAGEIFS
  • INDEX & MATCH
  • IF (nested) AND, OR, NOT, IFS (nested)

Entering and editing formula:

  • Common formula errors
  • Absolute and relative references
  • Error checking and auditing

Requirements: Attendees must bring their own laptops (not Tablets) with full Microsoft Excel, version 2007 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.

Read about the trainer and other workshops here: www.exceltrainingtaranaki.co.nz

REGISTER BELOW

Please note: Due to unforeseen circumstances, this workshop has been rescheduled to
Tuesday 13 October. 


For additional information and assistance
please contact Julia at
julia@taranakichamber.co.nz,
or call 06 759 9080
Date:
Tuesday, 13th October, 2020
Time:
12:30 p.m. to 2:30 p.m.
Location:
Taranaki Chamber of Commerce
Single Ticket (Member) incl GST:
$115.00
Single Ticket (Non-Member) incl GST:
$145.00

Step 1 of 5 - Event Details

Membership

Choose if you are booking as a member or non-member

First time here? If you’re a current Chamber member and this is your first time registering for an event on our new website, please click here and enter your email address to be sent your password.

Forgotten Password

Event


Total (incl GST)

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.