Updated Articles and Resources
- Excel 2007 Pivot Table - Excel 2007 Pivot Table TutorialCreated: 2009-11-20 @ 09:36:29 EST
This tutorial covers how to create a pivot table in Excel 2007. The step by step tutorial includes an example how to create a pivot table in Excel 2007… - Google Spreadsheet Function - Google Spreadsheet NOW FunctionCreated: 2009-11-19 @ 20:52:04 EST Updated: 2009-11-19 @ 20:55:40 EST
The NOW function, one of Google Spreadsheets' date functions, is used to add the current time and date to a spreadsheet… - Google Spreadsheet Date - Count Days between Two Dates in a Google S…Created: 2009-11-19 @ 20:31:35 EST
The NETWORKDAYS function can be used to count the number of working days between a start and end date in Google Spreadsheets. This article includes an example of using the NETWORKDAYS function to c… - Calculate Due Date - Calculate Due Date in ExcelCreated: 2009-11-10 @ 22:34:19 EST Updated: 2009-11-11 @ 09:34:37 EST
The EOMONTH function can be used to calculate a due date of a project or investment that falls on at the end of the month. This article includes an example of using the EOMONTH function to calculat… - Days Between Dates in Excel - Count Days Between Two Dates in Excel…Created: 2009-10-31 @ 08:24:02 EDT
Functions that will count the number of days between two dates in Excel 2007. Each tutorial includes a step by step example of using functions to count the number of days between two dates in Exce… - EDATE - Excel EDATE FunctionCreated: 2009-10-27 @ 20:48:01 EDT
The EDATE function can be used to calculate a due date of a project or investment that fall on the same day of the month as the date it was issued. This article includes an example of using the EDA… - Excel Negative Number - Excel Negative Number FormatCreated: 2009-10-19 @ 14:05:02 EDT
This tutorial covers how to format a negative number in Excel 2007. The tutorial includes a step by step example of how to format a negative number in Excel 2007… - Excel Sort - Sort Data in ExcelCreated: 2009-10-13 @ 21:03:02 EDT
These tutorials cover using Excel's sort feature. Excel's sort options allow you to sort by date, perform a custom sort on multiple columns, or sort by font or cell color. The tutorials include ste… - Excel Sort - Sort Data by Cell Color in ExcelCreated: 2009-10-13 @ 20:50:56 EDT Updated: 2009-10-13 @ 21:07:03 EDT
Sort data by cell color in Excel 2007. Included is a step by step example of how to sort data by cell color in Excel 2007… - Excel Sort - Sort Data by Font Color in ExcelCreated: 2009-10-06 @ 20:53:09 EDT
Sort data by font color in Excel 2007. Included is a step by step example of how to sort data by font color in Excel 2007… - Pivot Table - Excel Pivot Table TutorialsCreated: 2009-09-29 @ 09:55:46 EDT
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… - Pivot Table Data - Excel Pivot Table Tutorial DataCreated: 2009-09-22 @ 21:28:59 EDT Updated: 2009-09-22 @ 21:37:21 EDT
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… - Excel Error - Excel Error MessageCreated: 2009-09-16 @ 13:13:32 EDT Updated: 2009-09-16 @ 13:16:39 EDT
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 … - Excel AutoFormat - Excel AutoFormat TutorialCreated: 2009-09-06 @ 12:09:01 EDT Updated: 2009-09-06 @ 12:23:45 EDT
Excel 2007's Autoformat option gives you 17 AutoFormat styles to use to give your spreadsheets a professional look. Instructions on how to apply an autoformat style are included. … - Excel Toolbar - Excel Quick Access ToolbarCreated: 2009-09-06 @ 11:21:41 EDT
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 Toolbar - Excel Quick Access ToolbarCreated: 2009-09-06 @ 11:07:37 EDT Updated: 2009-09-06 @ 11:22:53 EDT
The Quick Access Toolbar is used to store shortcuts to frequently used features in Excel. This tutorial shows you how to add the autoformat button to the Quick Access Toolbar… - Learn Excel - Learn Excel 2007Created: 2009-09-04 @ 10:32:45 EDT Updated: 2009-09-04 @ 12:18:10 EDT
This series of tutorials will help you learn the small things in Excel 2007 that are often overlooked in other tutorials. Learn how to how to add a new worksheet, how to wrap text in a cell, learn … - Free Flowchart Template - Free ExcelFlowchart TemplateCreated: 2009-09-03 @ 20:29:59 EDT Updated: 2009-09-03 @ 20:35:09 EDT
This article walks through how to download and use the free flowchart template available from Microsoft. The article covers how to use the flowchart template in Excel 2007… - Count in Excel, Excel's COUNT FunctionsCreated: 2009-09-01 @ 08:42:37 EDT
Excel has a number of COUNT Functions. Each one does a different job. They can be used to count up the items in a list, the number of blank cells, the number of days between two dates, or a numbe… - Excel Date - Date Functions, Formulas, Formats, and Adding the Date …Created: 2009-08-31 @ 13:01:08 EDT
Working with the Date in Excel - how to sort by date, conditional format for date, and other tutorials are included in this list. Each tutorial listed below includes a step by step example of worki… - Excel Date - Date Functions, Formulas, Formats, and Adding the Date …Created: 2009-08-31 @ 12:26:51 EDT
The functions listed below can be used to add the current date to an Excel spreadsheet. Each tutorial includes step by step examples of working with dates in Excel 2007… - Excel Bar Graph - Free Excel Bar Graph Tutorial…Created: 2009-08-29 @ 00:53:09 EDT Updated: 2009-08-29 @ 00:59:10 EDT
These tutorials cover creating a bar graph in Excel. Each tutorial includes a step by step example of creating a bar graph in Excel 2007 or Excel 2003… - Excel Pie Chart - Free Excel Pie Chart Tutorials…Created: 2009-08-29 @ 00:08:44 EDT
Free tutorials on how to create and format a pie chart in Excel. Each tutorial includes a step by step example of how to create and format a pie chart in Excel… - Excel 2003 Charts - Excel 2003 Charts and Graphs…Created: 2009-08-28 @ 23:28:26 EDT
These tutorials cover such topics as how to create custom charts and how to change the default chart type in Excel 2003… - Excel Drop Down List Tutorial - Create a Drop Down List in Excel…Created: 2009-08-28 @ 13:24:15 EDT
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… - Excel Data Entry - Excel Data Entry FormCreated: 2009-08-28 @ 12:45:43 EDT Updated: 2009-08-28 @ 12:49:34 EDT
These tutorials cover how to use a form for data entry in an Excel database. There are separate tutorials for Excel 2007 and Excel 2003. Each tutorial includes a step by step example of how to use … - Data Entry Form - Excel Data Entry FormCreated: 2009-08-28 @ 11:57:12 EDT
This article covers how to use a data entry form to add data to a database in Excel 2007. A step by step example of how to create and use a data entry form is included in the article… - Excel Database Tutorial - Free Excel Database Tutorial…Created: 2009-08-28 @ 11:33:59 EDT
Free tutorial on creating database in Excel 2007 and Excel 2003. The step by step tutorial includes an example of creating a database in either version of Excel… - Excel Rounding - Rounding Numbers in ExcelCreated: 2009-08-27 @ 17:18:22 EDT
Rounding data in Excel is a very common task. As a result, there are number of rounding functions and each one does a slightly different job. One rounds up, one rounds down, a third removes all de… - Free Spreadsheet - Free Spreadsheet Tutorials…Created: 2009-08-27 @ 17:18:06 EDT
Listed here are tutorials on free spreadsheet programs such as Google Spreadsheets and OpenOffice Calc. The tutorials are also free. The tutorials cover a variety of topics about creating and usin… - Excel Sort - Sort By Multiple Columns in ExcelCreated: 2009-08-26 @ 11:58:42 EDT Updated: 2009-08-26 @ 12:42:10 EDT
Sort by multiple columns of data using Excel 2007's custom sort feature. Step by step example of how to sort by multiple columns of data in Excel 2007… - Excel Sort Date - Sort by Date in ExcelCreated: 2009-08-26 @ 09:44:37 EDT
Sort by Date using Excel 2007's sort feature. Step by step example of how to sort by date in Excel 2007… - Free Excel Templates - Free Excel Worksheet TemplatesCreated: 2009-08-24 @ 13:15:21 EDT
This article covers templates in Excel: how to make your own as well as free templates that you can download… - Conditional Formatting - Excel Conditional FormattingCreated: 2009-08-23 @ 10:01:38 EDT Updated: 2009-08-23 @ 10:10:57 EDT
These tutorials cover using conditional formatting in Excel. The tutorials include step by step examples of using conditional formatting in Excel spreadsheets… - Google Spreadsheet Formula - Google Spreadsheet Formula TutorialCreated: 2009-08-19 @ 09:13:40 EDT
This tutorial covers creating and using a simple Google Spreadsheet formula. The tutorial includes a step by step example of creating a Google Spreadsheet formula… - Google Spreadsheet COUNT - Use Google Spreadsheet COUNT FunctionCreated: 2009-08-19 @ 09:06:14 EDT
The COUNT function in a Google Spreadsheet is used to count up the number of cells in a selected range that meet specified criteria. This article contains a step by step example of using the COUNT … - Google Spreadsheet Function - Google Spreadsheet IF FunctionCreated: 2009-08-19 @ 09:04:00 EDT
The IF function in Google Spreadsheet tests to see if a certain condition in a spreadsheet is true or false. This article includes an example to walk you through using Google Spreadsheets' IF funct… - Google Spreadsheet COUNTIF - Use Google Spreadsheet COUNTIF FunctionCreated: 2009-08-19 @ 09:02:45 EDT
The COUNTIF function in a Google Spreadsheet is used to count up the number of cells in a selected range that meet specified criteria. This article includes a step by step example of using the COUN… - End Date in Excel - Calculate End Date in ExcelCreated: 2009-08-19 @ 07:58:36 EDT Updated: 2009-08-19 @ 08:09:44 EDT
The WORKDAY function can be used to calculate the end date of a project for a given number of business days. This article includes an example of using the WORKDAY function to calculate the end date… - Free Time Sheet Template - Free Excel Time Sheet TemplateCreated: 2009-08-14 @ 07:27:32 EDT
This article shows you how to quickly download and use a free employee time sheet template in Excel 2007… - Excel Worksheet - Excel Worksheet HelpCreated: 2009-08-09 @ 08:35:25 EDT
All about worksheets. The articles on this page cover a number of topics related to Excel worksheets - such as worksheet terms, adding and deleting worksheets, how to protect data in a worksheet, a… - Worksheet Tab Color - How to Change Excel Worksheet Tab ColorCreated: 2009-08-09 @ 08:13:26 EDT Updated: 2009-08-09 @ 08:18:14 EDT
This tip covers how to change the worksheet tab color in Excel. This tip includes an example of how to change the worksheet tab color in Excel 2007… - TRUNC Function - Excel 2007 TRUNC FunctionCreated: 2009-08-08 @ 07:22:53 EDT Updated: 2009-08-08 @ 10:29:13 EDT
The Excel TRUNC function does not round numbers. It removes the decimal part of a number to a set number of decimal places. This article includes a step by step example of using the TRUNC function… - Text String - Spreadsheet Terms - Text String DefinitionCreated: 2009-08-04 @ 10:18:47 EDT Updated: 2009-08-04 @ 10:27:38 EDT
Definition of the term text string as used in spreadsheets such as Excel and Google Spreadsheets… - Subtract Dates in Excel - Subtracting Dates in ExcelCreated: 2009-08-01 @ 08:22:08 EDT
There are a number of functions in Excel that can be used to subtract dates. They can be used to subtract days, months, or years. The following articles include examples of subtracting two dates in… - Calculate Days Between Dates - Calculate the Number of Days Between …Created: 2009-07-29 @ 11:24:09 EDT Updated: 2009-07-29 @ 11:31:34 EDT
The DATEDIF function, can be used to calculate the number of days between dates. This article includes a step by step example of using the DATEDIF function in Excel to calculate the number of days … - Subtract Dates Excel - Use the DAY Function to Subtract Dates in Exc…Created: 2009-07-28 @ 11:23:53 EDT Updated: 2009-07-28 @ 11:33:19 EDT
The DAY function can be used to subtract dates in Excel. Find the number of days between two dates. This article includes an example of using the DAY function to subtract two dates in Excel… - Subtract Dates Excel - Use the MONTH Function to Subtract Dates in E…Created: 2009-07-28 @ 09:57:18 EDT Updated: 2009-07-28 @ 11:29:44 EDT
The MONTH function can be used to subtract dates in Excel. Find the number of months between two dates. This article includes an example of using the MONTH function to subtract two dates in Excel… - Subtract Dates Excel - Use the YEAR Function to Subtract Dates in Ex…Created: 2009-07-28 @ 09:29:44 EDT Updated: 2009-07-28 @ 11:31:45 EDT
The YEAR function can be used to subtract dates in Excel. Find the number of years between two dates. This article includes an example of using the YEAR function to subtract two dates in Excel… - Day Born - On What Day Was I Born?Created: 2009-07-27 @ 13:56:02 EDT Updated: 2009-07-27 @ 14:04:30 EDT
Every wonder "On what day was I born? Use Excel to find what day of the week you were born on. … - Data Entry Form - Excel Data Entry FormCreated: 2009-07-25 @ 08:53:06 EDT Updated: 2009-07-25 @ 09:59:32 EDT
This article covers how to use a data entry form to add data to a database in Excel 2003. A step by step example of how to create and use a data entry form is included in the article… - Print Gridlines - Print Gridlines in ExcelCreated: 2009-07-14 @ 09:20:07 EDT Updated: 2009-07-14 @ 09:30:03 EDT
This article shows you how to print gridlines and headings in Excel 2007. A step by step example is included showing you how to print gridlines and headings in Excel… - Rolling Dice - Create Rolling Dice in ExcelUpdated: 2009-11-20 @ 13:34:08 EST
This Tutorial shows you how to create a pair of rolling dice in Excel. The tutorial makes use of the IF, AND, OR, and RANDBETWEEN functions to simulate the rolling of a pair of dice. … - Spreadsheets - How to Use Spreadsheet Software…Updated: 2009-10-30 @ 12:39:40 EDT
How to Use Spreadsheet Software is a series of step by step tutorials and articles designed with the absolute beginner in mind. These tutorials will show you how to use Excel and other spreadsheet … - Add and Delete Columns and Rows in Excel - Add Columns and Rows - De…Updated: 2009-10-30 @ 10:51:47 EDT
This series of articles cover the basics of how to add and delete columns and rows in Excel worksheets. It is often necessary to alter the layout of a worksheet due to the addtion or removal of dat… - Excel Add Columns - Add Columns to Excel Worksheets - Add ColumnsUpdated: 2009-10-30 @ 10:50:32 EDT
This article shows you how, with a click of the mouse, you can easily add columns to Excel worksheets… - Excel Hide Columns - Hide Columns in ExcelUpdated: 2009-10-30 @ 10:50:05 EDT
This article shows you how, with a click of the mouse, you can easily hide columns in Excel spreadsheets… - Format Excel 2007 Borders - Excel 2007 FormattingUpdated: 2009-10-30 @ 10:40:48 EDT
This article shows you how to add and format borders to a spreadsheet. Both the preset and draw borders options are covered. A step by step example of formatting borders is included… - Must Reads: Essential Articles and Resources about SpreadsheetsUpdated: 2009-10-19 @ 11:12:01 EDT
- Excel Average - Excel Average Function - Using the Excel Average Fun…Updated: 2009-10-03 @ 08:06:39 EDT
Excel's AVERAGE function is one of the Statistical Functions that are included with the program. The AVERAGE function can be used to find the average value, or arithmetic Mean, of values in a sele… - Advanced Excel - Advanced Excel TutorialsUpdated: 2009-09-29 @ 10:04:26 EDT
Advanced Excel tutorials, such as working with macros, lookup functions, database tutorials, and pivot tables, can be found here. These tutorials include videos, tips, step by step tutorials, and g… - Excel Cell Reference - Spreadsheet Terms - Excel Cell Reference Defi…Updated: 2009-09-28 @ 19:07:41 EDT
Definition of the term cell reference as used in spreadsheets such as Excel… - Cell References - Using Cell References in Excel Formulas - Cell Ref…Updated: 2009-09-28 @ 18:56:21 EDT
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… - AutoFormat - Excel AutoFormatUpdated: 2009-09-06 @ 12:22:04 EDT
The Excel Autoformat option gives you 17 AutoFormat styles to use to give your spreadsheets a professional look that makes them easy to read. … - Excel Toolbar - Show an Excel Toolbar - Find an Excel ToolbarUpdated: 2009-09-06 @ 11:28:27 EDT
This quick tip shows you how to find and show a toolbar that isn't visible in Excel. Good for finding a toolbar in Excel 97 to Excel 2003… - Parts of the Excel 2007 Screen - Parts of the Microsoft Excel 2007 S…Updated: 2009-09-06 @ 10:57:26 EDT
This labeled picture shows the main parts of the Micorosft Excel 2007 screen. Components include the Office button, ribbons, active cell, name box, column letter, row number, formula bar and sheet … - Excel Stock Market Chart - Excel 2007 Stock Market Chart TutorialUpdated: 2009-09-05 @ 19:28:02 EDT
This tutorial covers creating a Hi-Lo-Close stock market chart in Microsoft Excel 2007. The tutorial includes a step by step example of creating a Hi-Lo-Close stock market chart in the latest vers… - Formulas and Functions - Excel Formulas and FunctionsUpdated: 2009-09-05 @ 09:45:17 EDT
This series of tips, tutorials, and articles covers how to create and use formulas and functions in Excel and other common spreadsheet programs… - Excel MIN Function - Excel MIN Function TutorialUpdated: 2009-09-05 @ 09:01:58 EDT
The MIN function is used to find the smallest or minimum value in a given list of numbers. This article includes an example to walk you through using the MIN function in Excel… - Excel MAX Function - Excel MAX Function TutorialUpdated: 2009-09-05 @ 08:55:10 EDT
The MAX function, is used to find the largest or maximum number in a given list of values. This article includes an example to walk you through using the MAX function… - HLOOKUP Function - Excel 2007 HLOOKUP FunctionUpdated: 2009-09-05 @ 08:24:44 EDT
Excel's HLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This article walks you through using the HLOOKUP function in Excel 20… - VLOOKUP Function - Excel 2007 VLOOKUP FunctionUpdated: 2009-09-05 @ 08:23:01 EDT
Excel's VLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This article walks you through using the VLOOKUP function in Excel… - Excel Column Width - Change Column Width in Excel - Column Width Cha…Updated: 2009-09-04 @ 09:48:11 EDT
There are a number of ways to change column widths in Excel spreadsheets. This step by step tutorial shows you three ways to change column widths in Excel. … - Date Functions Excel - TODAY Function - NOW FunctionUpdated: 2009-09-04 @ 07:54:20 EDT
There are a number of date functions available in Excel 2003. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. Thi… - Excel 2007 Header - Custom Excel Header - Excel Custom HeaderUpdated: 2009-09-02 @ 08:18:48 EDT
In Excel 2007, a header can be used to add descriptive information to every page in the spreadsheet. A custom header can be used to include such things as company information, a spreadsheet title,… - What is Microsoft Excel - What is Excel - What is Microsoft Excel S…Updated: 2009-09-02 @ 08:02:55 EDT
What is Microsoft Excel? It is an electronic spreadsheet program that people use for storing, organizing and manipulating data. The types of data that Excel can use includes numbers, text and formu… - Count Days in Excel - Count Days between Two Dates in ExcelUpdated: 2009-09-02 @ 07:45:22 EDT
The NETWORKDAYS function can be used to count the number of working days between two dates. This article includes an example of using the NETWORKDAYS function to count days in Excel 2007… - Bar Graph - Create a Bar Graph - Example Bar GraphUpdated: 2009-09-01 @ 10:27:00 EDT
This tutorial covers creating a bar graph in Microsoft Excel. This tutorial covers all the steps necessary for creating a bar graph using the Chart Wizard. The tutorial begins by discussing the b… - Excel Formulas - How to Use Excel Formulas - Excel FormulasUpdated: 2009-08-29 @ 19:15:02 EDT
This series of Excel tutorials and articles will teach you the basics of using formulas to perform basic calculations in Excel spreadsheets. … - Excel Graphs - Uses for Excel Graphs - Excel Graph TypesUpdated: 2009-08-29 @ 00:25:41 EDT
This article covers the main types of Excel graphs and their uses. The graphs covered include the bar graph, line graph, scatter plot graph, and the pie chart… - Excel Sort - Sort Data in ExcelUpdated: 2009-08-26 @ 12:20:32 EDT
Using Excel 2007's sort feature. Step by step example of sorting data in Excel 2007… - Flow Chart Template - Free Flow Chart Template - Excel Free Flow Ch…Updated: 2009-08-25 @ 08:05:59 EDT
Among the flow chart templates offered for free by Microsoft is one for creating simple flow charts in Excel. This flow chart template works in all versions from Excel 97 on. A flow chart is a grap… - Conditional Formatting Date - Excel 2007 Conditional Formatting a Da…Updated: 2009-08-23 @ 09:56:41 EDT
This article shows you how apply conditional formatting to a date in Excel 2007. The article includes an example of using conditional formatting for a date in Excel 2007… - Conditional Formatting - Excel Conditional FormattingUpdated: 2009-08-23 @ 09:41:50 EDT
This article shows you how apply conditional formatting to cells in Excel. The article includes an example of using conditional formatting in Excel … - Conditonal Formatting Excel - Find Duplicate Data with Conditional F…Updated: 2009-08-22 @ 09:02:04 EDT
This article shows you how find duplicate data - formulas, numbers, dates, data records - in Excel 2007 using conditional formatting. The article includes an example of using conditional formatting… - Excel HLOOKUP - Using Excel HLOOKUP - HLOOKUP in ExcelUpdated: 2009-08-22 @ 07:31:02 EDT
Excel’s HLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This article covers how to create a HLOOKUP function in Excel, i… - Excel VLOOKUP - Using Excel VLOOKUPUpdated: 2009-08-22 @ 07:27:58 EDT
Excel’s VLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This article covers how to create a VLOOKUP function in Excel, i… - Excel 2003 List - How to Create a Data List in Excel 2003Updated: 2009-08-22 @ 06:57:16 EDT
This tutorial shows you how to create a data list in Excel 2003. The step by step tutorial covers using Excel's data tools to create, filter and sort a list… - Excel Sort - Sort Data in Excel 2003Updated: 2009-08-19 @ 13:10:44 EDT
Using Excel 2003's sort feature. Step by step example of sorting data in Excel 2003… - Sharing Google Spreadsheet - How to Share Google SpreadsheetUpdated: 2009-08-19 @ 08:46:09 EDT
One of the key features of a Google Spreadsheet is that people can collaborate and share information over the Internet. This article covers the steps necessary to share a Google Spreadsheet… - DATE Function - Excel 2007 DATE FunctionUpdated: 2009-08-18 @ 10:14:24 EDT
The DATE function, one of Excel's date and time functions, can be used to add a date to a spreadsheet. This article includes an example of using the DATE function… - Date Function - NOW Function - Excel 2007 NOW FunctionUpdated: 2009-08-18 @ 10:11:01 EDT
The NOW function, one of Excel's date and time functions, is used to add the current time and date to a spreadsheet… - Excel 2007 Template - Microsoft Excel 2007 Template - Microsoft Offi…Updated: 2009-08-14 @ 07:28:41 EDT
This tip shows you how to quickly create a template in Microsoft Office Excel 2007…