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.
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
- 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
Please note: Due to unforeseen circumstances, this workshop has been rescheduled to
Tuesday 13 October.