Laptop Screen and Graduation Mortarboard Hat icon image

    Excel Topic 1: Working with Advanced Functions

    Course Duration: 90 Minutes

    Target Audience:

    This session is intended for Excel users who wish to create complex calculations using the more advanced functions within Excel.

    Course Objectives:

    This session aims to expand the participant’s existing knowledge and use of functions into the many distinctive areas of Excel.

    Course Outline:

    Course Introduction

    Review of Standard Functions

    Statistical: COUNTIF, COUNTIFS, LARGE, MAX, MAXIFS, MIN, MINIFS, RANK, TREND

    Logical: IF, IFS, SWITCH, NOT, AND, OR, ISERROR

    Text: CLEAN, CONCATENATE, CONCAT, TRIM, FIND, LEFT, RIGHT, EXACT, PROPER, TEXT, TEXTJOIN

    Lookup and Reference: VLOOKUP, HLOOKUP, XLOOKUP, MATCH, OFFSET

    Mathematical: INT, TRUNC, ROUND, SUBTOTAL, SUMIF

    Date and Time: NOW, TODAY, YEAR, MONTH, WORKDAY, WEEKDAY, NETWORKDAYS

    Information: CELL, ISERROR, ISBLANK

    Discussion and Question Time

    View Schedule
    Contact Us

    Contact us today to enquire about all our courses, classroom and virtual training options. Follow us on Facebook and LinkedIn for latest updates.