Microsoft Excel: Intermediate/Advanced

Take your basic Excel skills up to a new level and work more efficiently and effectively.  Master some of the advanced uses of Excel Tables, format your data accurately and learn some of the popular and most effective business formula.

Skills needed:
This is an intermediate level workshop for reasonably confident users of Excel with basic skills including an understanding of formula like SUM() and AVERAGE(), and entering and editing data.

Skills introduced:

  • General Worksheets and Workbook tips
  • Number and Date Formatting including Custom Formatting of Dates and Numbers
  • Advanced Excel Tables features including:
    • Advanced Filtering and Sorting
    • Slicers for Filtering Data
    • Forms for entering Data
    • Structured Referenced Formula
  • Advanced Formula and Functions including:
    • Absolute and Relative References
    • Logical Functions: IF, AND, SUMIFS, COUNTIFS, AVERAGEIFS
    • Lookup Functions: VLOOKUP

Requirements: 
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 and detailed notes will be provided.

Limited spaces to ensure student-centred learning.

Read about the trainer, Bernard Pfister from Excel Training Taranaki, and other workshops here

Register to attend below.

For more information, contact Julia at julia@taranakichamber.co.nzor call 06 759 9080


Date:
Wednesday, 20th October, 2021
Time:
9:30 a.m. to 11:30 a.m.
Location:
Taranaki Chamber of Commerce
Single Ticket (Member) incl GST:
$138.00
Single Ticket (Non-Member) incl GST:
$165.00

Step 1 of 4 - 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.