Using Excel Functions in Spreadsheets
Built-in functions in Excel can be used to perform calculations on spreadsheet data. While most people use only those functions specific to their needs, there are many functions such as SUM, COUNT, AVERAGE, MAX, MIN, and the IF function that just about everyone uses. Here you will find step by step tutorials, tips and shortcuts on how to use the common and less common functions available in Excel.
Excel IF Functions
IF functions are one of the most versatile functions available in Excel and other spreadsheet programs. This Series of Articles covers how to use Excel IF functions as well as uses for the IF function in spreadsheets.
IF functions are one of the most versatile functions available in Excel and other spreadsheet programs. This Series of Articles covers how to use Excel IF functions as well as uses for the IF function in spreadsheets.
Excel SUM Function
The Excel SUM function is used to quickly add up the values in a range of cells. This article shows you how to use this function.
The Excel SUM function is used to quickly add up the values in a range of cells. This article shows you how to use this function.
Excel VLOOKUP
Excel’s VLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This article covers how to create a VLOOKUP function in Excel, including an example.
Excel’s VLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This article covers how to create a VLOOKUP function in Excel, including an example.
Excel OR Function
The OR function is one of Excel's Logical Functions. Like most logical functions, the output from the OR function is either the word TRUE or FALSE. This article walks you through how to use this function.
The OR function is one of Excel's Logical Functions. Like most logical functions, the output from the OR function is either the word TRUE or FALSE. This article walks you through how to use this function.