Skip to content
    Laptop Screen and Graduation Mortarboard Hat icon image

    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

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