Microsoft Excel: Advanced Functions and Formulas

Learn some of the most important formula and functions, so you can use Excel effectively and creatively in your business.

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.

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

Tue 13 Oct, 12:30 PM

42 Egmont Street, New Plymouth

Share this Listing