| You are here: | About>Computing & Technology>Spreadsheets> Functions in Excel |
 | Spreadsheets |
Using Excel Functions in SpreadsheetsBuilt-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 Functions
This series of tutorials and articles will teach you the basics of using Excel functions to perform a variety of tasks in Excel spreadsheets. Excel IF Functions
This series of articles and tutorials will teach you the basics of using Excel IF functions to perform calculations in Excel spreadsheets. Excel 2007 IF Function
The IF function, one of Excel's logic functions, tests to see if a certain condition in a spreadsheet is true or false. This article includes an example to walk you through using Excel 2007's IF function. Excel 2007 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. Excel 2007 AutoSum
The AutoSum feature, a shortcut to using Excel's SUM function, provides a quick way to add up columns or rows of figures in a spreadsheet. Excel 2007 SUMIF
The SUMIF function, one of Excel's math functions, is used to sum up the number of cells in a selected range that meet certain criteria. Excel 2007 COUNT Function
Excel 2007's COUNT function allows you to count up the number of cells containing numbers in a selected range. Excel 2007 COUNTIF
The COUNTIF function, one of Excel's COUNT functions, is used to count up the number of cells in a selected range that meet a certain criterion. Excel 2007 COUNTIFS Function
The COUNTIFS function, similar to Excel's COUNTIF function, is used to count up the number of cells in selected ranges that meet multiple criterion. Excel 2007 COUNTA Function
Excel 2007's COUNTA function allows you to count up the number of cells containing numbers, dates, or text labels in a selected range. Excel 2007 COUNTBLANK
The COUNTBLANK function, one of Excel's COUNT functions, is used to count up the number of cells in a selected range that meet certain criteria. Calculating Loan Payments Using Excel PMT Function
The PMT function, one of Excel's Financial functions, can be used to calculate loan repayments or the future value of an investment. This article covers using the PMT function to determine loan repayment. Excel 2007 ISBLANK Function
The ISBLANK function's job is to check to see if a certain cell is empty or not. This article shows you how to use this function Excel 2007 CELL Function
Excel's CELL function gives you information about a cell such as formatting, data type,location, and whether the cell has been protected or locked. This article shows you how to use this function in an Excel spreadsheets. Excel 2007 ISNUMBER Function
The ISNUMBER function's job is to check to see if the data in a certain cell is a number or not. This article shows you how to use this function. Calculating Future Value Using Excel's PMT Function
Future value of investments is one use for the Excel PMT function. This article includes an example of using the PMT function in Excel 2007 to determine future value. Excel 2007 AVERAGEIF
The AVERAGEIF function, one of Excel's statistical functions, is used to find the average of values in cells that meet certain criteria. Excel 2007 TRANSPOSE Function
The TRANSPOSE function, one of Excel's Lookup & Reference functions, is used to transfer data located in a row into a column or data located in a column into a row. Excel 2007 ROUND Function
The ROUND function, one of Excel's math functions, is used to reduce a number to a specific number of decimal places. Excel 2007 ROUNDDOWN Function
The ROUNDDOWN function, one of Excel's math functions, is used to round a number downwards towards the next lowest number. Excel 2007 ROUNDUP Function
The ROUNDUP function, one of Excel's math functions, is used to round a number upwards towards the next highest number. Random Numbers in Excel 2007
Generate random numbers in Excel. This tutorial has a step by step example of how to produce random numbers in Excel. Excel 2007 RANDBETWEEN Function
Generate random numbers in Excel using the RANDBETWEEN function. This tutorial has a step by step example. Excel 2007 RADIANS Function
Since Excel's, trig functions use radians, we often need a way of converting angles measured in degrees to radians. The RADIANS function, one of Excel's math functions, does just that. Excel 2007 SIN Function
Excel's list of functions includes a number of the most common trigonometric functions. These include the SIN function which gives you the sine of an angle measured in radians. Excel 2007 COS Function
Excel's list of functions includes a number of the most common trig functions. These include the COS function which gives you the cosine of an angle measured in radians. Excel 2007 TAN Function
Excel's list of functions includes a number of the most common trigonometric functions. These include the TAN function which gives you the tangent of an angle measured in radians. Excel 2007 CONVERT Function
The CONVERT function, one of Excel's engineering functions, is used to convert measurement data from one set of units to another. Excel 2007 PRODUCT Function
Multiplying numbers in Excel can be done with the PRODUCT function. This article shows you how to use the function along with a step by step example Excel 2007 TODAY Function
The TODAY function, one of Excel's date functions, is used to add the current date to a spreadsheet. Excel 2007 NOW Function
The NOW function, one of Excel's date and time functions, is used to add the current time and date to a spreadsheet. Excel 2007 DATE Function
The DATE function, one of Excel's date and time functions, can be used to add a date to a spreadsheet. This article includes an example of using the DATE function. Excel 2007 NETWORKDAYS Function
The NETWORKDAYS function can be used to find the number of working days for a project. This article includes an example of using the NETWORKDAYS function in Excel 2007. Excel 2007 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 in Excel 2007 Excel 2007 AND Function
The AND 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 the AND function in Excel 2007 Excel SUM Function
The Excel SUM function is probably the most often used function in Excel spreadsheets. The AutoSUM button on the Standard toolbar makes it easy to quickly sum columns or rows of adjacent data without actually typing in the cell references. Excel Auto SUM
The Excel Auto SUM is a shortcut to using the SUM function. By using the icon on the standard toolbar, you can quickly enter the SUM function into your spreadsheet. Excel 2007 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 Excel's MAX function. Excel 2007 MIN Function
The MIN 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 Excel's MIN function. Excel 2007 AVERAGE Function
The AVERAGE function, one of Excel's statistical functions, is used to find the average value in a given list of arguments. This article includes an example to walk you through using Excel's AVERAGE function. Excel 2007 MEDIAN Function
The MEDIAN function, one of Excel's statistical functions, gives you the middle value from a list of numbers. This article includes an example to walk you through using Excel's MEDIAN function. Excel 2007 MODE Function
The MODE function, one of Excel's statistical functions, tells you the most frequently occurring value in a list of numbers. This article includes an example to walk you through using Excel's MODE function. Excel 2007 RANK Function
The RANK function, one of Excel's statistical functions, ranks the size of a number compared to other numbers in a list. This article includes an example to walk you through using Excel's RANK function. Excel 2007 SMALL Function
The SMALL function, one of Excel's statistical functions, can be used to find data based on relative size. This article includes an example to walk you through using Excel's SMALL function. Excel 2007 LARGE Function
The LARGE function, one of Excel's statistical functions, can be used to find data based on relative size. This article includes an example to walk you through using Excel's LARGE function. Excel 2007 CONCATENATE Function
The CONCATENATE function, one of Excel's text functions, is used to join two or more words or text strings together. This article includes an example to walk you through using Excel's CONCATENATE function. Excel 2007 LEFT Function
The LEFT function, one of Excel's text functions, is used to remove unwanted characters from the right side of a data entry. This article includes an example to walk you through using Excel's LEFT function. Excel 2007 RIGHT Function
The RIGHT function, one of Excel's text functions, is used to remove unwanted characters from the right side of a data entry. This article includes an example to walk you through using Excel's RIGHT function. Excel 2007 MID Function
The MID function, one of Excel's text functions, is used to remove unwanted characters from both the left and right sides of a data entry. This article includes an example to walk you through using Excel's MID function. Excel 2007 TRIM Function
The TRIM function, one of Excel's text functions, is used to remove extra spaces from a text entry. This article includes an example to walk you through using Excel's TRIM function. SUM and AutoSUM Step by Step Tutorial
This step by step tutorial walks through how to use Excel's SUM function and the AutoSUM feature to perform spreadsheet calculations. AutoSUM AV ( Audio Visual) Tutorial
Next in our series on The SUM and AutoSUM function is an Audio Visual tutorial that takes you through several examples of using AutoSum. Excel's COUNT Function
Excel's COUNT function is a very useful function. What it does is count up the number of cells containing numbers in a selected range. Excel's COUNTA Function
A very useful, yet little known function in Excel is COUNTA, which will count up the number of cells containing data – either numbers or labels in a selected range. 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 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 AND Function
The AND function is one of Excel’s “Logical Functions”. Like most logical functions, the AND 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 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 this function. Excel MIN Function
The MIN function, one 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 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 HLOOKUP
Excel’s HLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This article covers how to create a HLOOKUP function in Excel, including an example. Excel PRODUCT Function
In Excel, a function is just a built-in formula. Functions have been added to spreadsheets to simplify performing specific mathematical operations in the spreadsheet. The PRODUCT function can be used when multiplying numbers or a range of values together. Excel QUOTIENT Function
The QUOTIENT function, one of Excel’s math functions, is used to divide numbers in Excel. This article includes an example to walk you through using the QUOTIENT function. Using Labels in Excel Functions and Formulas
Using labels in functions and formulas in Excel is a easy way to refer to a block of data in an Excel spreadsheet. Labels refer to the data directly under or to the right of a label such as "January". Using labels in a formula or function is often easier then trying to pin point the exact cell references of your data. |
Las Vegas on a BudgetFind a BargainHotel DealsCheap EatsFree AttractionsEntertainment for Less |
All Topics | Email Article | |  |  |
| Advertising Info | News & Events | Work at About | SiteMap | Reprints | Help | Our Story | Be a Guide |
| User Agreement | Ethics Policy | Patent Info. | Privacy Policy | ©2008 About, Inc., A part of The New York Times Company. All rights reserved. |