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
Definition of the term "view formulas" as used in spreadsheet programs like Excel and Google Spreadsheets. 
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
Definition of the term radian as used in spreadsheet programs such as Excel and Google Spreadsheets. 
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
Definition of the term. Spreadsheets. 
Excel's Vlookup Function
Created:
Tuesday, July 22, 2008
Updated:
Wednesday, July 16, 2014
This tutorial is a text only version of how to use Excel's VLOOKUP function. It is intended for those familiar with Excel functions. 
Calculate a Project End Date in Excel
Created:
Thursday, March 15, 2012
Updated:
Sunday, July 13, 2014
The NETWORKDAYS.INTL function can be used to calculate the number of days between two dates in Excel. A step by step example is included with this tutorial. 
Excel IF Function
Created:
Sunday, August 05, 2007
Updated:
Saturday, July 12, 2014
The IF function tests to see if a certain condition in a spreadsheet is true or false. This tutorial includes an example of using the IF function in Excel. 
Microsoft Excel Format Tutorial
Created:
Thursday, February 17, 2011
Updated:
Friday, July 11, 2014
This tutorial includes step by step examples of how to apply basic format techniques in Excel, such as shading alternate rows, widening columns, and more.