A function in spreadsheets is a special tool that helps you do calculations quickly, without having to type everything out yourself. It's like a shortcut for math and other tasks.
Imagine you have a big list of numbers, and you want to add them all up. Instead of typing each number one by one, you can use the SUM function—just tell the spreadsheet which numbers to add, and it does the work for you.
Functions can do all sorts of things, like finding the average of numbers, looking up information, or even checking if something is true or false. They make working in spreadsheets much easier and faster.
The videos below introduce you to some simple functions.
Simple Functions in Excel
(The Sum Function)
More Simple Functions in Excel
(The Min, Max and Average Functions)
More Simple Functions in Excel
(The Rounding Functions)
Combining Simple Functions in Excel