Updated Articles and Resources

By Ted French, About.com Guide

Edit Cells with the F2 Function Key in Excel Created: Sunday, May 19, 2013 Updated: Tuesday, May 21, 2013
Quickly edit the contents of a cell using the F2 key in Excel.
Entering Data in Excel Created: Tuesday, August 15, 2006 Updated: Monday, May 20, 2013
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.
Insertion Point Created: Monday, May 20, 2013 Updated: Monday, May 20, 2013
Definition of the term "insertion point" as it is used in spreadsheet programs such as Excel.
Excel ISBLANK Function Created: Saturday, December 22, 2007 Updated: Monday, May 20, 2013
The ISBLANK function's job is to check to see if a certain cell is empty or not. This tutorial includes an example of how to use this function.
Excel Watermark Step by Step Tutorial Created: Saturday, December 10, 2011 Updated: Monday, May 20, 2013
This tutorial covers how to insert a watermark into an Excel worksheet. The tutorial includes a step by step example of how to insert a watermark in Excel.
Cell Reference Created: Thursday, August 17, 2006 Updated: Tuesday, May 14, 2013
Definition of the term "Cell Reference" as it is used in spreadsheet programs such as Excel.
Excel Conditional Formatting Date Formula Created: Sunday, May 12, 2013 Updated: Sunday, May 12, 2013
Using formulas to customize conditional formatting rules in Excel. This tutorial uses a date formula and conditional formatting to highlight past due dates. A step by step example is included.
Conditional Format Created: Thursday, November 29, 2012 Updated: Saturday, May 11, 2013
Definition of the term "conditional format" as it is used in spreadsheet programs such as Excel.
Excel TODAY Function Created: Wednesday, September 05, 2007 Updated: Saturday, May 11, 2013
The TODAY function can be used to add today's date to a spreadsheet. This tutorial includes a step by step example of using Excel's TODAY function.
Unhide Rows in Excel Created: Tuesday, August 14, 2007 Updated: Thursday, May 09, 2013
This tutorial shows you how, with a click of the mouse, you can easily unhide rows in Excel spreadsheets.
Create a Pictograph in Excel Created: Wednesday, March 05, 2008 Updated: Monday, May 06, 2013
In a pictograph, pictures replace the colored columns or bars in a regular column chart or bar graph. This step by step tutorial shows you how to create a pictograph in Excel.
Excel Conditional Formatting Created: Sunday, August 23, 2009 Updated: Saturday, May 04, 2013
These tutorials cover using conditional formatting in Excel. The tutorials include step by step examples of using conditional formatting in Excel.
Excel Conditional Formatting Data Created: Thursday, May 02, 2013 Updated: Saturday, May 04, 2013
Conditional formatting allows you to emphasis data that meets certain conditions - such as equal to, greater than, or less than - that you set. If the data meets the set conditions, formatting opti...
Excel SUM OFFSET Formula Tutorial Created: Saturday, April 20, 2013 Updated: Monday, April 29, 2013
By combining Excel's OFFSET function with the SUM function you can create formulas that will find totals for dynamic ranges of data. This tutorial includes a step by step example.
Excel LOOKUP Function Tutorial Created: Sunday, January 13, 2013 Updated: Sunday, April 28, 2013
The Array form of Excel's LOOKUP function can be used to find a single value from a multi-row or multi-column range of data. A step by step example of using the array form of the LOOKUP function is...
Excel CONCATENATE Function Created: Wednesday, August 01, 2007 Updated: Sunday, April 28, 2013
The CONCATENATE function is used to join two or more words or text strings together. This tutorial includes a step by step example of using Excel's CONCATENATE function.
Circular Reference Created: Thursday, April 25, 2013 Updated: Thursday, April 25, 2013
Definition of the term "circular reference" as it is used in spreadsheet programs such as Excel.
Chart Wizard Created: Friday, August 18, 2006 Updated: Thursday, April 25, 2013
Definition of the term "chart wizard" as it is used in spreadsheet programs such as Excel.
Excel OFFSET Function Tutorial Created: Saturday, April 06, 2013 Updated: Thursday, April 25, 2013
Excel's OFFSET function can be used to refer to the location of specific data in an Excel worksheet. The function is usually combined with other functions to create more complex formulas such as SU...
Find Above or Below Average Numbers in Excel Created: Friday, December 08, 2006 Updated: Wednesday, April 24, 2013
Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells based on the data entered into the cell(s). This tutorial includ...
Excel 2003 Conditional Formatting Created: Tuesday, May 26, 2009 Updated: Wednesday, April 24, 2013
This tutorial shows you how to use conditional formatting to find above and below average numbers in Excel. A step by step example is included.
Select All Cells in Excel Created: Friday, October 31, 2008 Updated: Wednesday, April 24, 2013
This Excel tip covers how to select all cells in Excel using a keyboard shortcut.
Apply Number Formatting Created: Wednesday, April 24, 2013 Updated: Wednesday, April 24, 2013
This Excel shortcut keys tutorial shows you how to quickly applying number formatting to selected cells using just the keyboard.
Insert and Delete Columns and Rows in Excel Created: Sunday, December 10, 2006 Updated: Wednesday, April 24, 2013
This series of tutorials cover the basics of how to insert and delete columns and rows in Excel worksheets. It is often necessary to alter the layout of a worksheet due to the addition or removal o...
Excel Math Created: Monday, November 13, 2006 Updated: Wednesday, April 24, 2013
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.
Free Microsoft Excel Tutorial Series Created: Wednesday, November 01, 2006 Updated: Wednesday, April 24, 2013
Each tutorial in this free series covers either an introductory or intermediate level topic in Microsoft Excel. The tutorials include step by step examples related to each topic.
Excel IF Functions Created: Saturday, October 14, 2006 Updated: Wednesday, April 24, 2013
This series of articles and tutorials the basics of using IF functions to perform calculations in Excel.
Basic Calculations in Excel Spreadsheets Created: Saturday, August 26, 2006 Updated: Wednesday, April 24, 2013
This series of Excel Tutorials will teach you the basics of using formulas and functions to perform basic calculations in Excel spreadsheets.
Excel Pivot Table Tutorials Created: Tuesday, September 29, 2009 Updated: Wednesday, April 24, 2013
These tutorials cover how to create a pivot table in Excel. Each tutorial includes a step by step example of how to create a pivot table in Excel.
Excel Error Message Help Created: Wednesday, September 16, 2009 Updated: Wednesday, April 24, 2013
If you get an error message in Excel you might not get much help from the program in finding out the cause. The articles listed here cover the cause and cures for a number of common error messages ...
Learn Excel Created: Friday, September 04, 2009 Updated: Wednesday, April 24, 2013
This series of tutorials will help you learn the small things in Excel that are often overlooked in other tutorials. Learn how to how to add a new worksheet, how to wrap text in a cell, learn how t...
Excel Drop Down List Tutorials Created: Friday, August 28, 2009 Updated: Wednesday, April 24, 2013
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. These tutorials include step by step examples of how to create a drop down list in Excel .

Spreadsheets