How to print gridlines and headings in Excel. A step by step example is included showing you how to print gridlines and headings in Excel.

Spreadsheet Definitions and Terms - Letters U, V and W

These are just the briefest of definitions and terms for Excel and other spreadsheets starting with U, V and W. For more detailed descriptions see the individual page for each term.

Worksheets and Workbooks in Excel

Definitions and specifications for the terms

How to Multiply in Google Spreadsheets

How to multiply in Google Spreadsheets shows you how easy multiply numbers can be. The tutorial includes a step by step example of how to multiply two numbers in Google Spreadsheets.

How to Add in Excel

Step by step instructions on how to add two or more numbers in Excel using a simple formula. Also covered - use a formula to create Fibonacci series.

Data for Excel Pivot Table Tutorial

This document contains pivot table data for the Excel pivot table tutorial. The pivot table data is to be copied and pasted into the tutorial worksheet.

Excel EOMONTH Function: Add/Subtract Months to Dates

Use Excel's EOMONTH function to add or subtract months to dates in order to calculate future or back dates of investments or projects.

Copy Formatting Between Cells with Format Painter

Quickly copy formatting options from one cell to another with Excel's and Google Sheets format painter. Step by step instructions are included.

Excel MIN Function Shortcut: Find the Smallest Values

Find the smallest number, the fastest time, the shortest distance, the earliest date, and other minimum values with Excel's MIN function.

Excel MAX Function Shortcut: Find the Largest Values

Find the biggest number, the latest date, the longest time, the largest amount of money, and other maximum values with Excel's MAX function.

Using Point and Click to Build Formulas in Excel

Using point and click with the mouse or arrow keys to add cell references to formulas in spreadsheet programs such as Excel and Google Spreadsheets.

Tips and Tutorials to Get More From Excel

Spreadsheets can not only gather all your data, they can help you understand it, enable forecasting, and help you see data in a new way.

Shade Alternate Rows with Excel Conditional Formatting

Use Excel's conditional formatting options to dynamically shade alternate rows or columns of data in a worksheet. A step by step example is included.

Microsoft Excel - Quick Tips and Tricks

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 Database, Tables, Records and Fields

Definition and uses of the database terms: table, records, fields, and field names in Excel. Includes a list of Excel's data tools and functions.

Carry out Multiple Calculations with Excel Array Formulas

Array formulas perform multiple calculations on on one or more cells of data. This tutorial list includes step by step examples of how to use a variety of array formulas in Excel.

Column and Row Headings - Excel and Google Spreadsheets Glossary

Definition of the terms column and row headings or headers as they are used in Excel and Google Spreadsheets.

Circular References in Excel Formulas

Circular reference in Excel Formulas - what they are, why they occur, and what to do about them.

Excel Formulas - Defined and Described

Definition and uses of the term formula as they pertain to spreadsheet programs such as Excel and Google Spreadsheets. Examples included.

Changing the Order of Operations in Excel Formulas

Excel's order of operations covers how Excel evaluates formulas containing more than one mathematical operator.

Order of Operations - Changing the Order of Operations in Excel Formulas

The order of operations followed by Excel when multiple operators are used in a formula. Step by step examples of how to change the order are included

Excel 2003 Function Tutorials

This page contains step by step tutorials, tips and shortcuts on how to use the common and less common functions available in Excel 2003.

Change Spreadsheet Column Widths Using the Mouse

How to change column widths and row heights in Excel and Google Spreadsheets using the mouse or menu options. Step by step are included.

Change Column Widths and Row Heights Using Ribbon Options in Excel

Use options found on the ribbon menu in Excel to change the width of one or more columns or the heights of rows. Step by step examples are included.

Range Definition and Use in Excel Worksheets

Definition and uses of the term

Adding Data Records with the Excel Data Entry Form

This tutorial covers how to use a data entry form to add data to a database in Excel. A step by step example of how to create and use a data entry form is included in the tutorial.

Excel Data Entry Form Tutorial

This tutorial covers how to use a data entry form to add data to a database in Excel. A step by step example of how to create and use a data entry form is included in the tutorial.

Adding the Data Entry Form Button to the Quick Access Toolbar

This step in the tutorial covers how to add the data entry form icon to the Quick Access Toolbar in Excel.

Excel Data Entry Form - Adding the Database Field Names

This tutorial covers how to use a data entry form to add data to a database in Excel. A step by step example of how to create and use a data entry form is included in the tutorial.

Excel Data Entry Form Tutorial

This tutorial covers how to use a data entry form to add data to a database in Excel. A step by step example of how to create and use a data entry form is included in the tutorial.

Excel Data Entry Form Tutorial

This tutorial 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 tutorial.

Excel Data Entry Form Tutorial

This tutorial covers how to use a data entry form to add data to a database in Excel. A step by step example of how to create and use a data entry form is included in the tutorial.

Excel Data Entry Form Tutorial

This tutorial covers how to use a data entry form to add data to a database in Excel. A step by step example of how to create and use a data entry form is included in the tutorial.

Excel: Searching for Records Using Multiple Field Names

How to use the Criteria button in Microsoft Excel to search for records using more than one field name. Page 9 of the Excel Data Entry Form Tutorial.

Excel Spreadsheets Glossary of Terms - Label Definition

Definition of the term

Three Ways to Change Worksheet Tab Colors in Excel

Change the tab color of one or more worksheets in Excel using keyboard keys, context menu, or ribbon options. Step by step instructions included.

Google Spreadsheets Tutorial - SUM Function

Use Google Sheets SUM function to quickly sum up columns or rows of numbers. A step by step example is included.

Remove Non-Printable ASCII Characters From Imported Data

Use Excel's CLEAN function to remove non-printable ASCII and Unicode characters - including #127 - from good data. Step by step instructions included.

Text Functions - Excel's Text Functions

Excel's Text Functions help you manage the text data in your spreadsheets.

Remove Extra Spaces in Excel

This tutorial contains a step by step example of how to remove extra spaces from between words in Excel using the TRIM function and paste values.

Find the Third Smallest or Sixth Largest Number in Excel

Find the nth largest or smallest values in a list of numbers with Excel's LARGE and SMALL functions. Step by step examples are included.

Active Sheet Definition and Use in Excel

Definition and use of the term active sheet as it pertains to Excel and Google Spreadsheets.

Excel Active Cell - Definition and Use

Definition and use of the term

Excel Charts and Graphs - Definition and Use

Definition and uses of charts or graphs as they are pertain to spreadsheet programs such as Excel and Google Spreadsheets

Sizing Handle Definition and Use in Excel

Definition of the term

Excel's Red and Green Triangle Indicators

Explanation and use Excel's red and green

Excel SUM - INDIRECT Dynamic Range Formula

Excel's INDIRECT function makes it easy to create a dynamic range of cell references in formulas without having to edit the formula itself. This tutorial combines INDIRECT with the SUM function to create an easy way to change the range of data added up by the formula. A step by step example is included.

VLOOKUP Dialog Box

This step in the left Lookup formula tutorial covers completing the VLOOKUP dialog box.

Find Data in Columns or Rows with Excel's LOOKUP Function

The Vector form of Excel's LOOKUP function can be used to find a single value from a one-row or one-column range of data. A step by step example of using the vector form of the LOOKUP function is included with this tutorial.

Find Information in Data Tables with Excel's LOOKUP Function

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 is included.

Excel SUM - INDIRECT Dynamic Range Formula

Excel's INDIRECT function makes it easy to create a dynamic range of cell references in formulas without having to edit the formula itself. This tutorial combines INDIRECT with the SUM function to create an easy way to change the range of data added up by the formula. A step by step example is included.

Excel Left Lookup Formula Using VLOOKUP

This tutorial combines Excel's VLOOKUP and CHOOSE functions to create a

How the CHOOSE Function Works

This step in the tutorial covers testing the left lookup formula as well as including detailed information on the role of the CHOOSE function in the left lookup formula.

Excel SUMIF: Sum Values that Meet Specified Criteria

The SUMIF function totals or sums the values in cells - but only if the selected values meet specific criteria that you set. Step by step example included.

Entering the Tutorial Data

This step in the tutorial covers adding data to the worksheet.

Opening the SUMIF Function dialog box

This step in the tutorial covers finding and opening the SUMIF function dialog box.

Entering the SUMIF Function Range Argument

This step in the tutorial covers entering the SUMIF function's range argument.

Entering the SUMIF Function Criteria Argument

This step in the tutorial covers entering the SUMIF function's criteria argument.

Entering the SUMIF Function Sum_range Argument

This step in the tutorial covers entering the SUMIF function's Sum_range argument.

Adding the Search Criteria for the SUMIF Function Tutorial

This step in the tutorial covers adding the search criteria.

Entering the Average_range Argument for the Excel AVERAGEIFS Function

Entering the Average_range argument for the Excel AVERAGEIFS Function step by step tutorial.

Excel Graph Types and Uses

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 Bar Graph Uses

Bar graphs are one of the most common types of graph used in Excel. Bar graphs are known as

Excel Line Graph Uses

Line graphs are one of the most common types of graph used in Excel. This article covers the uses for line graphs in Excel.

Excel Scatter Plot 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 Pie Chart Uses

Pie charts, or circle graphs as they are sometimes known, are used to show percents. This article covers what pie charts are and what they are used for.

Excel Shortcuts: Selecting Rows, Columns, or Worksheets

How to select entire rows, columns, data tables, or worksheets in Excel using shortcut keys or the mouse. Step by step instructions are included.

Using Go To Shortcut Keys to Move Around Excel Worksheets

Use Excel's Go To command with shortcut keys to quickly navigate to different cells in a worksheet. Step by step instructions are included.

Moving Around and Between Worksheets in Excel

How to move around and between worksheets in Excel using keyboard shortcuts keys, the Name Box, and Go To. Step by step instructions are included.

Using the Name Box to Move Around Excel Worksheets

Use the Name Box in Excel to quickly navigate to different cells or areas in a worksheet. Step by step instructions are included.

Select Entire Columns in Excel with Shortcut Keys

Using Shortcut keys or the mouse to select one or more columns in an Excel worksheet. Step by step instructions are included.

Select All Cells in an Excel Worksheet with Shortcut Keys

Select all cells in the current Excel worksheet using shortcut keys or the

Select All Cells in a Table of Data in Excel with Shortcut Keys

Select all cells in a range or table of data in Excel using shortcut keys. Step by step instructions are included.

Select Multiple Worksheets in Excel with Shortcut Keys

How to select multiple worksheets in Excel using a keyboard shortcut or the mouse and keyboard keys. Step by step instructions are included.

The SUMIF Function's Syntax

This step in the tutorial covers the syntax and arguments for the SUMIF function.

Entering the Criteria1 Argument for the Excel AVERAGEIFS Function

Entering the Criteria1 argument for the Excel AVERAGEIFS function step by step tutorial.

Entering the Criteria_range2 Argument for the Excel AVERAGEIFS Function

Entering the Criteria_range2 argument for the Excel AVERAGEIFS function step by step tutorial.

Entering the Criteria2 Argument for the Excel AVERAGEIFS Function

Entering the Criteria2 argument for the Excel AVERAGEIFS function step by step tutorial.

Excel INDIRECT Function Tutorial

Excel's INDIRECT 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 SUM, COUNT, and MATCH. This tutorial includes a step by step example.

Excel SUM - INDIRECT Dynamic Range Formula

Combine Excel's INDIRECT and SUM functions can make it easy to change the range of data added up by the formula. Step by step instructions are included.

Use Excel Shortcut Keys to Save a Worksheet

This Excel shortcut keys tutorial shows you how to quickly save a worksheet using just the keyboard.

Edit Cells with the F2 Function Key in Excel

Quickly edit the contents of a cell using the F2 key in Excel.

Find Specific Data with Excel's ROW Function

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 is included.

Round Numbers Down to the Nearest 5 or 10 in Excel

Use Excel's FLOOR function to round a value downwards to a set number of significant decimal places. A step by step example is included.

Round Numbers Up to the Nearest 5 or 10 in Excel

Use Excel's CEILING function to round a value upwards to a set number of significant decimal places. A step by step example is included.

Use Excel to Find - On What Day Was I Born?

Every wonder

Excel AVERAGEIFS: Find the Average for Specific Criteria

Use Excel's AVERAGEIFS function to find the average for only those values meeting two or more criteria that you set. Step by step example included.

Adding the Search Criteria for the Excel AVERAGEIFS Function

Adding the search criteria for the Excel AVERAGEIFS function step by step tutorial.

Entering the Tutorial Data for the Excel AVERAGEIFS Function Tutorial

Entering the tutorial data for the Excel AVERAGEIFS function step by step tutorial.

Syntax for the Excel AVERAGEIFS Function

This step in the tutorial covers the syntax and augments for the Excel AVERAGEIFS Function.

Opening the AVERAGEIFS Function Dialog Box

Using the AVERAGEIFS function's dialog box to enter the function's arguments.

Entering the Criteria_range1 Argument for the Excel AVERAGEIFS Function

Entering the Criteria_range1 argument for the Excel AVERAGEIFS function step by step tutorial.

Free Microsoft Works Spreadsheets Tutorial - Entering Data in Microsoft Works Spreadsheets

Learn how to enter data into a Microsoft Works spreadsheet. Topics covered include planning the spreadsheet, cells and cell references, data types, widening columns and editing cells.

Microsoft Works Spreadsheets - Microsoft Works Spreadsheets Tutorial - Free Microsoft Works Spreadsheets Tutorial

Microsoft Works Spreadsheets Tutorial. Topics covered include planning the spreadsheet, cells and cell references, data types, widening columns and editing cells.

Microsoft Works Spreadsheets - Microsoft Works Spreadsheets Tutorial - Free Microsoft Works Spreadsheets Tutorial

Microsoft Works Spreadsheets Tutorial. Topics covered include planning the spreadsheet, cells and cell references, data types, widening columns and editing cells.

Microsoft Works Spreadsheets - Microsoft Works Spreadsheets Tutorial - Free Microsoft Works Spreadsheets Tutorial

Microsoft Works Spreadsheets Tutorial. Topics covered include planning the spreadsheet, cells and cell references, data types, widening columns and editing cells.

Microsoft Works Spreadsheets - Microsoft Works Spreadsheets Tutorial - Free Microsoft Works Spreadsheets Tutorial

Microsoft Works Spreadsheets Tutorial. Topics covered include planning the spreadsheet, cells and cell references, data types, widening columns and editing cells.

Microsoft Works Spreadsheets - Microsoft Works Spreadsheets Tutorial - Free Microsoft Works Spreadsheets Tutorial

Microsoft Works Spreadsheets Tutorial. Topics covered include planning the spreadsheet, cells and cell references, data types, widening columns and editing cells.

Using 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.

MS Works Spreadsheets Formulas - Using Ms Works Spreadsheets Formulas - MS Works Tutorial

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

MS Works Spreadsheets Formulas - Using Ms Works Spreadsheets Formulas - MS Works Tutorial

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

MS Works Spreadsheets Formulas - Using Ms Works Spreadsheets Formulas - MS Works Tutorial

Formulas in MS Works Spreadsheet 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.

MS Works Spreadsheets Formulas - Using Ms Works Spreadsheets Formulas - MS Works Tutorial

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

MS Works Spreadsheets Formulas - Using Ms Works Spreadsheets Formulas - MS Works Tutorial

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

MS Works Spreadsheets Formulas - Using Ms Works Spreadsheets Formulas - MS Works Tutorial

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.

MS Works Spreadsheets Formulas - Using Ms Works Spreadsheets Formulas - MS Works Tutorial

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.

Excel TRUNC Function - Remove Decimals Without Rounding

Use the TRUNC function in Excel to shorten numbers by removing all decimal places without rounding what remains. A step by step example is included

OpenOffice Calc Formula - OpenOffice Calc Formula Tutorial

This step by step tutorial covers creating formulas in OpenOffice Calc. This tutorial covers the basics of creating a formula in Openoffice Calc.

OpenOffice Calc Formula - OpenOffice Calc Formula Tutorial

This step by step tutorial covers creating formulas in OpenOffice Calc. This tutorial covers the basics of creating a formula in Openoffice Calc.

OpenOffice Calc Formula - OpenOffice Calc Formula Tutorial

This step by step tutorial covers creating formulas in OpenOffice Calc. This tutorial covers the basics of creating a formula in Openoffice Calc.

OpenOffice Calc Formula - OpenOffice Calc Formula Tutorial

This step by step tutorial covers creating formulas in OpenOffice Calc. This tutorial covers the basics of creating a formula in Openoffice Calc.

Order of Operations - OpenOffice Calc Order of Operations

If more than one operator is used in a formula, there is a specific order that OpenOffice Calc will follow to perform these mathematical operations.

Mathematical Operators - Using Mathematical Operators in OpenOffice Calc Spreadsheets

Creating formulas in OpenOffice Calc is very straight forward. It is just a matter of combining the cell references of your data with the correct mathematical operator. The mathematical operators we use when creating spreadsheet formulas are very similar to the ones we use in math class.

How to Divide in Google Spreadsheets

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 Multiply in Google Spreadsheets

How to multiply in Google Spreadsheets shows you how easy multiply numbers can be. The tutorial includes a step by step example of how to multiply two numbers in Google Spreadsheets.

Google Spreadsheets Division Formula Example

This step by step example shows you how to divide two numbers in Google Spreadsheets using a formula.

Show/Hide Formulas in Excel and Google Spreadsheets

How to show and hide all formulas in Excel and Google Spreadsheets using shortcut keys. Also, hiding formulas in Excel using worksheet protection.

Google Spreadsheets Multiplication Formula Example

This step by step example shows you how to multiply two numbers in Google Spreadsheets using a formula.

Remove Extra Spaces from Data in Google Spreadsheets

Use the TRIM function to remove extra spaces from between words or other text in Google Spreadsheets. A step by step example is included.

Entering the TRIM Function in Google Spreadsheets

Entering the TRIM function and its argument in Google Spreadsheets.

Google Spreadsheets Addition Formula Example

This step by step example shows you how to add two numbers in Google Spreadsheets using a formula.

Count Days Between Two Dates in Google Spreadsheets

The NETWORKDAYS function can be used to count the number of whole working days between two dates. This tutorial includes a step by step example on using the NETWORKDAYS function in Google Spreadsheets.

Find Data in Google Spreadsheets with VLOOKUP

Uses the VLOOKUP function in Google Spreadsheets to find the discount pricing of an item based on the amount purchased. A step by step example is included.

Calculate Days Between Two Dates in Google Spreadsheets

The NETWORKDAYS.INTL function can be used to calculate the number of whole working days between two dates. This tutorial includes a step by step example on using the NETWORKDAYS function in Google Spreadsheets.

Google Spreadsheets NETWORKDAYS Function Example

This step by step example shows how to use the NETWORKDAYS function to cunt the number of days beteen two dates in Google Spreadsheets.

How to Add in Google Spreadsheets

How to add in Google Spreadsheets shows you how easy adding numbers can be. The tutorial includes a step by step example of how to add two numbers in Google Spreadsheets.

Google Spreadsheets COUNTBLANK Function

The COUNTBLANK function is used to count up the number of cells in a selected range that do not contain data. This tutorial contains a step by step example of using the COUNTBLANK function in Google Spreadsheets.

Google Spreadsheets WORKDAY Function

Use Google Spreadsheets WORKDAY function to find the start or end date of a project given a set number of work days. This tutorial includes a step by step example.

Google Spreadsheets COUNTBLANK Function

The COUNTBLANK function is used to count up the number of cells in a selected range that do not contain data. This tutorial contains a step by step example of using the COUNTBLANK function in Google Spreadsheets.

Google Spreadsheets VLOOKUP Function's Syntax and Arguments

As part of this example on using Google Spreadsheets VLOOKUP function, this page contains detailed information on the function's syntax and arguments.

Google Spreadsheets VLOOKUP Error Messages

Explanation of the common error messages that occur while using Google Spreadsheets' VLOOKUP Function.

Extract Text with Google Spreadsheet's LEFT Function

Use Google Spreadsheets' LEFT function to remove unwanted text characters from data. Step by step instructions are included.

Extract Text Characters with Google Spreadsheets' RIGHT Function

Use Google Spreadsheets' RIGHT function to remove unwanted characters from imported data or to truncate existing text. A step by step example is included.

Generate Random Numbers with Excel's RANDBETWEEN Function

Use Excel's RANDBETWEEN function to generate random integers between two numbers that you choose. Use the function in coin toss and dice roller simulators.

Calculate Days Between Two Dates in Google Spreadsheets

The NETWORKDAYS.INTL function can be used to calculate the number of whole working days between two dates. This tutorial includes a step by step example on using the NETWORKDAYS function in Google Spreadsheets.

Google Spreadsheets WORKDAY Function

Use Google Spreadsheets WORKDAY function to find the start or end date of a project given a set number of work days. This tutorial includes a step by step example.

Find the Largest Number with the MAX Function in Google Spreadsheets

The MAX function in Google Spreadsheets can be used to find the largest or maximum number in a given list of values. This tutorial includes a step by step example.

Generate Random Numbers with Google Spreadsheets' RANDBETWEEN Function

Use Google Spreadsheets' RANDBETWEEN function to generate a random integer between two values that you specify - such as one and ten.

Google Sheets RAND Function: Generate Random Numbers

Use Google Spreadsheets' RAND function to generate random numbers between zero and one. Step by step instructions are included.

Adding the Match type and Completing the MATCH Function

Adding the Match_type argument and completing the nested MATCH function as part of the two dimensional lookup formula in Excel.

Round Numbers Up in Google Spreadsheets with the ROUNDUP Function

Use Google Spreadsheets' ROUNDUP function to round a number up a set number of decimal places or digits. A step by step example is included on page 2.

Google Spreadsheets' ROUNDUP Function SxS Example

This page in the ROUNDUP function tutorial contains a step by step example of how to use the function in Google Spreadsheets.

Entering the MAX Function and Arguments in Google Spreadsheets

Step by step instructions for entering the MAX function and its arguments in this Google Spreadsheets tutorial.

Find the Smallest Number with the MIN Function in Google Spreadsheets

The MIN function in Google Spreadsheets can be used to find the smallest or minimum number in a given list of values. A step by step example is included.

Find Data in a List with the INDEX Function

Use Excel's INDEX function to return the name of a specific item of data from a list or array A step by step example is included.

Excel INDEX Function Tutorial

The Excel INDEX function uses row and column numbers from an array to return the name of a specific item of data. This tutorial includes a step by step example.

Starting the Nested MATCH Function

This step in the tutorial covers entering the MATCH function as the column index number argument for the two dimensional VLOOKUP lookup formula in Excel.

Adding the Lookup_array for the MATCH Function

Adding the Lookup_array argument for the MATCH function as part of the two dimensional lookup formula in Excel.

Entering the VLOOKUP Range Lookup Argument

This step in the tutorial covers entering the range lookup argument for the two dimensional VLOOKUP lookup formula in Excel.

Testing the Two Way Lookup Formula

Entering data to test the two way lookup formula in Excel.

Copying the Two Dimensional Lookup Formula with the Fill Handle

The Lookup formula will be copied to a second cell using the Fill Handle in Excel

Entering the MIN Function and Arguments in Google Spreadsheets

Step by step instructions for entering the MIN function and its arguments in this Google Spreadsheets tutorial.

Excel MATCH Function: Finding the Location of Data

Use Excel's MATCH function to find the relative position of specific values in a list or table of data.Step by step example included.

Find the Tangent of an Angle in Google Spreadsheets

Find the tangent of an angle in Google Spreadsheets with the TAN function. A step by step example is included.

Rounding Numbers in Google Spreadsheets with the ROUND Function

Rounding numbers up or down a specific number of decimal places in Google Spreadsheets with the ROUND function. A step by step example is included.

Microsoft Works Spreadsheets Tutorial - Microsoft Works Spreadsheets Step by Step Tutorial

This tutorial covers creating a basic spreadsheet in Microsoft Works. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.

Add Up Columns or Rows of Numbers in Open Office Calc

Use the SUM function add up columns or rows of numbers in Open Office Calc. A step by step example is included on using this free spreadsheet program.

Free Open Office Calc Tutorial - AVERAGE Function

The AVERAGE function provides a quick and easy way to find the average value for a range of numbers in an Open Office Calc spreadsheet. This tutorial includes a step by step example of how to use the AVERAGE function in Open Office Calc.

Calculate Days Between Two Dates in Google Spreadsheets

The NETWORKDAYS.INTL function can be used to calculate the number of whole working days between two dates. This tutorial includes a step by step example on using the NETWORKDAYS function in Google Spreadsheets.

Google Spreadsheets MODE Function

The MODE function in Google Spreadsheets can be used to find the middle or median value in a list of numbers. A step by step example is included in this tutorial.

Free Open Office Calc Tutorial - SUM Function

The SUM function provides a quick and easy way to add up columns or rows of numbers together in an Open Office Calc spreadsheet. This tutorial includes a step by step example of how to use the SUM function in Open Office Calc.

Beginners Guide to Microsoft Works Spreadsheets

Beginners Guide to 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.

Microsoft Works Spreadsheets Tutorial - Microsoft Works Spreadsheets Step by Step Tutorial

This tutorial covers creating a basic spreadsheet in Microsoft Works. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.

Microsoft Works Spreadsheets Tutorial - Microsoft Works Spreadsheets Step by Step Tutorial

This tutorial covers creating a basic spreadsheet in Microsoft Works. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.

Microsoft Works Spreadsheets Tutorial - Microsoft Works Spreadsheets Step by Step Tutorial

This tutorial covers creating a basic spreadsheet in Microsoft Works. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.

Find the Sine of an Angle in Google Spreadsheets

How to find the sine of an angle using the SIN function in Google Spreadsheets. A step by step example is included.

Find the Cosine of an Angle in Google Spreadsheets

Find the cosine of an angle in Google Spreadsheets with the COS function . A step by step example is included.

Starting the Nested IF Function

This step in the tutorial covers opening the IF function dialog box and entering the function's arguments.

Entering the IF Function's Logical_test Argument

This step in the tutorial covers entering the Logical_test argument for the nested IF functions. A step by step example is included.

Entering the IF Function's Value_if_true Argument

This step in the tutorial covers entering the Value_if_true argument for the nested IF functions. A step by step example is included.

Copying the Nested IF functions using the Fill Handle

This step in the tutorial covers copying the nested IF functions using the Fill Handle. A step by step example is included.

Entering the Nested IF Function as the Value_if_false argument

This step in the tutorial covers entering the nested IF Function as the Value_if_true argument. A step by step example is included.

Nesting the AND, OR and IF Functions in Excel

By nesting or combining the OR and/or AND functions with Excel's IF function, the range of conditions tested for in the worksheet can be greatly increased.

Nesting Multiple IF Functions in Excel - Tutorial

Nest multiple IF functions in Excel to increases the conditions tested for and the actions carried out by the function. A step by step example is included.

Google Spreadsheets MEDIAN Function

The MEDIAN function in Google Spreadsheets can be used to find the middle or median value in a list of numbers. A step by step example is included in this tutorial.

Check the Results of the Freeze Panes Tutorial

Once the panes are frozen, we need to test them out. This last step in the tutorial covers testing the panes and using the name box to move quickly around an Excel worksheet.

Freeze or Lock Columns and Rows in Excel

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 Panes in Excel Using the Active Cell

The first step in freezing sections of the Excel spreadsheet is to decide which columns and rows you want to remain on screen. After this, you must tell Excel which areas to freeze. This is done using the active cell. This step in the tutorial covers how to place the active cell highlight so that the correct panes are frozen.

Adding the Tutorial Data

Use Excel's auto fill feature to add data for the freeze pane tutorial

Convert Excel 2010 Files to PDF Format

Convert or save files in PDF format in Excel 2010. Options include

Save Excel Files as PDF Files

Save Excel spreadsheets as PDF files in Excel. This tutorial shows you how to save Excel spreadsheets as PDF files in Excel.

Excel Spreadsheets Glossary of Terms - Row Definition

Definition of the term

Rank Numbers by Numerical Value with Excel's RANK Function

Use the RANK function in Excel to rank the value of a number compared to other numbers in a list. A step by step example is included.

Calculate the Number of Days between Two Dates in Excel

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.

Calculate Weighted Averages in Excel with SUMPRODUCT

Use the SUMPRODUCT function to calculate weighted averages in Excel. You set the weighting factors for each value. Step by step examples included.

Excel's Work Day International Function

Use Excel's WORKDAY.INTL function to find the start or end date of a project given a set number of work days. This tutorial includes a step by step example of how to find the start or end date of a project given a set number of work days using the WORKDAY.INTL function.

The HLOOKUP Table Array Argument

Adding the Table Array Argument in the HLOOKUP function step by step tutorial.

The HLOOKUP Row Index Number Argument

Adding the Row Index Number Argument in the HLOOKUP function step by step tutorial.

NETWORKDAYS.INTL Function Weekend Number Codes

Weekend Codes used for the different weekend days that can be used with the Excel NETWORKDAYS.INTL Function.

Entering Excel's VLOOKUP Function's Arguments

This step in the tutorial covers entering arguments for Excel's VLOOKUP function using the dialog box.

Excel's Work Day International Function

Use Excel's WORKDAY.INTL function to find the start or end date of a project given a set number of work days. This tutorial includes a step by step example of how to find the start or end date of a project given a set number of work days using the WORKDAY.INTL function.

How to use Excel's VLOOKUP Function

How to use VLOOKUP in Excel to retrieve specific data from a database or table of data. Step by step instructions are included.

Find Specific Data with Excel HLOOKUP

How to Use the HLOOKUP Function in Excel. This step by step tutorial shows you how to create and use the HLOOKUP function in Excel.

Starting the HLOOKUP Function

This step by step tutorial shows you how to create and use the HLOOKUP function in Excel.

The HLOOKUP Range Lookup Argument

Adding the Range Lookup Argument in the HLOOKUP function step by step tutorial.

Retrieving Data with the HLOOKUP Function

Using the finished HLOOKUP function to Retrieve Data.

Excel HLOOKUP Function Error Messages

Error Messages that you may see when using the Excel HLOOKUP function.

Excel HLOOKUP Step by Step Tutorial

How to Use the HLOOKUP Function in Excel. This step by step tutorial shows you how to create and use the HLOOKUP function in Excel.

Excel OFFSET Function Tutorial

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 SUM, COUNT, and MATCH. This tutorial includes a step by step example.

Creating a Dynamic Range With Excel OFFSET Function

By combining Excel's OFFSET function with the SUM function you can create formulas that will find totals for dynamic ranges of data.

Excel VLOOKUP Example: Find Data with VLOOKUP

Using the VLOOKUP function in Excel to find the discount pricing of an item based on the amount purchased. A step by step example is included.

Excel VLOOKUP Not Working: #N/A and #REF Errors

Explanation of common causes for #N/A and #REF error messages that can occur while using Excel's VLOOKUP. Function

Using Labels - Simplify Your Excel 2003 Formulas

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

Using Labels in Excel Functions and Formulas - Accept Labels in Formulas Option

In order to use labels in Excel formulas and functions, the option to accept labels in formulas must be activated in Options dialog box.

Using Labels in Excel Functions and Formulas - Adding Data to Cells in Excel Spreadsheets

Before creating a formula in an Excel spreadsheet, it is best to enter the pertinent data prior to creating the formula.

Using Labels in Excel Formulas and Functions

Here is a summary for the necessary steps to include labels in Excel formulas and functions.

Sum Cells that Fall Between Two Values with Excel SUMPRODUCT

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.

Entering Excel's VLOOKUP Function's Arguments Using Pointing

Using pointing to enter VLOOKUP's arguments into the function's dialog box. Step by step instructions are included.

Excel's CHAR and CODE Functions

Enter or remove characters and symbols in Excel with the CHAR/UNICHAR functions. Find the number code for characters with the CODE/UNICODE functions.

Combine Cells of Data in Google Spreadsheets

Google Spreadsheet's CONCATENATE function can be used to combine cells of text data in a new cell. A step by step example is included.

Remove ASCII Character #127 in Excel

ASCII character #127 is a program control character that can cause problems if it copied into an Excel worksheet. This tutorial covers how to remove the ASCII character #127 from data. A step by step example is included.

Google Spreadsheets CONCATENATE Function Example

This tutorial includes a step by step example of how to combine cells of data with the CONCATENATE function in Google Spreadsheets.

Excel LEN Function Tutorial

Excel's LEN function can be used to count up the number of characters in a text string or number entered into a cell. A step by step example is included with this tutorial.

Excel WorkDay Function: Find Project Start/End Dates

Use Excel's WORKDAY function to find the start or end date of a project given a set number of working days - excluding holidays and weekends.

Find the Average (Mode) with Excel's MODE.SNGL Function

Use Excel's MODE.SNGL function to find the mode - the most frequently occurring value in a group of numbers . A step by step example is included.

Excel's SUBSTITUTE Function Tutorial

This tutorial contains a step by step example of how to replace old text data with new using the Excel SUBSTITUTE function.

Excel MODE.MULT Function: Find Multiple Modes in Data

Use Excel's MODE.MULT function to find what multiple values - or multiple modes - occur most often in a range of data. Step by step example included.

Excel CHAR Function Step-By-Step Tutorial

The CHAR function can be used to enter special characters and symbols into Excel formulas. A step by step example is included with this tutorial.

How to Hide and Unhide Worksheets in Excel

How to quickly hide single and multiple worksheets in Excel. Step by step instructions are included.

How to Show or Unhide Columns in Excel - Including Column A

How to quickly and easily show or unhide columns in Excel - including Column A using shortcut keys or with a click of the mouse.

Hide and Unhide Column A and Row 1 in Excel

Use shortcut keys or the context menu to hide and unhide columns and rows in Excel - including unhiding column A and Row 1.

The Lookup Value Argument

Adding the Lookup Value Argument in the HLOOKUP function step by step tutorial.

How to Hide Rows in Excel

How to quickly and easily hide rows in Excel using shortcut keys or with a click of the mouse.

How to Show or Unhide Rows in Excel - Including Row 1

How to quickly and easily show or unhide rows in Excel - including row 1 using shortcut keys or with a click of the mouse.

Using Labels in Excel Functions and Formulas - Adding a Function in an Excel Spreadsheet

When creating an Excel formula using a function, it is sometimes easier to use a label in the formula rather than the actual cell reference.

Entering the Tutorial Data

Entering the Tutorial Data. for the HLOOKUP function tutorial.

Round Numbers Up or Down to the Nearest 5 or 10 in Excel

Round numbers up or down to the nearest 5, 10, or other specified multiple in Excel. Step by step instructions are included.

Nesting the ROUND and SUM Functions in Excel

Nesting the SUM and ROUND functions in Excel combines the operations of these two functions in a single worksheet cell. A step by step example is included.

Excel Basic Formula Example

This step in the tutorial covers entering the data and the formula into the Excel Worksheet.

Using Undo, Redo, and Repeat in Excel

Use Excel's Undo, Redo, and Repeat to save time fixing accidental changes or repeat formatting and layout changes to a worksheet.

Limit Rows and Columns in Excel Worksheet

How to limit the number of rows and columns available for use in an Excel worksheet. A step by step example is included.

Excel Hyperlinks, Bookmarks, and Mailto Shortcuts

How to add hyperlinks, bookmarks, and mailto links to Excel worksheets using keyboard shortcut keys. Step by step instructions are included.

Creating Bookmarks and Mailto Links in Excel

How to add bookmarks to other locations in an Excel file and mailto links for email addresses. Step by step instructions are included.

Calculate Days Between Two Dates in Excel

The NETWORKDAYS function can be used to calculate the number of whole working days between two dates. This tutorial includes a step by step example on using the NETWORKDAYS function in Excel.

Beginner's Guide to Excel Formulas

This tutorial covers basic information about formulas and includes a step by step example of how to create a formula in Excel. This tutorial is intended for those just getting started with Excel.

Excel Formula Basics

This tutorial covers the basics of writing formulas in Excel. A step by step example is included in the tutorial

Using Multiple Operators in Excel Formulas

This step in the tutorial creates a more complex formula in Excel using multiple mathematical operators and Excel's order of operations.

Using Pointing to Enter Cell References into an Excel Formula

This step in the tutorial covers using pointing to enter cell references into an Excel formula.

Wrap Text and Formulas on Multiple Lines in Excel

Using shortcut keys and menu options to wrap text and formulas on multiple lines in a worksheet cell. Step by step instructions are included.

Format Dates in Excel using Shortcut Keys

Quickly format dates in the day-month-year format using a keyboard shortcut in Excel.

Format Times in Excel using Shortcut Keys.

Quickly format times in the hour : minute format using a keyboard shortcut in Excel.

Using Cell References in Excel Formulas

This step in the tutorial using cell references in Excel formulas.

Mathematical Operators and the Order of Operations in Excel Formulas

This step in the tutorial covers the mathematical operators and Order of Operations used when writing Excel formulas.

Excel HLOOKUP Example (Function Tutorial)

This step in the tutorial works through a step by step example on HLOOKUP. Page 2.

Excel HLOOKUP Function Syntax

This step in the tutorial covers the syntax for Excel's HLOOKUP function.

What is Microsoft Excel and What Would I Use it for?

The uses and major features of Excel and other spreadsheets are covered such as storing, organizing and manipulating data, and creating charts and formulas.

Formatting Numbers in Excel using Shortcut Keys

Applying currency, percent, or number formatting using shortcut keys and ribbon options in Excel. Step by step instructions are included.

Add the Current Time using Shortcut Keys in Excel

This Excel shortcut keys tutorial shows you how to quickly add the current time to a worksheet using just the keyboard.

Applying Number Formatting using Shortcut Keys in Excel

Applying number formatting in Excel using shortcut keys or ribbon options. Step by step instructions are included.

Apply Currency Formatting in Excel using Shortcut Keys

Applying currency formatting in Excel using shortcut keys or ribbon options. Step by step instructions are included.

Apply Percent Formatting in Excel using Shortcut Keys

Applying percent formatting in Excel using shortcut keys or ribbon options. Step by step instructions are included.

Add the Current Date/Time in Excel using Shortcut Keys

Add and format the current date and time in Excel using keyboard shortcuts. Dates and times entered with this method do not change with recalculation.

Entering Data, Text, or Formulas with the Excel IF Function

Using the IF function to insert formulas, numbers, text, or leave target cells blank. Examples and instructions are included.

Excel Watermark Tutorial

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.

Using Excel's HLOOKUP Function to Find Data

Excelâ€™s HLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This tutorial includes an example of how to use the HLOOKUP function in Excel.

Test Multiple Conditions with Excel's AND and OR Functions

How to use the AND and/or OR function in Excel to test for multiple true or false conditions. A step by step example is included.

Round Numbers to the Nearest Odd Integer in Excel

The ODD function can be used to round numbers to the nearest odd integer. A step by step example is included.

Creating the Basic Column Chart

This step in the tutorial covers entering the column chart data and creating a basic column chart.

Adding and Coloring Gridlines to the Column Chart

This step in the tutorial covers adding and formatting the chart.s gridlines.

Column Chart in Excel Tutorial

This tutorial covers how to create and format a column chart in Microsoft Excel. The tutorial includes a step by step example.

Adding the Column Chart Title

This step in the tutorial covers adding a title to the column chart.

How to Make and Format a Line Graph in Excel

This tutorial covers how to create and format a basic line graph in Microsoft Excel. The tutorial includes a step by step example.

Making a Line Graph in Excel

This step in the tutorial covers entering the tutorial data and creating the basic line graph.

Formatting the Excel Line Graph

This step in the tutorial covers changing the line colors and the chart title in a basic line graph.

Round Numbers to the Nearest Even Integer in Excel

Use Excel's EVEN function to remove the decimal portion of values and round them to the nearest even integer. A step by step example is included.

Create a Chart in Excel using Shortcut Keys

How to add a chart to a worksheet using keyboard shortcut keys and how to change the default chart type in Excel. Step by step instructions are included.

Count Days Between Two Dates in Excel

The tutorials listed here cover Excel functions that will count the number of days between two dates. Each tutorial includes a step by step example of using the functions.

Defined Names and Scope in Excel

Defining and Setting the Scope for Named Ranges in Excel. Step by step examples are included.

Insert One or More Worksheets into Excel Using Shortcut Keys

How to insert one or more new worksheets into Excel using a keyboard shortcut; or using sheet tabs and the mouse; or using options located on the Home tab of the ribbon.

Create and Edit a Named Range or Defined Name in Excel

Named range definition and how to create/edit Named Ranges, or Defined Names in Excel. Scope and naming restrictions are also covered.

Excel Single Cell Array Formula

Combine an array formula with different functions in Excel to carry out multiple calculations in a single cell. Step by step example included.

Excel Single Cell Array Formula Tutorial

Entering the tutorial data for the Excel single cell array formula tutorial.

Adding the SUM Function in the Single Cell Array Formula Tutorial

This step in the tutorial covers adding the sum function to the location where the single cell array formula will be located.

Creating the Array Formula for the Single Cell Array Formula Tutorial

The last step is turning the sum function into an array formula in the Excel single cell array formula tutorial.

Changing the Column Chart Style and Column Colors

This step in the tutorial covers changing the chart's style and default colors

Formatting the Excel Line Graph

This step in the tutorial covers changing the background, text, and line colors in the line graph.

Defining and Managing Names with the Excel Name Manager

Defining, editing, and filtering named ranges using the New Name dialog box and the Name Manager in Excel. Step by step examples are included.

Using the Fill Handle to Copy Formulas in Excel

This tutorial covers using the fill handle to copy formulas in Excel. This step by step tutorial includes a step by step example on using the fill handle to copy formulas in Excel.

Excel Watermark Tutorial

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.

What is Cell? Excel and Google Spreadsheets

What a cell is, what is it used for, and how to add cells to and delete cells from worksheets in Excel and Google Spreadsheets.

Excel 2003 Line Graph Illustrated Tutorial

This tutorial covers creating a line graph in versions of Microsoft Excel up to and including Excel 2003. The tutorial includes a step by step example of creating a line graph in Excel using the Chart Wizard.

Entering the Line Graph Data

This step covers entering the data for the Excel 2003 line graph tutorial.

The Excel Chart Wizard Step 4

This step in the tutorial covers completing Step 4 of Excel's chart wizard.

Excel 2003 Pie Chart Tutorial

This tutorial covers creating a pie chart in Microsoft Excel 2003. The tutorial includes a step by step example of creating a pie chart in Excel using the Chart Wizard.

Pie Chart - Excel 2003 Pie Chart Tutorial

This tutorial covers creating a pie chart in Microsoft Excel 2003. The tutorial includes a step by step example of creating a pie chart in Excel using the Chart Wizard.

Pie Chart - Excel 2003 Pie Chart Tutorial

This tutorial covers creating a pie chart in Microsoft Excel 2003. The tutorial includes a step by step example of creating a pie chart in Excel using the Chart Wizard.

Pie Chart - Excel 2003 Pie Chart Tutorial

This tutorial covers creating a pie chart in Microsoft Excel 2003. The tutorial includes a step by step example of creating a pie chart in Excel using the Chart Wizard.

Pie Chart - Excel 2003 Pie Chart Tutorial

This tutorial covers creating a pie chart in Microsoft Excel 2003. The tutorial includes a step by step example of creating a pie chart in Excel using the Chart Wizard.

Pie Chart - Excel 2003 Pie Chart Tutorial

This tutorial covers creating a pie chart in Microsoft Excel 2003. The tutorial includes a step by step example of creating a pie chart in Excel using the Chart Wizard.

Pie Chart - Excel 2003 Pie Chart Tutorial

This tutorial covers creating a pie chart in Microsoft Excel 2003. The tutorial includes a step by step example of creating a pie chart in Excel using the Chart Wizard.

Pie Chart - Excel 2003 Pie Chart Tutorial

This tutorial covers creating a pie chart in Microsoft Excel 2003. The tutorial includes a step by step example of creating a pie chart in Excel using the Chart Wizard.

The Excel Chart Wizard Step 2

This step in the tutorial covers completing Step 2 of Excel's chart wizard.

Selecting the Line Graph Data

This step in the tutorial covers selecting the line graph data.

Starting the Chart Wizard

This step in the tutorial covers starting Excel's chart wizard.

The Excel Chart Wizard Step 1

This step in the tutorial covers completing Step 1 of Excel's chart wizard.

The Excel Chart Wizard Step 3

This step in the tutorial covers completing Step 3 of Excel's chart wizard.

Excel Database Functions - DMAX Tutorial

The DMAX function is one of Excel's database functions. It is used to find the largest or maximum number in a database or table of data. A step by step example is included in this tutorial.

Count Cells of Data with Excel's SUMPRODUCT Function

Use Excel's SUMPRODUCT function to count cells containing data that meets one or more criteria that you set. A step by step example is included.

Pictograph - Pictograph Example - Create a Pictograph

This step by step tutorial shows you how to create a pictograph in Excel 2007.

Formatting Sparklines in Excel

This step in the tutorial covers formatting sparklines in Excel.

Excel Sparklines Tutorial

Sparklines are tiny charts that fit into a single cell in a worksheet. This tutorial includes a step by step example.

Excel Sparklines Tutorial

Sparklines are tiny charts that fit into a single cell in a worksheet. This tutorial includes a step by step example.

Using Data Validation to Prevent Invalid Data Entry in Excel

Use Excel's data validation options to prevent invalid data entry in cells. A step by step example covers using data validation restrictions and an error alert message.

Excel Data Validation List from another Worksheet

Excel's data validation options include creating a drop down list using data from another worksheet. This step by step tutorial covers creating a data validation list in Excel using data from another worksheet.

Excel Data Validation: Create a Named Range for the List Data

This step in the tutorial covers creating a named range for the Excel data validation tutorial. Page 3.

Excel Drop Down List - Use Data Stored in Another Worksheet

Excel's data validation options include creating a drop down list using data from another worksheet. This step by step tutorial covers creating a data validation list in Excel using data from another worksheet.

Entering the Data for Creating a Drop Down List in Excel Tutorial

This step in the tutorial covers entering the data used in creating the drop down list.

Find Averages in an Excel Database with DAVERAGE

Use Excel's DAVERAGE function to find the average value for data that meets specific conditions that you set. A step by step example is included.

How to Create a Data List in Excel 2003

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.

Creating Tables and Lists in Excel - Illustrated Guide

This step provides an overview of lists and tables of data in Excel. In addition it describes the tools available for working with the data once it has been converted into a list. Page 2.

Creating Data Records in Excel

This step in the tutorial covers creating data records in the table.

Create a Data List in Excel 2003 - Illustrated Guide

Once the data has been entered properly into Excel, it can be converted to a

Microsoft Excel Tutorial - Tables of Data

This tutorial covers how to create a database in Excel. The step by step tutorial includes an example for you to work along with.

Entering Data Correctly into an Excel Database

This step in the tutorial covers the importance of correctly entering data into a database.

Microsoft Excel Tutorial - Rows Are Records

Each individual row of data, in a database is known as a record. When entering records keep these guidelines in mind.

Naming Fields and Headlining Columns in Excel

This step in the tutorial covers data fields in a database. Page 5.

Creating the Data Table in Excel

This step in the tutorial covers creating the data table in Excel.

Using Excel's Database Tools

This step in the tutorial covers using the database tools to work with data in Excel.

Entering New Records in an Excel Database

This step in the tutorial covers adding new records to an Excel database.

Formatting an Excel Database

This step in the tutorial covers adding formatting to an Excel database.

Excel Subtotal - Excel Subtotal Feature - Subtotal Data in Excel

Excel's Subtotal feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes an example of how to use Excel's Subtotal feature to find the largest values in subsections of a database.

Excel Subtotal - Excel Subtotal Feature - Subtotal Data in Excel

Excel's Subtotal feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes an example of how to use Excel's Subtotal feature to find the largest values in subsections of a database.

Subtotal Data Feature in Excel

Excel's Subtotal feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes an example of how to use Excel's Subtotal feature to find the largest values in subsections of a database.

Excel 2007 Subtotal Feature

This step by step tutorial includes an example of how to use Excel's Subtotal feature to find the lowest values in subsections of a database.

Excel 2007 Subtotal Feature - Find the Smallest Values

Excel's Subtotal feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes an example of how to use Excel's Subtotal feature to find the lowest values in subsections of a database.

Find Smallest Values With Excel 2007's Subtotal Feature

Excel's Subtotal feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes an example of how to use Excel's Subtotal feature to find the lowest values in subsections of a database.

Using a Drop Down List for Data Validation in Excel

Using the List option for Data Validation to create a drop down list in Excel. Step by step instructions are included.

Opening the Data Validation Dialog Box in Excel

Use the data validation dialog box in Excel to create a drop down list of data choices for a specific cell. Step by step instructions are included.