In this lesson, we are going to learn how to use formulas and functions in Excel to perform calculations and automate data processing.
A formula in Excel is an expression that calculates the value of a cell, usually starting with an equal sign (=), such as =A1+A2. Functions are built-in formulas like SUM(A1:A2) that simplify common tasks. You’ll learn how to enter and edit formulas, understand the order of operations (parentheses first, then multiplication/division, and then addition/subtraction), and how Excel automatically updates results when referenced cell values change.
You’ll also discover how to copy and paste formulas, where Excel intelligently adjusts cell references based on their new location. This lesson introduces the Insert Function feature, which helps you find and apply the right function, such as COUNTIF, with specified criteria. By the end, you’ll know how to use formulas and functions to save time, reduce errors, and efficiently calculate and analyse data in your worksheets.