1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.
Ted French

Updated Articles and Resources

By Ted French

    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.

    ©2014 About.com. All rights reserved.