Microsoft Power BI

    Excel Topic 2: Introduction to Formulas and Functions

    Course Duration: 90 Minutes

    Target Audience:

    Aimed at users who are new to Microsoft Excel and want to set up their own spreadsheets and create formulas and functions.

    Course Objectives:

    This session will explain the core formula and functions functionality in Excel. It will form the basis from which the participants can then progress to more intermediate and advanced functions and calculation sessions.

    Course Outline:

    Course Introduction

    Creating a Standard Formula

    Formula Concepts in Excel

    The Four Different Mathematical Operators

    The Order of Operators within a Formula

    Editing Formulas and Using the Formula Bar

    Using Copy and Paste and Autofill

    Understanding Relative and Absolute Cell References

    Using Standard Functions i.e., Sum, Average, Max, Min, Count and Counta

    Discussion and Question Time

    View Schedule
    Contact Us