Excel Functions

Using Functions in Excel Spreadsheets

This Series of Excel articles and tutorials covers the fundamentals of using functions to perform a variety of tasks in Excel spreadsheets.

Excel IF Functions

IF functions are one of the most versatile functions available in Excel. This series of articles covers how to create and use the IF function in Excel spreadsheets.

SUM and AutoSUM Step by Step Tutorial

This step by step tutorial takes you through using the SUM function and selecting a range for calculations using the Auto SUM function.

Multiplying Numbers in Excel

In Excel, the PRODUCT function can be used when multiplying numbers or a range of values together.

Excel AVERAGE Function

Excel’s AVERAGE function is one of the “Statistical Functions” that are included with the program. The AVERAGE function can be used to find the average, or arithmetic mean, of values in a selected range of cells.

Excel COUNT Function

Excel’s COUNT function is one of a group of “Count Functions” that can be used when you need to total the number of cells in a selected range.

Excel MAX Function

The Max function, one of Excel’s statistical functions, is used to find the largest value in a given list of arguments. This article includes an example to walk you through using the MAX function.

Excel MIN Function

The MIN function, another of Excel’s statistical functions, is used to find the smallest value in a given list of arguments. This article includes an example to walk you through using the MIN function.

Excel OR Function

The OR function is one of Excel’s “Logical Functions”. Like most logical functions, the OR function only returns a true or false result. To determine whether the output will be true or false, the function evaluates at least one expression located in another cell in the spreadsheet.

Excel VLOOKUP

Excel’s VLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This article covers how to create a VLOOKUP function in Excel, including an example.