Updated Articles and Resources

Calculate a Project End Date in Excel
Created:
Thursday, March 15, 2012
Updated:
Wednesday, April 23, 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. 
Spreadsheet
Created:
Thursday, August 17, 2006
Updated:
Wednesday, April 23, 2014
Definition of the term "Spreadsheet" as it is used in programs such as Excel. 
How to Divide in Google Spreadsheets
Created:
Wednesday, April 23, 2014
Updated:
Wednesday, April 23, 2014
How to divide in Google Spreadsheets shows you how easy dividing numbers can be. The tutorial includes a step by step example of how to divide two numbers in Google Spreadsheets. 
How to Subtract in Google Spreadsheets
Created:
Monday, April 21, 2014
Updated:
Wednesday, April 23, 2014
How to subtract in Google Spreadsheets shows you how easy subtracting numbers can be. The tutorial includes a step by step example of how to subtract two numbers in Google Spreadsheets. 
Entering Data in Excel
Created:
Tuesday, August 15, 2006
Updated:
Wednesday, April 23, 2014
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. 
Excel Subtotal Tutorials
Created:
Friday, June 18, 2010
Updated:
Wednesday, April 23, 2014
Excel's Subtotal feature lets you find subtotals, average, max, and min values in a table of data. The step by step tutorial includes examples of how to find subtotals using the Excel Subtotal fea... 
Cell
Created:
Monday, August 14, 2006
Updated:
Wednesday, April 23, 2014
Definition of the term "cell" as it is used in spreadsheet programs such as Excel. 
Cell Reference
Created:
Thursday, August 17, 2006
Updated:
Wednesday, April 23, 2014
Definition of the term "Cell Reference" as it is used in spreadsheet programs such as Excel. 
Move Data in Excel
Created:
Saturday, March 15, 2008
Updated:
Wednesday, April 23, 2014
How to move data from one cell to another in Excel 2007. Step by step example of moving data in Excel 2007. 
Leaving Blank Cells When Using the IF Function
Created:
Tuesday, October 10, 2006
Updated:
Tuesday, April 22, 2014
Excel's IF function can be used to leave cells blank when certain conditions are met. This tutorial includes a step by step example of how to leave blank cells in a worksheet using the IF function. 
Find Above or Below Average Numbers in Excel
Created:
Friday, December 08, 2006
Updated:
Tuesday, April 22, 2014
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 Formulas Step by Step Tutorial
Created:
Wednesday, August 16, 2006
Updated:
Tuesday, April 22, 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. 
Formula
Created:
Monday, August 14, 2006
Updated:
Tuesday, April 22, 2014
Definition of the term "Formula" as it is used in spreadsheet programs such as Excel. 
Excel ROW Function Tutorial
Created:
Sunday, December 02, 2012
Updated:
Tuesday, April 22, 2014
The Excel ROW function can be used to either find the row number for the cell where the function is located in the worksheet or find the row number for a given cell reference. A step by step exampl... 
Calculate Your Current Age with the Excel DATEDIF Function
Created:
Saturday, May 19, 2012
Updated:
Tuesday, April 22, 2014
One use for the DATEDIF function is to calculate a person's current age in years, months, and days. This tutorial includes a step by step example of using the DATEDIF function to calculate current ... 
Excel 2007 Spreadsheet Print Options Part 2
Created:
Saturday, September 18, 2010
Updated:
Tuesday, April 22, 2014
This tutorial covers how to set a print area, print an entire spreadsheet, or print just selected areas in Excel. 
Using Labels in Excel Formulas and Functions
Created:
Thursday, August 24, 2006
Updated:
Tuesday, April 22, 2014
Using labels in functions and formulas in Excel 2003 is a easy way to refer to a block of data in an Excel spreadsheet. Labels refer to the data directly under or to the right of a label such as 
Creating a Drop Down List in Excel Part 2
Created:
Wednesday, June 04, 2008
Updated:
Monday, April 21, 2014
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This tutorial shows you how to create a drop down list in Excel sing data from a differe... 
Excel Math
Created:
Monday, November 13, 2006
Updated:
Monday, April 21, 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." 
Concatenate Text Data in Excel
Created:
Sunday, January 30, 2011
Updated:
Monday, April 21, 2014
Excel's CONCATENATE function can be used to combine cells of data together. This tutorial includes a step by step example of how to combine cells of data with the CONCATENATE function in Excel. 
What are Excel Headers and Footers?
Created:
Friday, August 18, 2006
Updated:
Monday, April 21, 2014
Headers and footers are used to add the same information on every page of the spreadsheet without actually typing the information on each page. Headers and footers often contain company informatio... 
Excel ROUND Function
Created:
Thursday, August 09, 2007
Updated:
Monday, April 21, 2014
The ROUND function, one of Excel's math functions, is used to reduce a number to a specific number of decimal places. This tutorial includes a step by step example of using Excel's ROUND function. 
Excel SUMIF Function Quick Tutorial
Created:
Tuesday, December 22, 2009
Updated:
Monday, April 21, 2014
The SUMIF function will total cells in a selected range that match user selected criteria. A step by step example is included in this tutorial. 
Pointing
Created:
Tuesday, August 15, 2006
Updated:
Monday, April 21, 2014
Definition of the term "pointing" as it is used in spreadsheet programs such as Excel. 
Active Cell
Created:
Monday, August 14, 2006
Updated:
Monday, April 21, 2014
Definition of the term "active cell" as it is used in spreadsheet programs such as Excel. 
Mathematical Operator
Created:
Tuesday, August 15, 2006
Updated:
Monday, April 21, 2014
Definition of the term "mathematical operators" as it is used in spreadsheet programs such as Excel. 
Order of Operations
Created:
Monday, October 16, 2006
Updated:
Monday, April 21, 2014
Definition of the term "Order of Operations" as it is used in spreadsheet programs such as Excel. 
Excel 2003 Lessons
Created:
Thursday, November 16, 2006
Updated:
Sunday, April 20, 2014
Excel lessons cover how to carry out basic operations in a spreadsheet program such as Excel. The topics deal with how to perform basic math with a spreadsheet  such as addition or subtraction; h... 
Change the Worksheet Tab Color in Excel 2003
Created:
Thursday, September 14, 2006
Updated:
Sunday, April 20, 2014
This tip covers how to change the worksheet tab color in Excel 2003. An example of how to change the worksheet tab color in Excel is included in the tutorial. 
Selecting NonAdjacent Cells in Excel Using Shortcut Keys
Created:
Saturday, February 05, 2011
Updated:
Sunday, April 20, 2014
This Excel shortcut keys tutorial shows you how to select nonadjacent cells in Excel using the just the keyboard. 
Nested Functions in Excel
Created:
Wednesday, August 24, 2011
Updated:
Saturday, April 19, 2014
How to use nested functions in Excel such as IF, AND, OR, SUM, and ROUND. A step by step example is included with each tutorial. 
Freeze Panes in Excel 2003
Created:
Monday, October 27, 2008
Updated:
Saturday, April 19, 2014
Excel's freeze panes feature allows you to lock columns and rows to keep headings from disappearing when you scroll. This tutorial shows you how to "freeze" or lock those columns and / or rows cont...