• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Updated Articles and Resources

Updated Articles and Resources
• Excel Undo Tutorial Created: Saturday, March 12, 2011 Updated: Thursday, July 31, 2014
This tutorial shows you how to use Excel's Undo feature to quickly get back accidentally deleted data or reverse other changes made to a spreadsheet. This tutorial includes a step by step example o...
• How to Create a Database in Excel Created: Friday, November 10, 2006 Updated: Thursday, July 31, 2014
This step by step tutorial shows you how to create a database in Excel. The tutorial covers entering data, creating the database, and using the built in sorting and filter tools.
• View Formulas Created: Sunday, June 22, 2014 Updated: Thursday, July 31, 2014
• Show Formulas in Excel Created: Tuesday, November 28, 2006 Updated: Thursday, July 31, 2014
Show formulas allows you to quickly show all the formulas in your Excel Spreadsheet. Doing so does not change your spreadsheet, just the way it is displayed. Show formulas allows you to quickly and easily check your spreadsheet for errors in your formulas.
• Excel Formulas Step by Step Tutorial Created: Wednesday, August 16, 2006 Updated: Wednesday, July 30, 2014
This tutorial is intended for those just getting started with Excel. This tutorial covers basic information about formulas and walks you through creating a simple example in Excel.
• Excel Line Graph Tutorial Created: Thursday, May 10, 2007 Updated: Wednesday, July 30, 2014
This tutorial covers how to create a line graph in Microsoft Excel . The tutorial includes a step by step example of how to create a line graph in Excel.
• How to use Excel's VLOOKUP Function Created: Sunday, December 17, 2006 Updated: Tuesday, July 29, 2014
How to use VLOOKUP in Excel to retrieve specific data from a database or table of data. A step by step example is included.
• Find the Tangent of an Angle in Google Spreadsheets Created: Tuesday, July 01, 2014 Updated: Tuesday, July 29, 2014
How to find the tangent of an angle using the TAN function in Google Spreadsheets. This tutorial includes a step by step example of how to how to use the TAN function in Google Spreadsheets.
• Radian Created: Tuesday, July 01, 2014 Updated: Tuesday, July 29, 2014
• Excel Math Created: Monday, November 13, 2006 Updated: Tuesday, July 29, 2014
These tutorial cover how to carry out basic math operations in Excel using formulas. The tutorials cover how to add, subtract, multiply, or divide numbers in Excel using formulas."
• How to Use Excel - Excel Tutorials for Beginners Created: Wednesday, August 23, 2006 Updated: Tuesday, July 29, 2014
How to Use Excel is a series of free Excel tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, how to use Excel formulas and functions, adding and rem...
• Excel AVERAGEIFS Function Step by Step Tutorial Created: Saturday, May 14, 2011 Updated: Tuesday, July 29, 2014
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...
• Ignore Errors when Finding the Average in Excel Created: Sunday, May 06, 2007 Updated: Tuesday, July 29, 2014
The AVERAGE IF function is used to find the average of values in cells that meet certain criteria.
• Excel ISNUMBER Function Created: Monday, December 31, 2007 Updated: Monday, July 28, 2014
The ISNUMBER function's job is to check to see if a certain cell contains a number or not. This tutorial includes a step by step example.
• Count in Excel Created: Sunday, November 19, 2006 Updated: Monday, July 28, 2014
Excel's COUNT function can be used to count up the number of cells containing numbers in a selected range. This tutorial includes a step by step example of using the COUNT function in Excel
• Calculate the Percentage of Specific Values in Excel Created: Friday, July 20, 2007 Updated: Monday, July 28, 2014
Find the percentage of yes or no responses in a data range using the COUNTIF and COUNTA functions in Excel. The same formula can be used to find the percentage of any one value - not just yes and no. This tutorial includes a step by step example.
• Paste a Link Between Charts in Excel Created: Monday, March 10, 2008 Updated: Monday, July 28, 2014
Use Excel's paste options to create a link between charts located on different worksheets or in different Excel files. All linked charts will update if the source data changes. A step by step example on linking charts is included.
• Excel Redo Tutorial Created: Sunday, March 13, 2011 Updated: Sunday, July 27, 2014
Use Excel's Redo feature to reapply changes to a worksheet after they have been removed using Undo. This tutorial includes a step by step example of using Excel's Redo feature.
• Excel IF Function Created: Saturday, July 26, 2014 Updated: Saturday, July 26, 2014
One of the most useful functions in Excel is the IF function. What it does is test a value in a specific cell to see if that value meets a certain condition. If it does, one result will happen, if not, a different action can occur. This article covers how to write an IF function.
• Excel MAX IF Formula Created: Tuesday, July 24, 2007 Updated: Saturday, July 26, 2014
This tutorial uses a MAX - IF array formula in Excel to find the largest positive or negative value for a range of data. A step by step example is included.
• Excel COUNTA Function Created: Saturday, September 30, 2006 Updated: Saturday, July 26, 2014
Excel's COUNTA function only counts cells that contain data such as text, numbers, or formulas. It will ignore blank or empty cells in a range. This tutorial includes a step by step example.
• Save in Excel Using Shortcut Keys Created: Sunday, August 07, 2011 Updated: Friday, July 25, 2014
This Excel shortcut keys tutorial shows you how to quickly save a worksheet using just the keyboard.
• Transpose Data in Excel using Paste Special Created: Monday, August 02, 2010 Updated: Friday, July 25, 2014
A quick and easy way in Excel to transpose data from rows to columns or vice versa is to use paste special. No functions, no formulas, no cell references required. This tutorial includes a step by ...
• Link Two Files in Excel with Paste Link Created: Friday, July 11, 2014 Updated: Friday, July 25, 2014
Link data located in two separate Excel files using Paste Link. When the source file changes the destination file will update as well. A step by step example is included.
• Type on Multiple Lines in a Single Cell Created: Sunday, August 12, 2012 Updated: Friday, July 25, 2014
This Excel shortcut keys tutorial shows you how to wrap text on to multiple lines in a single cell in a worksheet.
• Remove Duplicate Data Records in Excel Created: Friday, April 06, 2007 Updated: Tuesday, July 22, 2014
This tutorial covers how to remove rows or records of duplicate data in Excel. The tutorial includes a step by step instructions on how to remove duplicate data records in Excel.
• Save Excel Files as PDF Files Created: Monday, February 22, 2010 Updated: Thursday, July 17, 2014
Save Excel spreadsheets as PDF files in Excel. This tutorial shows you how to save Excel spreadsheets as PDF files in Excel.
• Database Created: Sunday, November 12, 2006 Updated: Thursday, July 17, 2014