Excel functions and formulas are the lifeblood of an Excel spreadsheet. Formulas are expressions that compute calculations within a spreadsheet cell. Functions are used within formulas, and are built-in shortcuts that perform a predetermined set of calculations and returns an output.Together, theses two make up the most powerful capabilities of Excel. Without them, a spreadsheet would be simply a list of numbers.
And contrary to popular belief, they are quite easy to learn and master. Start your journey by clicking on one the links below.
|5 Steps to writing your first formula|
|What is an Excel function?|
|Adding a function to a cell|
Common Excel Functions
|SUM||Add two or more numbers together.|
|MIN||Find the lowest value in a list of values.|
|MAX||Find the highest value in a list of values.|
|COUNT||Count the cells that contain numbers.|
|ABS||Find the absolute value of a number.|
Logical Excel Functions
|IF||Perform a test and return a value based on the outcome.|