Updated Articles and Resources

By Ted French, About.com Guide

Find Subtotals in an Excel Data Table Created: Friday, June 18, 2010 Updated: Thursday, May 24, 2012
Excel's Subtotal feature lets you find subtotals, average, max, and min values in a table of data. The step by step tutorial includes examples of how to find subtotals using the Excel Subtotal fea...
Find Averages with Excel's Subtotal Feature Created: Sunday, June 06, 2010 Updated: Thursday, May 24, 2012
Excel's Subtotal feature lets you find average values using the AVERAGE function in a database or table of data. This step by step tutorial includes an example of how to find an average value for y...
Excel Spreadsheets Glossary of Terms - Rounding Definition Created: Monday, March 19, 2012 Updated: Wednesday, May 23, 2012
Definition of the term Rounding as it is used in spreadsheet programs such as Excel.
Truncating Data in Excel Created: Tuesday, May 22, 2012 Updated: Wednesday, May 23, 2012
The hows and whys for truncating text and numerical data in Excel. The tutorial includes links to truncating functions in Excel.
Entering Data in Excel Tutorial Created: Tuesday, August 15, 2006 Updated: Tuesday, May 22, 2012
Learn how to enter data into an Excel spreadsheet. Topics covered include planning the spreadsheet, cells and cell references, data types, widening columns and editing cells.
Truncate Numbers in Excel with the TRUNC Function Created: Thursday, January 05, 2012 Updated: Tuesday, May 22, 2012
The TRUNC function in Excel can be used to truncate a number. This tutorial includes a step by step example of how to truncate numbers in Excel using the TRUNC function.
Excel TRUNC Function Created: Thursday, July 30, 2009 Updated: Tuesday, May 22, 2012
The Excel TRUNC function does not round numbers. It shortens the decimal part of a number to a set number of decimal places. This tutorial includes a step by step example of using the TRUNC function.
Excel Spreadsheets Glossary of Terms - Truncate Definition Created: Friday, March 16, 2012 Updated: Tuesday, May 22, 2012
Definition of the term Truncate as it is used in spreadsheet programs such as Excel.
Excel Data Entry Form Tutorial Created: Friday, July 17, 2009 Updated: Tuesday, May 22, 2012
This tutorial covers how to use a data entry form to add data to a database in Excel. A step by step example of how to create and use a data entry form is included in the tutorial.
Count Days Between Two Dates in Excel Created: Monday, August 31, 2009 Updated: Monday, May 21, 2012
The tutorials listed here cover Excel functions that will count the number of days between two dates. Each tutorial includes a step by step example of using the functions.
Excel TYPE Function - Excel 2007 TYPE Function Created: Thursday, September 11, 2008 Updated: Monday, May 21, 2012
Excel's TYPE function gives you information about the type of data located in a cell. This article shows you how to use this function in an Excel spreadsheet.
Excel DEGREES Function Created: Wednesday, September 03, 2008 Updated: Monday, May 21, 2012
The DEGREES function in Excel converts angles measured in radians to degrees. This tutorial includes a step by step example of converting radians to degrees
Excel TAN Function Created: Monday, September 03, 2007 Updated: Monday, May 21, 2012
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 Sine Function Created: Monday, September 03, 2007 Updated: Monday, May 21, 2012
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 Cosine Function Created: Wednesday, August 29, 2007 Updated: Monday, May 21, 2012
Excel's list of functions includes a number of the most common trigonometric functions. These include the COS function which gives you the cosine of an angle measured in radians.
Excel DATE Function Created: Monday, December 07, 2009 Updated: Monday, May 21, 2012
When entering dates into a worksheet that will be used in calculations, it is a good idea to entering them using the DATE function to avoid problems that can arise if Excel reads the date as text.
Excel INFO Function - Excel 2007 INFO Function Created: Wednesday, February 25, 2009 Updated: Monday, May 21, 2012
Excel's INFO function gives out information on a number of items related to the current spreadsheet such as the current file's location, the number of worksheets open in the current workbook, and e...
Excel ISNUMBER Function - Excel 2007 ISNUMBER Function Created: Monday, December 31, 2007 Updated: Monday, May 21, 2012
The ISNUMBER function's job is to check to see if a certain cell contains a number or not. This article shows you how to use this function.
Excel CELL Function - Excel 2007 CELL Function Created: Wednesday, December 26, 2007 Updated: Monday, May 21, 2012
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 i...
Excel ISBLANK Function - Excel 2007 ISBLANK Function Created: Saturday, December 22, 2007 Updated: Monday, May 21, 2012
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
PMT - Excel 2007 PMT - Excel PMT Function Created: Tuesday, October 23, 2007 Updated: Monday, May 21, 2012
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.
PMT - Excel PMT Function Created: Saturday, October 20, 2007 Updated: Monday, May 21, 2012
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 in Excel 2007 to dete...
Excel MIN Function - Excel MIN Function Tutorial Created: Saturday, December 16, 2006 Updated: Monday, May 21, 2012
The MIN function is used to find the smallest or minimum value in a given list of numbers. This article includes an example to walk you through using the MIN function in Excel.
Excel COUNTIFS Function Step by Step Tutorial Created: Tuesday, June 14, 2011 Updated: Monday, May 21, 2012
Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTI...
Excel SUMIFS Function - Excel SUMIFS Function Tutorial Created: Sunday, May 22, 2011 Updated: Monday, May 21, 2012
The Excel SUMIFS function is used to sum up the number of cells in a selected range that meet certain criteria. This tutorial contains a step by step example of using the SUMIFS function in Excel.
AVERAGEIFS - Excel AVERAGEIFS Function Tutorial Created: Saturday, May 14, 2011 Updated: Monday, May 21, 2012
The AVERAGEIFS function finds the average value for a range of cells - but only if those values meet the criteria that you set. This tutorial includes a step by step example of using Excel's AVERAG...
COUNTIF Function - Excel COUNTIF Function Tutorial Created: Wednesday, April 20, 2011 Updated: Monday, May 21, 2012
Excel's COUNTIF function is used to count up the number of times specific data is found in a selected group of cells. This tutorial includes a step by step example of using the COUNTIF function in ...
SUMIF Function - Excel SUMIF Function Tutorial Created: Wednesday, April 13, 2011 Updated: Monday, May 21, 2012
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. This tutorial contains a step by step example of using the S...
Excel TRANSPOSE Function Created: Monday, October 15, 2007 Updated: Monday, May 21, 2012
The TRANSPOSE function is used to transfer data located in a row into a column or data located in a column into a row. This tutorial includes a step by step example of using Excel's TRANSPOSE funct...
Excel COUNTA - How to Use Excel COUNTA Function - Using Excel COUNTA Created: Saturday, September 30, 2006 Updated: Monday, May 21, 2012
Excel's COUNTA function is a very useful, yet little known function. What it does is count up the number of cells containing data – either numbers or labels in a selected range.
AVERAGE IF - Excel AVERAGE IF Function Tutorial Created: Monday, April 04, 2011 Updated: Monday, May 21, 2012
The AVERAGE IF function finds the average value for a range of cells - but only if those values meet specific criteria. This tutorial includes a step by step example of using Excel's AVERAGE IF fun...
Excel Lookup Formula with Multiple Criteria Created: Friday, March 25, 2011 Updated: Monday, May 21, 2012
How to create a Lookup formula that uses multiple criteria in Excel. This tutorial includes a step by step example of creating a lookup function with multiple criteria in Excel.

A part of The New York Times Company.