Advanced Functions and Formula

 

Introduction:

Excel has over 400 functions but many of them are specialised ones (e.g. engineering, statistical and financial). This workshop covers some of the most important, commonly used ones to help you use Excel effectively and creatively in your business. The ultimate power of the functions comes from using them in combinations and nesting them to solve problems quickly and effectively.

 

Requirements: Attendees must have their own laptops (not Tablets) with full Microsoft Excel, version 2007 or higher. (To check version, open a spreadsheet, click on File then Account.)

 

Skills needed:

This is an advanced level workshop. You will be a confident user of Excel with a good knowledge of how basic formula work. You are welcome to contact the trainer if you are unsure of your level.

 

Skills covered:

Functions:

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

Entering and editing formula:

common formula errors; absolute and relative references; error checking & auditing

 

This two hour workshop is offered at the Taranaki Chamber of Commerce's training room from time to time and is also available for individual businesses and can be adapted to suit their needs.

©2019 by Excel in Access. Proudly created with Wix.com

This site was designed with the
.com
website builder. Create your website today.
Start Now