1. Computing
Send to a Friend via Email
Ted French

Updated Articles and Resources

By Ted French

    Updated Articles and Resources
    • Excel Tips Created: Sunday, October 22, 2006 Updated: Thursday, April 17, 2014
      This list of Excel tips will give you straightforward answers on how to carry out a variety of tasks in Microsoft Excel." itemprop="description">>
    • Excel Shortcut Keys - Undo Created: Thursday, October 23, 2008 Updated: Thursday, April 17, 2014
      This Excel shortcut key tutorial shows you how to "undo" changes made in Excel using a keyboard key combination.
    • Remove a Drop Down List in Excel Created: Saturday, October 20, 2012 Updated: Thursday, April 17, 2014
      This tutorial covers how to remove a drop down list and other data validation options from an Excel worksheet.
    • Using Cell References in Excel Formulas Created: Friday, November 24, 2006 Updated: Thursday, April 17, 2014
      Cell references describe the location of a cell in an Excel spreadsheet. These cell references can be used in formulas. Excel will calculate the answer for the formula using the data located in th...
    • Adding the Current Time Created: Sunday, September 28, 2008 Updated: Thursday, April 17, 2014
      This Excel shortcut keys tutorial shows you how to quickly add the current time to a worksheet using just the keyboard.
    • Turn Off AutoComplete in Excel Created: Monday, June 22, 2009 Updated: Thursday, April 17, 2014
      This quick tip covers how to turn AutoComplete on or off in Excel.
    • Basic Calculations in Excel Spreadsheets Created: Saturday, August 26, 2006 Updated: Thursday, April 17, 2014
      This series of Excel Tutorials will teach you the basics of using formulas and functions to perform basic calculations in Excel spreadsheets." itemprop="description" Friday, August 25, 2006 Updated: Thursday, April 17, 2014
      Definition of the term "fill handle" as it is used in spreadsheet programs such as Excel.
    • Excel SUMIFS Function Created: Wednesday, January 07, 2009 Updated: Thursday, April 17, 2014
      The SUMIFS function, similar to Excel's SUMIF function, is used to add up the contents of cells in a selected range that meet multiple criteria. This tutorial includes a step by step example of usi...
    • Worksheet Created: Thursday, August 17, 2006 Updated: Thursday, April 17, 2014
      Definition of the term "Worksheet" as it is used in spreadsheet programs such as Excel.
    • Add the Data Entry Form to the Quick Access Toolbar Created: Friday, July 17, 2009 Updated: Thursday, April 17, 2014
      The Quick Access Toolbar is used to store shortcuts to frequently used features in Excel. This tutorial shows you how to add the data form button to the Quick Access Toolbar.
    • Excel OR Function Created: Sunday, January 06, 2008 Updated: Thursday, April 17, 2014
      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 fu...
    • Excel Negative Number Format Created: Sunday, August 30, 2009 Updated: Thursday, April 17, 2014
      This tutorial covers how to format negative numbers in Excel to display in a different color. A step by step example is included in the tutorial.
    • Excel SUMPRODUCT Function Tutorial Created: Wednesday, August 23, 2006 Updated: Thursday, April 17, 2014
      Excel's SUMPRODUCT function can be used to sum the values in cells that fall between set high and low points in your data. A step by step example is included with this tutorial.
    • Convert Text to Numbers in Excel Created: Wednesday, June 01, 2011 Updated: Thursday, April 17, 2014
      How to convert text data to numbers in Excel using the VALUE function. This tutorial contains a step by step example of how to convert text data to numbers in Excel using the VALUE function.
    • Excel's Vlookup Function Created: Tuesday, July 22, 2008 Updated: Thursday, April 17, 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.
    • Unhide Rows in Excel Created: Tuesday, August 14, 2007 Updated: Thursday, April 17, 2014
      This tutorial shows you how, with a click of the mouse, you can easily unhide rows in Excel spreadsheets.
    • Sort by Multiple Columns of Data in Excel Created: Wednesday, August 26, 2009 Updated: Thursday, April 17, 2014
      Sort by multiple columns of data using Excel's custom sort feature. This tutorial includes a step by step example of how to sort by multiple columns of data in Excel.
    • Excel MID Function Created: Saturday, September 22, 2007 Updated: Thursday, April 17, 2014
      The MID function is used to remove unwanted characters from both the left and right sides of a data entry. This tutorial includes an example to walk you through using Excel's MID function.
    • Excel MAX IF Array Formula Tutorial Created: Monday, April 26, 2010 Updated: Thursday, April 17, 2014
      By combining the MAX and the IF functions in an array formula in Excel, we can find the largest or maximum value for a range of data when a specific criterion is met. A step by step example is incl...
    • Excel Macro Tutorial Created: Thursday, July 03, 2008 Updated: Thursday, April 17, 2014
      This step by step tutorial covers how to create simple macros in Excel using the macro recorder.
    • Excel DAY Function Created: Tuesday, July 28, 2009 Updated: Thursday, April 17, 2014
      Use the DAY function to subtract dates in Excel. This tutorial includes an example of using the DAY function to subtract two dates in Excel.
    • Excel TRANSPOSE Function Created: Monday, October 15, 2007 Updated: Thursday, April 17, 2014
      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...
    • Rounding Numbers in Excel Created: Thursday, June 30, 2011 Updated: Thursday, April 17, 2014
      Rounding numbers in Excel can be accomplished with a number of different functions - depending on the results you want. The ROUND function can be used to round a value either up or down a specific ...
    • Excel ROUNDUP Function Created: Tuesday, April 22, 2008 Updated: Thursday, April 17, 2014
      The ROUNDUP function, one of Excel's math functions, is used to round a number upwards towards the next highest number. This tutorial includes a step by step example of using Excel's ROUNDUP functi...
    • Parts of the Excel 2010 Screen Created: Thursday, July 01, 2010 Updated: Thursday, April 17, 2014
      This labeled diagram shows the main parts of the Excel screen. Descriptions for each screen part is included.
    • Free Excel Biweekly Time Sheet Template Created: Saturday, August 01, 2009 Updated: Thursday, April 17, 2014
      This article shows you how to quickly download and use a free employee time sheet template in Excel.
    • Excel Pivot Tables Step by Step Tutorial Created: Friday, September 12, 2008 Updated: Thursday, April 17, 2014
      Pivot tables makes it easy to organize and extract information from a large tables of data without the use of formulas in Excel. A step by step tutorial example is included in the tutorial.
    • Excel Formulas Step by Step Tutorial Created: Wednesday, August 16, 2006 Updated: Thursday, April 17, 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.
    • Microsoft Works Task Launcher Created: Saturday, December 30, 2006 Updated: Thursday, April 17, 2014
      This tip shows you how to open a template or blank Microsoft Works Spreadsheet from the Microsoft Works Task Launcher. The article covers using the quick launch icon and the programs icon.
    • Data for Excel 2007 Pivot Table Tutorial Created: Thursday, August 20, 2009 Updated: Thursday, April 17, 2014
      This document contains pivot table data for the Excel 2007 pivot table tutorial. The pivot table data is to be copied and pasted into the tutorial worksheet." itemprop="de"$zTP='t3'" --> itemprop=...
    • Column Created: Monday, August 14, 2006 Updated: Thursday, April 17, 2014
      Definition of the term "column" as it is used in spreadsheet programs such as Excel.

    ©2014 About.com. All rights reserved.