Microsoft Power BI

    Excel Topic 1: 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