IF functions (often called IF statements) are one of the most versatile functions in Excel. Want to sift through a long list of data? Perfect match. Want to set up your spreadsheet to check any input you type in? They can do it! Want to automate your spreadsheet? These guys can literally do anything… An IF function […]

## How to Add an Excel Function to a Cell

An Excel function is a built-in shortcut, used within an Excel formula, that performs a set of predetermined calculations using inputs that you provide, and returns an output. Functions are typed using an exact syntax (order of symbols). These can sometimes be hard to remember, but luckily Excel has several tools to help you find […]

## What is an Excel Function?

An Excel function is a built-in shortcut to do calculations in Excel, and it can be incorporated into any formula in any cell. A function runs a predetermined set of calculations based on input you provide it with. For example, say you wish to calculate the value of a number raised to a certain power. […]

## How to Add a Secondary Vertical Axis to an Excel Graph

Ever had to plot two different, but related relationships on one graph? For example, average temperature and rainfall are very closely related and often influence one another. When plotted together, they’ll provide a insightful snapshot of the week’s weather on a single graph. In situations like this, it’s really helpful to add a secondary axis to the graph. How […]

## How to use the ABS function

The ABS function is used to remove any negative sign from in front of a value. For example; The absolute value of -4 (negative) is equal to 4. The absolute value of 4 (positive) is also equal to 4. Thus, the ABS function will always return a positive value. See the bottom of this page for […]

## How to use the MAX function

The MAX function in Excel are used to find the highest values in a list of values. This is especially useful when you have a data set of a few thousand values and don’t have the time to go through each value separately in order to determine which one is the highest. To use the MAX function, we […]

## How to use the MIN function

The MIN function in Excel are used to find the lowest values in a list of values. This is especially useful when you have a data set of a few thousand values and don’t have the time to go through each value separately in order to determine which one is the lowest. To use the MIN […]

## How to use the SUM function

The SUM function let’s you easily add two or more numbers. You can also use it to add all values in a given range of cells. It is extremely useful for finding the sum of all values in a column or row. Syntax To use the SUM formula, use the following syntax: =SUM(number1,[number2]…) …where both number1 […]