Skip to main content

Home Specialist skills Technology and Software Microsoft Excel Advanced – Formulas and Functions

Microsoft Excel Advanced – Formulas and Functions

  • bullet point
    Understand how to build complex formulas using nested functions (such as IF statements)
  • bullet point
    Customise formulas by taking advantage of the built-in functions available in Excel
  • bullet point
    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 icon

Virtual

Virtual icon

Face to Face

Course duration
Duration icon

6 hours

Competency level
Expert icon

Expert

Pink building representing strand 4 of the campus map
Delivery method
  • Virtual icon

    Virtual

  • Virtual icon

    Face to Face

Course duration
Duration icon

6 hours

Competency level
  • Expert icon

    Expert

chatbotSpark login – Alpha testing