Home Specialist skills Technology and Software Microsoft Excel Advanced – Formulas and Functions
Microsoft Excel Advanced – Formulas and Functions
-
Understand how to build complex formulas using nested functions (such as IF statements)
-
Customise formulas by taking advantage of the built-in functions available in Excel
-
Learn sophisticated search and auditing techniques when working with data-heavy spreadsheets
Overview
Off the shelf (OTS)
At the end of this course you will have a greater understanding of building complex formulas using nested functions (such as IF statements). You will find quicker ways to customise formulas by taking advantage of the built-in functions available in Excel. You will learn how to save time by learning more sophisticated search and auditing techniques when working with data-heavy spreadsheets.
Delivery method
Virtual
Course duration
6 hours
Competency level
Expert
