Microsoft Excel: New Features in Excel 365

Microsoft Excel 365 is a subscription version that has new features added to it continually.  This workshop covers some of the most important recent updates of new functions that can make your use of Excel more efficient and effective.  These functions are not available in other Excel versions.  Many of the new functions can be used together with other functions (nested) to make them even more powerful.

Skills needed:
This is an intermediate level course and attendees should be reasonably confident users of Excel spreadsheets.

Skills introduced:
The workshop will focus on the new features of Excel 365 that will make the biggest impact on your daily use of Excel:

  • XLOOKUP: Can be used in place of all the old lookup functions (Vlookup, Hlookup, Index, Match with added features.
  • TEXTJOIN: Allows text from different cells to be joined with a defined delimiter such as a comma or space.
  • FILTER: A very powerful filter function that allows data in tables to be filtered based on single or multiple criteria. Can be used with AND and OR.
  • IFS: Can be used instead of the IF function and allows for more multiple logical conditions without using nested IF.
  • UNIQUE: Finds the unique items in a list quickly and easily. Can be used with SORT.
  • SORT & SORTBY: Allows you to create a new sorted list based on one or more values from other lists.
  • MAXIFS & MINIFS: Find the minimum and maximum value in a list depending on certain criteria.

Requirements: 
Attendees must bring their own laptops (not Tablets) with full Microsoft Excel:
Subscription Microsoft 365
.  To check version, open a spreadsheet, click on File then Account.  
Please contact your IT department if you are not sure of your version. You are also welcome to contact Excel Training Taranaki.

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

Register to attend below.

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


Date:
Wednesday, 17th November, 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.