This Series of Excel articles and tutorials covers the fundamentals of using
functions to perform a variety of tasks in Excel spreadsheets.
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.
This step by step tutorial takes you through using the SUM function and selecting a
for calculations using the Auto SUM function.
In Excel, the PRODUCT function can be used when multiplying numbers or a range of values together.
Excels 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
Excels 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.
The Max function, one of Excels 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.
The MIN function, another of Excels 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.
The OR function is one of Excels 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.
Excels 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.