Spreadsheets: Most Popular Articles

Excel Formulas
This tutorial will work for versions of Excel from Excel 97 to Excel 2007. Spreadsheet formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. This tutorial walks you through creating formulas in Excel.

How to Use Excel
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 removing columns and rows, how to create charts with the Excel Chart Wizard, and how to use Excel's format options including autoformat.

Data Entry in Excel
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.

IF Functions
IF functions are one of the most versatile functions available in the Excel. This series of articles and tutorials will teach you the basics of using IF functions to perform calculations in Excel spreadsheets.

Flowchart Template
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 graphical representation of a process. This article walks through how to download and use the flowchart template from Microsoft.

Excel IF Functions
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 Macro
This tutorial covers how to create simple macros in Excel using the macro recorder. This tutorial does not cover creating macros using VBA.

Excel IF Function
The Excel IF function is one of the most useful functions available. The IF function allows for decision making in a spreadsheet. Specific criteria are setup that result in one of two actions occurring, depending on whether or not the criteria are met.

Excel Chart Tutorial
This Excel Chart Tutorial covers creating charts in Microsoft Excel. This tutorial covers all the steps necessary for creating a chart using the Chart Wizard. The tutorial begins by discussing the best practices for entering the chart data and then walks you through each of the four screens of the Chart Wizard.

Excel Database
This tutorial shows you how to create an Excel database. An Excel database can be used to keep track of valuable information such as phone numbers, DVD collections, or a contact list of your organization's members. Excel has built in database tools that make it easy to sort and filter a database file to find the information you want.

Formulas - Functions
This series of Excel Tutorials will teach you the basics of using formulas and functions to perform basic calculations in Excel spreadsheets.

Excel VLOOKUP
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, including an example.

Divide Excel
How to divide in Excel is a quick tip that shows you how easy it is to carry out division operations in Excel.

Parts of the Excel Screen
This labeled picture shows the main parts of the Microsoft Excel spreadsheet work area. Components include the active cell, name box, column letter, row number, formula bar and sheet tabs.

Basic Excel 2007 Formula
An Excel 2007 formula is one of the most useful features of the program. Excel 2007 formulas can be as basic as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Excel 2007 does all the calculations for you.

Free Excel Formatting Tutorial
This tutorial on how to format Excel spreadsheets covers using a variety of formatting options including number, text, and worksheet formatting. This is the first part of a step by step tutorial, using these types of formatting effectively to enhance your spreadsheets.

Formula
Spreadsheet Terms covers basic terminology used in spreadsheets such as Excel. Definition of a spreadsheet formula.

Subtract Excel
How to subtract in Excel is a quick tip that shows you how easy it is to subtract numbers in Excel.

Excel Formatting
Excel Formatting is a way to make your spreadsheets easier to read and understand the important data. This series of Excel articles and tutorials, takes you through the process of formatting your Excel spreadsheets.

Add Excel
How to add in Excel is a quick tip that shows you how easy it is to add numbers in Excel.

Nested IF
The IF function is one of Excel’s most useful functions. What it does is test to see whether a certain condition is true or false. If the condition is true, the function will do one thing, if the condition is false, the function will do something else. To increase the flexibility of the function, one IF function can be "nested" inside another. This article covers nesting one IF function inside another.

Excel Math
These articles on Excel Math cover how to carry out basic math operations Microsoft Excel. If you want to know how to add, subtract, multiply, or divide numbers in Excel, these tutorials will show you how.

Excel 2007 Drop Down List
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This article shows you how to create a drop down list in Excel 2007.

Cell Reference
Definition of the term cell reference as used in spreadsheets such as Excel.

Spreadsheet
Spreadsheet definition. This glossary item defines electronic spreadsheets such as Excel, Google Spreadsheets, and OpenOffice Calc.

Excel Functions
This series of tutorials and articles will teach you the basics of using Excel functions to perform a variety of tasks in Excel spreadsheets.

Excel 2007 Line Graph
This tutorial covers creating a line graph in Microsoft Excel 2007. The tutorial includes a step by step example of creating a line graph in the latest version of Excel.

IF Function Calculations
The IF function is one of Excel’s most useful functions. What it does is test to see whether a certain condition is true or false. If the condition is true, the function will do one thing, if the condition is false, the function will do something else. One option for using the IF function is to have it carry out different calculations, depending on whether the tested condition is true or false. This article covers using the IF function to perform calculations on spreadsheet data.

Excel SUM
The Excel SUM function is probably the most often used function in Excel spreadsheets. A short cut to using the SUM function is the Auto SUM button. This step by step tutorial walks through how to use Excel's SUM function and the Auto SUM feature to perform spreadsheet calculations.

Timeline Template
Among the templates offered for free by Microsoft is one for creating a timeline in Excel. This template works in all versions from Excel 97 on. This article walks through how to download and use the timeline template in Excel.

Excel Formula FAQ
Excel formulas are one of the most useful features available in a spreadsheet. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating an Excel formula, the program does all the calculations for you.

Show Formulas
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.

Date Function Excel
There are a number of date functions available in Excel. 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. This article covers the most common date functions used in Excel.

IF Function Entering Text
The IF function is one of Excel’s most useful functions. What it does is test to see whether a certain condition is true or false. If the condition is true, the function will do one thing, if the condition is false, the function will do something else. One option for using the IF function is to have it enter different words into a cell, depending on whether the tested condition is true or false. This article covers using the IF function to entering text into a spreadsheet.

Excel 2003 OR Function
The OR function is one of Excel’s “Logical Functions”. Like most logical functions, the OR function only returns a true or false result. To determine whether the output will be true or false, the function evaluates at least one expression located in another cell in the spreadsheet.

Excel Header and Footer
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 information as well as the date, time and filename of the spreadsheet.

Spreadsheets Terms: Function
Spreadsheets Terms - Definition of the term Function as used in spreadsheets such as Excel.

Excel Tutorial
Each free Excel tutorial covers either an introductory or intermediate level topic in Microsoft Excel 2003 or 2007. Each tutorial will give you a good understanding of how to use Excel and what you can accomplish with the program.

Excel 2007 Column Chart
This tutorial covers creating a column chart in Microsoft Excel 2007. This tutorial includes a step by step example of creating a column chart in the latest version of Excel.

Excel 2007 SUMIF
The SUMIF function, one of Excel's MATH functions, is used to sum up the number of cells in a selected range that meet certain criteria.

Multiply Excel
How to multiply in Excel is a quick tip that shows you how easy it is to multiply numbers in Excel.

Range
Definition of the term range as used in spreadsheets such as Excel.

Excel Tips
This list of Excel tips will give you straightforward answers on how to carry out a variety of tasks in Microsoft Excel. Examples are included to make understanding the steps involved even easier to follow. The list keeps growing so check back often to see what new Excel tips have been added.

Excel 2007 Pie Chart
This free tutorial covers creating a pie chart in Microsoft Excel 2007. The tutorial includes a step by step example of creating a pie chart in the latest version of Excel.

What is Excel
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 formulas. Formulas are used to perform basic mathematical operations, calculating repayment plans for loans or mortgages, and to find the average, maximum, or minimum values in a specified range of data.

Excel 2007 IF Function
The IF function, one of Excel's logical functions, tests to see if a certain condition in a spreadsheet is true or false. This article includes an example to walk you through using Excel 2007's IF function.

Excel 2007 COUNTIF
The COUNTIF function, one of Excel's COUNT functions, is used to count up the number of cells in a selected range that meet certain criteria.

Lists in Excel
This tutorial shows you how to create lists to keep track of valuable information such as phone numbers, DVD collections, or a contact list of your organization's members. Excel's built in tools make it easy to create lists and filter or sort them according to the criteria needed at the time.

IF Function and Blank Cells
The IF function is one of Excel’s most useful functions. What it does is test to see whether a certain condition is true or false. If the condition is true, the function will do one thing, if the condition is false, the function will do something else. One option for using the IF function is to have it leave cells blank, depending on whether the tested condition is true or false. This article covers leaving cells blank when using the IF function.

Spreadsheet Lessons
Spreadsheet 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; how to format your spreadsheet; how to create a chart; and how to print a spreadsheet.

Excel Graph Uses
Scatter Plot graphs are one of the most common types of graph used in Excel. This article covers the uses for Scatter Plot graphs in Excel.

Excel Freeze Panes
Excel's freeze panes feature will keep the headings at the top and down the side of the sheet from disappearing when you scroll awau from the top left corner of the sheet. This tutorial shows you how to "freeze" those sections of the screen containing titles so that they remain visible at all times.

IF Function Enter Data
The IF function is one of Excel’s most useful functions. What it does is test to see whether a certain condition is true or false. If the condition is true, the function will do one thing, if the condition is false, the function will do something else. One option for using the IF function is to have it enter values into target cells, depending on whether the tested condition is true or false. This article covers using the IF function to enter values into a spreadsheet.

Create a Bar Graph
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 best practices for entering the data and then walks you through each of the four screens of the Chart Wizard.

Excel COUNT
Excel's COUNT function is a very useful function. What it does is count up the number of cells containing numbers in a selected range.

Custom Excel Chart
This article covers creating a custom Excel chart. If you have created a chart in Excel, complete with custom formatting, that you would like to use again with other charts save it as a custom chart type.

Data Definition
Spreadsheet Terms covers basic terminology used in spreadsheets such as Excel. Definition of data as it is used in spreadsheets like Excel.

Comparison Operators
The logic test section of an Excel Logic function is always a comparison between two values. This article is a handy list of the different comparison operators that can be used in Excel logic functions.

Cell
Spreadsheet glossary terms. Definition of a "cell".

Excel 2007 RANK Function
The RANK function, one of Excel's statistical functions, ranks the size of a number compared to other numbers in a list. This article includes an example to walk you through using Excel's RANK function.

Formula Bar
The formula bar in Excel is located above the work area of the spreadsheet. The formula bar displays the data or formula stored in the active cell.

Printing in Excel
This tutorial on Excel Printing covers how to Use the print options in Excel to print entire spreadsheets or just selected areas.

Excel HLOOKUP
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, including an example.

Formatting Numbers
Formatting numbers in Excel spreadsheets is used to change the look of the numbers in the cell. The most common formatting options are currency, comma, date, accounting and percent, although there are more options available.

2007 Fill Handle
The fill handle can be used to copy formulas from one cell to other cells in the spreadsheet. This article covers the steps to follow to use the auto fill handle in Excel.

Absolute Cell Reference
Absolute Cell Reference. Spreadsheets Terms - Definition of the term Absolute cell reference as used in spreadsheets such as Excel.

Worksheet
Spreadsheet definition - Worksheet. This glossary entry defines "worksheet" as it pertains to Microsoft Excel

Excel 2007 Template
This tip shows you how to quickly create a template in Microsoft Office Excel 2007.

Excel 2007 SMALL Function
The SMALL function, one of Excel's statistical functions, can be used to find data based on relative size. This article includes an example to walk you through using Excel's SMALL function.

Excel Formula What if Question
"What if" questions involve changing the data used in Excel formulas to give different answers. Asking "What if" questions are very useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.

Row
Rows run horizontally in an Excel worksheet. They are identified by a number in the row header.

Ribbon
Spreadsheet Terms covers basic terminology used in spreadsheets such as Excel 2007. Definition of a ribbon in Excel 2007.

Excel Tips III - Formulas
This list of Excel tips on formulas will give you straightforward answers on how to carry out a variety of tasks related to formulas in Microsoft Excel.

Excel Labels
Using labels in functions and formulas in Excel 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 "January".

CountA
Excel's COUNTA function is a very useful, yet little known function. What it does is count up the number of cells containing data – either numbers or labels in a selected range.

Active Cell
In an Excel worksheet, the active cell is the cell with the black border. Data can only be entered into the active cell.

Add Columns
This article shows you how, with a click of the mouse, you can easily add columns to Excel worksheets.

Syntax
Spreadsheet definition - Syntax. This glossary entry defines "syntax" as it pertains to spreadsheet programs.

Rounding Numbers in Excel
Rounding numbers and rounding decimals is easy to accomplish in Excel. The ROUND function is one of the math functions available in Microsoft Excel 97 to Excel 2007. This article includes an example to walk you through using the ROUND function.

Excel Tips IV - Excel 2007
This list of Excel tips covers a variety of topics in the newest version of Microsoft Excel - Excel 2007.

#REF!
A #REF! error message in Excel refers to an invalid cell reference. Read the article to find the causes and cures for this common problem.

Excel Formatting Tutorial Pt 2
This step by step Excel tutorial takes you through the steps to create formulas.

Excel 2007 AVERAGE IF
The AVERAGE IF function, one of Excel's statistical functions, is used to find the average of values in cells that meet certain criteria.

Cell Address
Spreadsheet definition - Excel Cell Address. This glossary entry defines "Cell Address" as it pertains to spreadsheet programs.

Column
Columns are a fundamental part of any spreadsheet program such as Excel. Columns run vertically in a spreadsheet and help to identify the location of data.

Excel AutoFormat
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 2007 LARGE Function
The LARGE function, one of Excel's statistical functions, can be used to find data based on relative size. This article includes an example to walk you through using Excel's LARGE function.

Excel 2003 AVERAGE
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 selected range of cells.

Unhide Columns
This article shows you how, with a click of the mouse, you can easily unhide columns in Excel spreadsheets.

Open Office Calc Formula Tutor
Like other spreadsheets, Open Office Calc allows you to create formulas to perform calculations. Open Office Calc formulas can be as basic as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Open Office Calc does all the calculations for you.

Excel Sum Function
The Excel SUM function is probably the most often used function in Excel spreadsheets. The AutoSUM button on the Standard toolbar makes it easy to quickly sum columns or rows of adjacent data without actually typing in the cell references.

Chart
Charts are what we call graphs in math class. They are visual representations of worksheet data. In spreadsheet programs such as Lotus 1-2-3 and Quattro Pro they are called graphs. Only in Microsoft Excel are they called charts.

Add, Delete Columns and Rows
This article shows you how, with a click of the mouse, you can easily add or delete rows and columns in Excel.

Add - Delete Columns and Rows
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 data.

Relative Cell Reference
Relative Cell Reference. Spreadsheets Terms - Definition of the term relative cell reference as used in spreadsheets such as Excel.

Excel 2007 COUNT
Excel 2007's COUNT function allows you to count up the number of cells containing numbers in a selected range.

Microsoft Works Task Launcher
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.

Excel 2007 Formatting Tutorial
This tutorial include adding a date Function and a range name to Excel 2007 spreadsheets.

Remove Duplicate Data in Excel
This article shows you how to quickly search for and remove duplicate data in Excel 2007 databases and lists

Chart Wizard
The Chart Wizard in Excel spreadsheets, is composed of a series of dialog boxes that give you all the available options for creating a chart quickly.

Column Header
Spreadsheet Terms covers basic terminology used in spreadsheets such as Excel. Definition of a Column Header.

Excel 2007 CONCATENATE
The CONCATENATE function, one of Excel's text functions, is used to join two or more words or text strings together. This article includes an example to walk you through using Excel's CONCATENATE function.

Excel 2007 PMT
The PMT function, one of Excel's Financial functions, can be used to calculate loan repayments or the future value of an investment. This article covers using the PMT function in Excel 2007 to determine loan payments.

Argument
Spreadsheet definition - Argument. This glossary entry defines "argument" as it pertains to spreadsheet programs.

Excel Conditional Formatting
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).

Create a Pictograph
A pictograph uses pictures or symbols to represent different amounts of data in a chart or graph. Often each symbol in the pictograph represents a set amount of data.

Excel 2003 AND Function
The AND function is one of Excel’s “Logical Functions”. Like most logical functions, the AND function only returns a true or false result. To determine whether the output will be true or false, the function evaluates at least one expression located in another cell in the spreadsheet.

Convert Works to Excel
This tip shows you how to easily convert your Microsoft Works spreadsheets to Excel.

Excel Auto Fill Handle
The Auto Fill Handle is a very handy feature in Excel. It allows you to quickly add commonly used data. You can customize the lists of data that can be added. This article will show you how.

Excel 2007 TODAY
The TODAY function, one of Excel's date functions, is used to add the current date to a spreadsheet.

Workbook
Spreadsheet definition - Workbook. This glossary entry defines "workbook" as it pertains to Microsoft Excel.

Color Tabs
In Microsoft Excel 2003 it is possible to color code the tabs of individual worksheets. Color coding the tabs of worksheets that contain related data often makes it easier to find specific information in large spreadsheet files.

Excel Chart Wizard
The Excel Chart Wizard makes the process of creating charts or graphs in Excel a very simple procedure. There are four steps to the Chart Wizard. These steps contain a number of options that allow you to pick a chart type, choose your data, and add titles and formatting to produce a finished chart.

Graph
Graphs are visual representations of worksheet data. Graphs in a spreadsheet program such as Lotus 1-2-3 and Quattro Pro are similar to what we call graphs in math class. In Microsoft Excel they are called charts.

Excel 2007 DATE
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.

AutoSum
The Excel AutoSUM is a shortcut to using the SUM function. By using the icon on the standard toolbar, you can quickly enter the SUM function into your spreadsheet.

Bar Graph Formatting
This article covers a number of formatting options for bar graphs in Excel.

Excel 2007 Merge and Center
The Merge and Center formatting feature in Excel 2007 is a handy option to quickly format titles and headings in Excel 2007 Spreadsheets. This tip will show you how to do it.

Microsoft Works Spreadsheets
How to Use Microsoft Works Spreadsheets is a series of articles and tutorials for the absolute beginner. Learn about the parts of the Microsoft Works Spreadsheets screen, how to enter data, how to use formulas and functions, adding and removing columns and rows, how to create charts, and how to use the program's format options.

Drag Select
Drag select is a term used to describe the method of selecting a range of cells by dragging the mouse over a block of cells, or range, in the spreadsheet.

Excel 2007 MID Function
The MID function, one of Excel's text functions, is used to remove unwanted characters from both the left and right sides of a data entry. This article includes an example to walk you through using Excel's MID function.

Delete Rows
This article shows you how, with a click of the mouse, you can easily delete rows from Excel worksheets.

Name Box Definition
The Name Box displays the cell reference of the active cell. It will also show the name assigned to a cell or range of cells.

Unhide Rows
This article shows you how, with a click of the mouse, you can easily unhide rows in Excel spreadsheets.

Label
A label is one of three data types in Excel and other spreadsheet programs. Labels are used for titles, headings, names, and for identifying columns of data.

Excel 2007 TRANSPOSE
The TRANSPOSE function, one of Excel's Lookup & Reference functions, is used to transfer data located in a row into a column or data located in a column into a row.

Excel 2007 Custom Header
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, or spreadsheet author.

Change Column Widths
There are a number of ways to change column widths in Excel spreadsheets. This step by step tutorial shows you three ways of accomplishing the task in Excel.

Hide-Unhide Columns and Rows
This series of articles cover how to hide and unhide columns and rows in Excel worksheets.

Mathematical Operator
A Mathematical Operator is a symbol that represents an arithmetic operation in an Excel spreadsheet formula. The four common mathematical operators are: addition ( + ), division ( / ), subtraction ( - ), and multiplication ( * ).

Hide Rows
This article shows you how, with a click of the mouse, you can easily hide rows in Excel spreadsheets.

Excel 2007 Options Button
Since there is no longer a tool's menu, or even a tool's tab on the Ribbon, you have to look elsewhere for the Excel Options feature in Excel 2007.

Excel 2003 PRODUCT Function
In Excel, the PRODUCT function can be used for multiplying numbers or a range of values together. A function is just a built-in formulas. Functions have been added to simplify performing specific mathematical operations in the spreadsheet.

NETWORKDAYS Function
The NETWORKDAYS function can be used to find the number of working days for a project. This article includes an example of using the NETWORKDAYS function in Excel 2007.

Excel 2007 LEFT Function
The LEFT function, one of Excel's text functions, is used to remove unwanted characters from the right side of a data entry. This article includes an example to walk you through using Excel's LEFT function.

Excel Named Range
This quick tip shows you how to create a named range in Excel. A named range can be used to identify the cells used in charts, functions and formulas. Using named ranges is often easier to use than trying to identify the cell references needed for a formula.

Excel 2007 NOW
The NOW function, one of Excel's date and time functions, is used to add the current time and date to a spreadsheet.

Fill Handle
The fill handle is a small black dot or square in the bottom right corner of the active cell. The fill handle has a number of uses including copying a cell’s contents to adjacent cells or to create a series.

Excel MAX Function
The MAX function, one of Excel’s statistical functions, is used to find the largest value in a given list of arguments. This article includes an example to walk you through using the MAX function.

Excel 2007 ROUND
The ROUND function, one of Excel's math functions, is used to reduce a number to a specific number of decimal places.

Format Painter
Excel's format painter allows you to quickly copy formatting from one cell or group of cells to another part of the spreadsheet. It is very useful when extending a spreadsheet to accommodate new data and you need to format the new cells to match the original data area.

Excel 2007
This series of tutorials and articles on Microsoft Office Excel 2007 covers using many basic features of the program.

#####
A ##### error message in Excel can be caused by several factors. This article discusses the causes and cures for this common error in Excel.

Chart Wizard Tutorial Data
Excel spreadsheet chart tutorial. Excel tutorial on using the Chart Wizard. Data for a step by step example using the Chart Wizard.

Excel 2007 PMT_FV
Future value of investments is one use for the Excel PMT function. This article includes an example of using the PMT function in Excel 2007 to determine future value.

Excel 2007 Auto Fill Handle
The Auto Fill handle is a very handy feature in Excel. It allows you to quickly add commonly used data or copy existing data to other cells. You can customize the lists of data that can be added. This article will show you how.

#DIV/0! - Divide by Zero Error
#DIV/0! - Divide by 0 errors indicate an error in a formula. This article discusses the causes and cures for this common problem.

Excel 2007 SUM Function
The Excel SUM function is used to quickly add up the values in a range of cells. This article shows you how to use this function.

Value
One of three data types in Excel. Values contain numbers and can be used in calculations.

MS Works Spreadsheets Formulas
Formulas in a MS Works Spreadsheets are one of the most useful features of the program. Once you learn the basic steps of creating a formula, MS Works does all the calculations for you.