How to remove a drop down list from an Excel worksheet. Step by step instructions are included.

Options for Protecting the Drop Down List in Excel

Two options for protecting the drop down list data in Excel are to hide the column containing the data or to lock and protect worksheet cells.

Changing the Drop Down List Items in Excel

How to change the items displayed in an Excel a drop down list. Step by step instructions are included.

Completing the Drop Down List in Excel

Entering the data source as a range of cell references for a drop down list in Excel. Step by step instructions are included.

Opening the Excel Data Validation Dialog Box

This step in the tutorial covers starting the drop down list by opening the Excel data validation dialog box.

Using a List for Data Validation in Excel

This step in the tutorial covers choosing a list for data validation in Excel.

Entering the Data Source for the Excel Drop Down List

Part 6 of our tutorial on using an Excel data validation list from another worksheet explains how to enter the data source and complete the drop down list.

Editing the Excel Drop Down List Data

This step in the tutorial covers editing the drop down list data in Excel.

Protecting the Drop Down List in the Excel

This step in the tutorial covers options for protecting the drop down list data in Excel.

Inserting Subtotals and Totals Into a Database

Excel's Subtotal feature lets you find one or more subtotals in a database or data table. This tutorial includes a step by step example of how to insert subtotals and totals in Excel.

Excel DSUM Function Tutorial and Example

The DSUM function is one of Excel's database functions. It is used to add up or sum data that meets specific conditions that you set. A step by step example is included in this tutorial.

How to Create a Database in Excel

This step by step tutorial shows you how to create a database in Excel. The tutorial covers entering data, creating the database, and using the built in sorting and filter tools.

Sort by Rows to Reorder Columns in Excel

Use Excel's sort by rows option to change the order of columns left to right in a worksheet. A step by step example is included.

Selecting the List Range

The first step in creating a list is to select the range of cells containing the data to be used.

How to Create a Database in Excel

This step by step tutorial shows you how to create a database in Excel. The tutorial covers entering data, creating the database, and using the built in sorting and filter tools.

Excel Subtotals - Find the Largest Values

Find the largest values in a database or list of data with Excel's Subtotal feature. A step by step example is included.

Excel 2007 Subtotal Feature - Sorting the Data

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.

Creating a Drop Down List in Excel

How to create a drop down list for data entry in Excel. This tutorial includes a step by step example.

Inserting Subtotals and Totals Into a Database

Excel's Subtotal feature lets you find one or more subtotals in a database or data table. This tutorial includes a step by step example of how to insert subtotals and totals in Excel.

Create a Pictograph / Pictogram in Excel

In a pictograph or pictogram, pictures replace the colored columns or bars in a regular bar graph. This step by step tutorial shows you how to create a pictograph in Excel.

Pictograph - Pictograph Example - Create a Pictograph

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

Pictograph - Pictograph Example - Create a Pictograph

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

Excel Sparklines Tutorial

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

Entering the Sparklines Tutorial Data

This step in the tutorial covers entering the sparkline tutorial data

Creating Sparklines in Excel

This step in the tutorial covers creating 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.

Pictograph - Pictograph Example - Create a Pictograph

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

6 Ways to Sort Data in Excel

Six ways to sort data values in Excel - includes quick sorts on one column, sorting by date or time, multi-column sorts, and sorting by custom lists.

Find Averages with Excel's Subtotal Feature

Excel's Subtotal feature lets you find average values using the AVERAGE function in a database or table of data. This step by step tutorial includes an example of how to find an average value for your data using the Excel SUBTOTAL feature.

Enter the Subtotal Tutorial Data in Excel

This step in the tutorial covers entering the subtotal data.

Sorting Data by Days of the Week or by Months in Excel

Sort data by days of the week or by months of the year using Excel's built-in custom lists or add your own custom list to sort by.

Inserting Subtotals and Totals Into a Database

Excel's Subtotal feature lets you find one or more subtotals in a database or data table. This tutorial includes a step by step example of how to insert subtotals and totals in Excel.

Find Averages with Excel's Subtotal Feature

Excel's Subtotal feature lets you find average values using the AVERAGE function in a database or table of data. This step by step tutorial includes an example of how to find an average value for your data using the Excel SUBTOTAL feature.

Inserting Subtotals and Totals Into a Database

Excel's Subtotal feature lets you find one or more subtotals in a database or data table. This tutorial includes a step by step example of how to insert subtotals and totals in Excel.

Sorting the Subtotal Tutorial Data

This step in the tutorial covers sorting the subtotal data.

Inserting Subtotals and Totals in Excel

This step in the tutorial covers inserting subtotals and totals into the database.

Sort Data by Date or Time in Excel

How to sort data by dates or times in Excel. Step by step examples are included.

Sort Data by Conditional Formatting Icons in Excel

Use Excel's custom

Excel RIGHT Function: Extract Text Characters from Data

Use Excel's RIGHT function to remove unwanted characters from imported data or to truncate existing text. Step by step example included.

Cut and Paste Data in Excel with Shortcut Keys

Use shortcut keys or context menu options to move formulas, charts, or other data to different parts of the same or different worksheets in Excel.

Parts of the Microsoft Excel 2003 Screen

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

Excel 2003 Printing Options

This tutorial covers how to use the different print options in Excel to print entire spreadsheets or just selected areas.

The Print Button in Excel 2003

The print button on the standard toolbar is used to print a workbook using the current print settings. Settings can be changed using the Print dialog box.

Using Print Preview in Excel 2003

Print Preview displays the current worksheet in the preview window. It shows you how the worksheet will look when it is printed. The Print preview toolbar contains several options for viewing and changing the print options.

Excel 2003 Page Setup Dialog Box – Sheet Tab Settings

The sheet tab of the Page Setup dialog box contains several printing options such as print area and print titles. This step in the tutorial covers using the sheet tab settings in the page setup dialog box.

Setting and Clearing a Print Area in Excel 2003

Setting and clearing a print area allows you to specify an area of the worksheet to be printed. This option can be used to set multiple areas to be printed.

The Print Dialog Box Options in Excel 2003

The Print dialog box in Excel contains several printing options such as choosing a printer, printing specific pages or areas of a workbook and choosing the number of copies to print.

Freeze Column & Row Headings in Excel with Freeze Panes

Freezing panes in Excel keeps the headings at the top and down the side of the sheet from disappearing while scrolling. A step by step example is included.

Freezing the Top Row with Freeze Panes in Excel

Use freeze panes to freeze just the top row so that column headings stay on screen in an Excel worksheet.

Freezing the First Column of an Excel Worksheet with Freeze Panes

Use freeze panes to freeze just the first column so that row headings stay on screen in an Excel worksheet.

Freezing the First Column and Row with Freeze Panes in Excel

Use freeze panes to freeze both the first column and the first row so that column and row headings stay on screen in an Excel worksheet.

Unfreezing All Columns and Rows of an Excel Worksheet

Use unfreeze panes to remove all scrolling restrictions from columns and rows in an Excel worksheet.

Cut, Copy, and Paste Data in Excel with Shortcut Keys

Use shortcut keys or context menu options to copy or move formulas, charts, or other data to different parts of the same or different worksheets in Excel.

Double Click the Fill Handle to Copy Formulas

Instead of dragging the fill handle to copy formulas in Excel, try double clicking on it A step by step example is included

Combine Cells of Data in Excel

Excel's CONCATENATE function can be used to combine cells of data together. This tutorial includes a step by step example of how to combine cells of data with the CONCATENATE function in Excel.

Adding the Database Field Names

This step covers adding the database field names for the Excel 2003 data entry form tutorial.

Adding Data Records with the Form

This step covers adding data records with the form for the Excel 2003 data entry form tutorial.

Using the Form's Data Tools

This step covers using the forms built in data tools for the Excel 2003 data entry form tutorial.

Searching for Records Using the Excel Data Entry Form

This step covers searching for data records in the Excel 2003 data entry form tutorial.

Searching for Records Using the Excel Data Entry Form (con't)

This step continues with searching for data records in the Excel 2003 data entry form tutorial.

Adding Data Records with the Form (con't)

This step concludes adding data records with the form for the Excel 2003 data entry form tutorial.

Opening the Data Entry Form

This step covers opening the data entry form for the Excel 2003 data entry form tutorial.

Excel 2003 Data Entry Form Tutorial

This tutorial covers creating and using a data entry form to add data to a database in Excel 2003. A step by step example is included.

Inserting Subtotals and Totals Into a Database

Excel's Subtotal feature lets you find one or more subtotals in a database or data table. This tutorial includes a step by step example of how to insert subtotals and totals in Excel.

Find Averages with Excel's Subtotal Feature

Excel's Subtotal feature lets you find average values using the AVERAGE function in a database or table of data. This step by step tutorial includes an example of how to find an average value for your data using the Excel SUBTOTAL feature.

Find Averages with Excel's Subtotal Feature

Excel's Subtotal feature lets you find average values using the AVERAGE function in a database or table of data. This step by step tutorial includes an example of how to find an average value for your data using the Excel SUBTOTAL feature.

Sort on Multiple Columns of Data in Excel

How to sort data on multiple columns in Excel using the Sort dialog box. Step by step examples are included.

Excel Screen Elements - Parts of the Excel Screen

This labeled diagram identifies the main elements or parts of the Excel screen. Descriptions for each element are included.

Excel 2007 Page Setup Dialog Box - Sheet Tab Options

The Print dialog box in Excel contains printing options such as choosing a printer, printing specific pages of a workbook and choosing the number of copies.

Excel Printing - Using the Page Tab Settings - Printing in Excel

The page tab of the Page Setup dialog box contains several printing options such as paper orientation, scaling to change the size of the print area, and changes to the paper size and the print quality.This step in the tutorial covers using the page tab settings in the page setup dialog box.

Excel Printing - Setting and Clearing a Print Area - Printing in Excel

Setting and clearing a print area allows you to specify an area of the worksheet to be printed. Available under the file menu, this option can be used to set multiple areas to be printed. This step in the tutorial covers setting and clearing print areas.

Convert Text to Numbers with Excel Paste Special

Use Paste Special in Excel to convert values from text to numbers so they can be used in calculations. A step by step example is included.

Entering the SUM Function

This step in the tutorial involves entering the SUM function into the worksheet

Convert Text to Numbers with Excel Paste Special

This step in the tutorial completes the Paste Special example.

Link Data in Excel, Word, and PowerPoint with Paste Link

Paste links for data, charts and formulas in Excel, Word and PowerPoint that update between source and destination files. Step by step examples included.

Change the Cursor Movement Direction in Excel

This tip explains how to change the direction that the cell cursor moves when the Enter key is pressed in Excel.

Link Two Files in Excel with Paste Link

Link data located in two separate Excel files using Paste Link. When the source file changes the destination file will update as well. A step by step example is included.

Spreadsheet Print - Spreadsheet Print Options - Spreadsheet Printing

This tutorial on spreadsheet print options covers how to use the print options in Excel to set a print area, print an entire spreadsheet, or print just selected areas.

Excel 2007 - Printing From the Tool Bar

Covers various print option shortcuts for Excel 2007 that are on the toolbar, including quick print, print list and print preview.

Basic Excel 2010 Named Range Tutorial

This step by step tutorial shows how to use a named range in an Excel formula that can help multiply an employee's total income by the deduction rate.

Excel Formula Tutorial - Formula to Calculate Total Income

This tutorial includes a step by step example of how to create a basic formula in Excel that will calculate an employee's total income.

Entering the Tutorial Data

This step in the tutorial involves entering the tutorial data into an Excel worksheet

Use Worksheet Names in Excel Formulas

How to use worksheet names in Excel formulas plus how to rename a worksheet as well as naming restrictions.

Excel Printing -- Print Button - Printing in Excel

The print button on the standard toolbar is used to print a workbook using the current print settings. Settings can be changed using the Print dialog box. This step in the tutorial covers using the print button.

Excel Tutorial - Formatting Styles

This tutorial covers using pre-set formatting styles in Excel. The tutorial includes a step by step example of using pre-set formatting styles in Excel.

Excel 2007 Spreadsheet Print Options

This tutorial on Excel spreadsheet print options covers how to use the print options in Excel to set a print area and print a spreadsheet.

Parts of the Excel Screen

This labeled diagram shows the main parts of the Excel screen. Descriptions for each screen part are included.

Rename a Worksheet in Excel using Keyboard Keys

How to rename a worksheet in Excel using keyboard keys,naming restrictions, and the advantages of using worksheet names in Excel formulas.

How to Sort by Color in Excel

Use Excel's custom

Find Subtotals in an Excel Data Table

Excel's Subtotal feature lets you find subtotals, average, max, and min values in a table of data. The step by step tutorial includes examples of how to find subtotals using the Excel Subtotal feature.

Microsoft Excel 2003 Database Tutorial

This tutorial covers how to create a database in Microsoft Excel. This tutorial includes a step by step example on how to create a database in Excel.

Rows are Records

This step in the tutorial covers data records in a database.

Creating the Data Table in Microsoft Excel

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

Completing the Database Formatting

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

Create Simple Macros in Excel 2003 Using the Macro Recorder

This tutorial covers how to create simple macros in Excel 2003 using the macro recorder. This tutorial does not cover creating macros using VBA.

Excel Macro Recorder Tutorial

This tutorial covers how to create simple macros in Excel using the macro recorder. This tutorial does not cover creating macros using VBA.

Excel Database Tutorial

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

Excel Spreadsheets Glossary of Terms - Chart Axis Definition

Definition of the term

Excel Online Screen Elements

This labeled picture identifies the main elements or parts of the Excel Onlie screen. Descriptions of each screen element are included.

Basic Excel Online Tutorial

Excel Online is a free web-based spreadsheet program. This tutorial covers entering data, creating formulas, formatting and other basic operations. Step by step examples are included.

Excel 2007 Tutorial - Excel 2007 Step by Step Tutorial - Excel 2007 Spreadsheet Tutorial

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

Excel 2007 Tutorial - Adding Formulas in Excel 2007 - Excel 2007 Spreadsheet Tutorial

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

Excel 2007 Formatting - Formatting Excel 2007 Spreadsheets - Excel 2007

This tutorial covers formatting Excel 2007 spreadsheets. The topics covered include number, font, and styles formatting options.

Excel 2007 Formatting - Formatting Excel 2007 Spreadsheets - Excel 2007

This tutorial covers formatting Excel 2007 spreadsheets. The topics covered include number, font, and styles formatting options.

Excel 2007 Formatting - Formatting Excel 2007 Spreadsheets - Excel 2007

This tutorial covers formatting Excel 2007 spreadsheets. The topics covered include number, font, and styles formatting options.

Excel 2007 Formatting - Formatting Excel 2007 Spreadsheets - Excel 2007

This tutorial covers formatting Excel 2007 spreadsheets. The topics covered include number, font, and styles formatting options.

How to Register for Excel Online Spreadsheets

Before you can use Excel Online Spreadsheets you need to register - its free and its easy.

Excel Online Spreadsheet - Excel Online Spreadsheet Tutorial

Excel Web App is a free online spreadsheet program. This tutorial shows you how to get started using Excel Web App. It includes step by step examples on how to use this free online spreadsheet program.

Excel 2007 Tutorial - Excel 2007 Step by Step Tutorial - Excel 2007 Spreadsheet Tutorial

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

Excel 2007 Tutorial - Excel 2007 Step by Step Tutorial - Excel 2007 Spreadsheet Tutorial

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

Extract Good Data from Bad with Google Spreadsheets MID Function

Use Google Spreadsheets' MID function to extract good text data from bad. Step by step instructions are included.

Excel Spreadsheets Glossary of Terms - Decimal Number Definition

Definition of the term

Excel Online AVERAGE Function

The Excel Online AVERAGE function provides a quick and easy way to find the average value for a range of numbers. This tutorial includes a step by step example.

Excel Conditional Formatting Options

What is conditional formatting in Excel and how to use it to identify specific conditions in a worksheet that you specify. Step by step examples are included.

Excel Conditional Formatting Icons Sets

Use Excel's conditional formatting icon sets to create visual effects in your data based on its relative value. A step by step example is included.

Editing Conditional Formatting Icon Set Rules in Excel

This step in the tutorial edits the pre-set rules used by Excel for conditional formatting icon sets. A step by step example is included.

Use Custom Conditional Formatting Rules for Dates in Excel

Using formulas to customize conditional formatting rules in Excel. This tutorial uses a date formula and conditional formatting to highlight past due dates. A step by step example is included.

Excel Conditional Formatting Date Formula

Using formulas to customize conditional formatting rules in Excel. This tutorial uses a date formula and conditional formatting to highlight past due dates. A step by step example is included.

VLOOKUP Error Messages

This step in the tutorial covers error messages related to the Excel VLOOKUP function.

Excel VLOOKUP Function Alternative Formula

This step in the tutorial covers the syntax and arguments for the Excel VLOOKUP function. Page 2.

Excel VLOOKUP Alternative Formula

Excel's VLOOKUP function can be used to find specific data that is stored in a table of data. This tutorial includes a step by step example of using Excel's VLOOKUP function.

Overview of Excel Conditional Formatting Data

Conditional formatting allows you to emphasis data that meets certain conditions - such as equal to, greater than, or less than - that you set. If the data meets the set conditions, formatting options - such as changing cell or font color - are activated, This tutorial includes a step by step example.

Count Records in an Excel Database - DCOUNT Tutorial

The DCOUNT function is one of Excel's database functions. It is used to count the number of records in a database that meet specific conditions that you set. A step by step example is included in this tutorial.

Find Specific Records in an Excel Database (DGET)

The DGET function is one of Excel's database functions. It is used to count the number of records in a database that meet specific conditions that you set. A step by step example is included in this tutorial.

How to Remove a Drop Down List in Excel

This tutorial covers how to remove a drop down list and other data validation options from an Excel worksheet.

Excel Database Functions - DMIN Tutorial

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

Microsoft Excel Functions

Here you will find step by step tutorials on the most useful and most used functions in Excel including the IF function, VLOOKUP, SUM, and CONCATENATE,

Excel Charts and Graphs

Here you will find tutorials on how to create and format Excel's most commonly used charts and graphs. Each tutorial includes a step by step example.

Google Spreadsheet Tutorials

Google Drive web apps includes is a free online spreadsheet program. The program offers such benefits as easy sharing of spreadsheet files, online storage, and real time editing over the Internet. Collaborating with colleagues was never easier.

Excel Formulas

Here you will find step by step tutorials covering how to create and use formulas in Excel.

Excel IF Function Tutorials

The IF function is one of Excelâ€™s most useful and most used functions. What it does is test to see whether a certain condition is true or false. These tutorials cover creating and using the IF function in Excel spreadsheets and give examples of how this versatile function can be utilized.

Random Numbers - Random Numbers in Excel

Listed here are the functions in Excel that can be used to generate random numbers.

Excel Definitions - Spreadsheet Terms Beginning with the Letters X, Y and Z

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

Google Spreadsheets Math and Statistical Functions

Google Spreadsheets Math and Statistical Functions

Excel Data Management

Here you will find tutorials on how to create a database in Excel as well as a creating drop down lists, using the data entry form, sorting and filtering data, removing duplicate records, and more.

Excel Tips, Tools and Features Tutorials

Microsoft Excel contains a number of tools, features, and shortcuts that, while they may not be used all that often, can really simplify working with spreadsheets. Here you will find tips and tutorials on using features such macros, freeze panes, protecting worksheets, and templates that can help to make using Excel as straightforward and as painless as possible.

Excel Shortcut Keys Tutorials

Excel has shortcut keys to quickly accomplish common tasks such as adding a worksheet, showing formulas, and adding the current date. These tutorials include step by step instructions on how to use shortcut keys in Excel.

Excel VLOOKUP Tutorials

These tutorials on how to use VLOOKUP and other Lookup formulas and functions in Excel include step by step examples.

Excel SIGN Function Tutorial

The SIGN function will tell you whether the number in a cell is negative or positive in value or whether it is equal to zero. This tutorial includes a step by step example of using the SIGN function in Excel.

Counting Numbers with Excel's COUNT Function Shortcut

Use Excel's COUNT function or Counting Numbers shortcut to count only those cells in a range containing numbers. A step by step example is included.

Count the Percentage of Yes/No Responses in Excel

Find the percentage of yes or no responses in a data range using the COUNTIF and COUNTA functions in Excel. The same formula can be used to find the percentage of any one value - not just yes and no. This tutorial includes a step by step example.

Move Between Open Windows with ALT TAB Switching

This shortcut keys tutorial shows you how to move between open program windows using just the keyboard.

Turn AutoComplete On or Off in Excel

How to disable or re-enable Excel's AutoComplete feature. Step by step instructions are included.

Use Excel's NOW Function in Date and Time Calculations

Use Excel's NOW function to add the current time or date to worksheets or for use in formulas. Step by step instructions are included.

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.

"What if" Questions and Excel Formulas

#NULL!, #REF!, #DIV/0!, and ##### Errors in Excel

The main causes for #NULL!, #REF!, #DIV/0!, and ##### errors in Excel worksheets are listed along with the most likely cures for these problems.

Google Spreadsheets NOW Function in Date and Time Calculations

Use Google Spreadsheets' NOW function to add the current time or date to worksheets or for use in formulas. Step by step instructions are included.

Google Sheets COUNTIF: Count Data Matching Set Criterion

Use Google Spreadsheets' COUNTIF function to find the number of cells in a range that meet criteria that you specify. A step by step example is included.

Google Spreadsheets IF Function

The IF function lets you set conditions and returns different results depending on whether the condition is TRUE or FALSE. A step by step example is included.

Count Numbers Only with Google Spreadsheets' COUNT Function

Use Google Spreadsheets' COUNT function to count cells that contain numbers - the function ignores blank cells, text and other types of data. A step by step example is included.

Entering Dates with the DATE Function in Google Spreadsheets

Use Google Spreadsheets' DATE function to properly enter dates into a worksheet or into other date formulas. A step by step example is included.

Sorting Data in Excel 2003 - Step-By-Step

Using Excel 2003's sort feature. Step by step example of sorting data in Excel 2003.

Free Excel Time Sheet Template

This article shows you how to quickly download and use a free employee time sheet template in Excel.

Applying Italics Formatting in Excel with Shortcut Keys

This Excel shortcut keys tutorial shows you how to apply italics formatting to an Excel spreadsheet using a keyboard shortcut.

Use Excel's Fill Down Command with Shortcut Keys

Copy data to multiple cells in Excel using a keyboard shortcut.

Excel's Comparison Operator - Definition and Use

Definition and use of the term

How to Multiply in Excel

How to multiply in Excel gives step by step instructions on how to multiply two numbers in Excel using a simple formula.

Sharing Options for a Google Spreadsheet

One of the key features of a Google Spreadsheet is that people can collaborate and share information over the Internet. This article covers the steps necessary to share a Google Spreadsheet.

Excel Array Formulas

An Array Formula can be used to carry out multiple calculations in a single cell or it can be used to carry out a single calculation in multiple cells using more then one set of values.

Google Spreadsheet Formulas

Below are a number of formulas that carry out common calculations in Google Spreadsheets - such as adding and subtracting.

Excel Definitions - Spreadsheet Terms Beginning with the Letters I and J

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

Google Spreadsheets Logical Functions

Google Spreadsheets' Logical Functions can be used to introduce decision making into your spreadsheet.

Excel Nested Functions

Combining two or more Excel Functions in one formula can be accomplished by

Google Spreadsheets Basic Math Formulas

Tutorials and examples of how to make and use basic math formulas in Google Spreadsheets to add, subtract, multiply, and divide data.

Excel Tips - Microsoft Excel Tips

This list of Excel tips is covers how to carry out a variety of tasks in Excel. Many of the tutorials cover how to use basic features that are often overlooked. Each of these tips includes a step by step example.

Excel Line Graph Tutorials

Excel Line Graph Tutorials. Spreadsheets.

Excel Pictograph Tutorials

Pictographs are specialized column charts. The tutorials in this section cover creating and formatting Pictograph in Excel.

Excel Pie Chart Tutorials

Excel Pie Chart Tutorials. Spreadsheets.

Excel 2003 Chart Tutorials

The tutorials in this section cover charts and graphs in Excel 2003.

Excel Stock Market Chart Tutorials

The tutorials in this section cover creating stock market charts in Excel,

Excel Database Function Tutorials

The list of tutorials below cover using Excel database tutorials such as DSUM, DMAX, and DAVERAGE. Each tutorial includes a step by step example to show you how the function works.

Excel Data Entry Form Tutorials

The data entry form can make it easy to enter large amounts of data into an Excel database. The form also makes it easy to find, edit, and delete records. Step by step examples are included with the tutorials.

Excel Drop Down List Tutorials

A drop down list makes it easier to enter data from a set list of choices. It can also help prevent data entry errors by limiting what data can be entered into a particular cell.

Excel Sorting Tutorials

Sorting data can not only make it easier to read, but sorting is required for a number of Excel functions and features. These tutorials cover a simple sort, sorting by multiple columns, sorting by date, and sorting by cell or font color. Step by step examples are included with each tutorial.

Excel Subtotal Tutorials

Excel's Subtotal feature helps you draw specific information from one or more subsections of a database. Subtotals and totals, average values, max and min values, and counting the number of rows of data included in a range can all be found with this feature.

Excel Database Function Tutorials

The list of tutorials below cover using Excel database tutorials such as DSUM, DMAX, and DAVERAGE. Each tutorial includes a step by step example to show you how the function works.

Google Spreadsheets Count Functions

Google Spreadsheets Count Functions

Google Spreadsheets Trigonometric Functions

Google Spreadsheets Trigonometric Functions

Google Spreadsheets Rounding Number Functions

Included here are the functions in Google Spreadsheets that can be used to round numbers up, down, or to remove the decimal portion of numbers entirely.

Google Spreadsheets Text Functions

Google Spreadsheets' text functions helps you edit and manage text data in a worksheet. Every tutorial includes a step by step example.

Excel Definitions - Spreadsheet Terms Beginning with the Letter E

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

Excel 2003

Excel 2003 tutorials on how to get started with Excel formulas, functions and more. Thesetutorials include step by step examples of how to use Excel 2003.

Lookup and Reference Functions - Excel Lookup and Reference Functions

Excel's Lookup and Reference Functions can be used to simplify finding specific entries in a data table.

Excel Definitions - Spreadsheet Terms Beginning with the Letter F

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

Spreadsheet Definitions and Terms - Letter L

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

Excel How To Videos

These short instructional videos cover how to complete a variety of tasks in Excel such using VLOOKUP and the IF function, freezing panes, and creating a macro with the macro recorder. Each video includes a transcript of the video's contents.

Google Spreadsheets Date Functions

Google Spreadsheets Date Functions

Excel Lookup Function Tutorials

Excel Lookup Function Tutorials. Spreadsheets.

Excel Logical Functions

Excel's Logical Functions can be used to introduce decision making into your spreadsheet.

Rounding Number Functions

Included here are the functions in Excel that can be used to round numbers up or down.

Excel Trig Functions: Find the Sine, Cosine, & Tangent

Excel's list of functions includes the common Trig functions that can be used to find the sine, cosine, and tangent of an angle.

Excel Engineering Function Tutorials

Excel's Engineering Functions. Spreadsheets.

Excel Definitions - Spreadsheet Terms Beginning with the Letter G

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

Excel Definitions - Spreadsheet Terms Beginning with the Letter H

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

Information Functions - Excel Information Functions

Excel's Information functions gives you information about the data in a cell or range of cells. This information includes whether the data is a number, the formatting applied to the cell, or even if the cell is empty.

Excel Definitions - Spreadsheet Terms Beginning with the Letter K

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

Excel Conditional Formatting Tutorials

Excel Conditional Formatting Tutorials

Excel Templates - Microsoft Excel Templates

How to create a template in Excel. Also listed are tutorials on how to use several popular templates that can be downloaded for free from Microsoft's website - such as a basic flowchart template, time line, and budget templates.

Excel Definitions - Spreadsheet Terms Beginning with the Letter B

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

Spreadsheet Definitions and Terms - Letter M

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

Excel Definitions - Spreadsheet Terms Beginning with the Letters N and O

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

Excel Definitions - Spreadsheet Terms Beginning with the Letters P and Q

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

Spreadsheet Definitions and Terms - Letter R

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

Spreadsheet Definitions and Terms - Letter S

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

Excel Definitions - Spreadsheet Terms Beginning with the Letter T

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

Table Definition and Features in Excel

Definition and use of the term

Excel TYPE Function: Check the Type of Data in a Cell

Use Excel's TYPE function to find out what type of data is located in a single worksheet cell. A step by step example is included.

Six Time-Saving Tips in Excel

Six time-saving tips for Excel to help you get work done fast.

Volatile Functions Definition and Use in Excel

Definition and description of the term volatile function as it is used in spreadsheet programs such as Excel and Google Spreadsheets.

Syntax Definition and Use in Excel and Google Sheets

Syntax definition and use at it pertains to Excel and Google Spreadsheets.

Nested Function Definition and Use in Excel

Definition and use of the term

Text String Definition and Use in Excel

Definition and use of the term

Conditional Formatting Overdue/Upcoming Dates in Excel

Use Excel's pre-set conditional formatting options to find overdue or upcoming important dates. A step by step example is included.

The Name Box and Its Many Uses in Excel

The Name Box is a very versatile feature that can help you select cells, define names, and navigate to specific data locations in Excel.

Find the Third or Seventh Smallest Data Entry in Excel

Use Excel's SMALL function to find data based on its size relative to the other numbers - such as the third or seventh smallest number.

Definition, Uses and Examples of Functions in Excel

Definition and uses of the term

Boolean Value Definition and Use in Excel

Definition and use of Boolean values in programs such as Excel and Google Spreadsheets. Includes using Boolean values in formulas and functions.

Excel File Extensions: XLSX, XLSM, XLS, XLTX and XLTM

Definition of the term

Dialog Box Definition - Excel Spreadsheets Glossary of Terms

What a

Formula Bar (fx bar) in Excel and Google Spreadsheets

Definition of, and the uses for the formula or fx bar in Excel and Google Spreadsheets.

Plot Area in Excel and Google Spreadsheets Charts

Definition of the term Plot Area as it applies to charts and graphs in Excel and Google Spreadsheets.

Spreadsheet Program Definition and Uses

Definition of the term spreadsheet and a general description of the features and uses of spreadsheet programs such as Excel and Google Spreadsheets.

Hide/Unhide Scroll Bars and Reset the Vertical Slider Range in Excel

How to hide/unhide scroll bars and how to reset the vertical scroll bar slider range in Excel. Step by step instructions are included.

When Excel's TRIM Function Doesn't Work - Alternative Formula

If the TRIM function on its own can't remove extra spaces from text data, try this alternative formula using the TRIM, SUBSTITUTE and CHAR functions.

Ignore Error Values when Finding the Average in Excel

Ignore errors that affect the results when calculating the average value for data in Excel using the ISNUMBER, AVERAGE, and IF functions.

Find the Largest Negative or Positive Number in Excel

Use the MAX - IF array formula in Excel to find the largest positive or negative value for a range of data. A step by step example is included.

Ribbon (Definition) - Excel Glossary of Terms

How to customize the ribbon in Microsoft Excel and other Microsoft Office programs. Step by step instructions are included..

Using Excel's AutoFormat Feature

Excel's Autoformat option gives you 17 AutoFormat styles to use to give your spreadsheets a professional look. Instructions on how to apply an autoformat style are included.

Serial Number / Serial Date Definition - Excel

Definition of

Replace or Add Characters with Excel's REPLACE Function

Use Excel's REPLACE function to replace bad text data with good data or with nothing at all. A step by step example is included.

Properly Enter Dates in Excel with the DATE Function

Use Excel's DATE function to properly enter dates into a worksheet or into other date formulas. A step by step example is included.

Excel ISBLANK Function Tutorial

The ISBLANK function's job is to check to see if a certain cell is empty or not. This tutorial includes an example of how to use this function.

Finding Squares Roots, Cube Roots, and nth Roots in Excel

How to find square, cube, and nth roots in Excel using exponents and functions in formulas. A step by step example is included.

Excel MAX IF Array Formula

Combine Excel's MAX and IF functions in an array formula to find the largest or maximum value for a range of data. A step by step example is included.

Conditionally Formatting Above/Below Average Values in Excel

Find and display data that is above or below the average value using Excel's built-in conditional formatting. Step by step instructions are included.

Find Duplicate Data in Excel with Conditional Formatting

Find and highlight duplicate or unique data in Excel with conditional formatting. A step by step example is included.

Excel MEDIAN IF Array Formula

By combining the MEDIAN and the IF functions in an array formula in Excel, we can find the middle value for a range of data when a specific criterion is met. A step by step example is included on how to create a MEDIAN IF array formula.

Combine the MIN and IF Functions in an Array Formula

Combine Excel's MIN and IF functions in an array formula to find the smallest or minimum value for a range of data. A step by step example is included.

Find Worksheet Information with Excel's CELL Function

Use Excel's CELL function to find information about a cell such as formatting, data type,and worksheet location. A step by step example is included.

Open Office Calc Tutorials

These tutorials cover how to use many of the common features and options in the free spreadsheet program Open Office Calc.

Filter Definition - Excel Spreadsheets Glossary

Learn the definition of the term

Excel Quick Access Toolbar

The toolbar contains shortcuts to a number of commonly performed tasks such as open, save, undo and quick print.

Convert Text Values to Dates with Excel's DATEVALUE Function

Converting imported text to dates in an Excel worksheet using the DATEVALUE function. A step by step example is included.

Use Today's Date in Excel Worksheet Calculations

Use Excel's TODAY function in date calculations and to add the current date to a worksheet. Step by step instructions are included.

Find Information about Excel with the INFO Function

The INFO function returns information related to the current Excel file such as the current recalculation mode or file location. Examples are included.

Macro Definition - Excel Spreadsheets Glossary

Definition of the term

Blog

Excel 2003 Conditional Formatting

Set conditional formatting options in Excel when data in chosen cells meets specific conditions that you choose. Step by step instructions are included.

Legend Definition - Excel Spreadsheets Glossary of Terms

Read the definition of

How to Add a Drop Down List in Excel

Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. These tutorials include step by step examples of how to create a drop down list in Excel.

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.

Excel List Tools

This step in the tutorial covers the data tools available for sorting and filtering the finished list.

Entering Data into a Table

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

Creating Field Names in Excel

This step in the tutorial covers field names and how to create them for Excel lists.

Sort Data by Font Color in Excel

Use Excel's custom

Excel HLOOKUP Error Messages

This step in the tutorial covers error messages or error values associated with the HLOOKUP function.

Excel Macro Recorder Tutorial

This tutorial covers how to create simple macros in Excel using the macro recorder. This tutorial does not cover creating macros using VBA.

Excel Macro Recorder Tutorial

This tutorial covers how to create simple macros in Excel using the macro recorder. This tutorial does not cover creating macros using VBA.

Excel Macro Recorder Tutorial: Running a Macro

This tutorial covers how to create and run a simple macro in Excel using the macro recorder. This tutorial does not cover creating macros using VBA.

Editing an Excel Macro Using the Macro Recorder

This tutorial covers how to create and run a simple macro in Excel using the macro recorder. This tutorial does not cover creating macros using VBA.

Changing the Chart Text

This step in the tutorial covers changing the font type, color, and size.

Excel Integer Reference Definition

Definition of the term

Excel Spreadsheets Glossary of Terms - Data

Definition of the term

Microsoft Errors - Microsoft Office Errors - Excel Errors

Microsoft Office 2007 Diagnostics is a group of tests that can be used to help correct errors in Microsoft Office files. The diagnostic tests can correct certain errors directly and will give information on such things as your computerâ€™s memory and hard drive, that can be used fix problems found on these devices.

Excel Toolbar - Excel Quick Access Toolbar

The Quick Access Toolbar is used to store shortcuts to frequently used features in Excel. This tutorial shows you how to add the printing options to the Quick Access Toolbar.

Excel VLOOKUP Function Error Messages

What #N/A and #REF! errors mean when something goes wrong with Excel's VLOOKUP function.

Excel Math Formula Tutorials

These tutorial cover how to carry out basic math operations in Excel using formulas. The tutorials cover how to add, subtract, multiply, or divide numbers in Excel using formulas.

Excel Drop Down List Tutorial Part 2

Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This tutorial shows you how to create a drop down list in Excel sing data from a different worksheet.

Excel's SUM IF Array Formula

Using a nested SUM and IF array formula count when multiple conditions are met in a table of data. A step by step example is included.

- By Category

An index of categories in the

Create, Copy, and Modify Custom Cell Styles in Excel

Create and apply custom cell styles to multiple Excel worksheets to save time and to give your work a consistent look.

How to Use Excel 2003 - Tutorials for Beginners

How to Use Excel 2003 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.

How to Use Microsoft Excel

How to Use Excel is a series of free tutorials for the absolute beginner. Learn the names of Excel screen elements, how to enter data, how to use Excel formulas and functions, add/remove columns and rows, and how to create charts.

Flip Data in Excel Using Paste Special

Use paste special in Excel to transpose data from rows to columns or columns to rows. No functions, no formulas, no cell references required. Step by step instructions included..

Highlight Cells Definition - Excel Spreadsheets Glossary of Terms

Definition of the term

How to Show or Unhide a Worksheet in Excel

How to quickly show or unhide a previously hidden worksheet in Excel. Step by step instructions are included.

Using Goal Seek in Excel (Tutorial)

Excel's Goal Seek feature allows you to alter data in formulas to get different results. Goal Seek can be used when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.

Excel Lookup Formula Tutorials

Excel Lookup Formula Tutorials. Spreadsheets.

Excel Spreadsheets Glossary of Terms - Sort Key Definition

Definition of the term

Select Non-Adjacent Cells in Excel with Keyboard and Mouse

How to select non-adjacent cells in Excel using just the keyboard or by using both the keyboard and mouse. Step by step instructions are included.

Displaying Text Statements or Leaving Cells Blank with the Excel IF Function

Using the IF function to display text statements or leave target cells blank. Examples and instructions are included.

Create a Template in Excel 2007 - Tutorial

This tutorial shows you how to quickly create a template in Excel 2007.

Customize the Quick Access Toolbar in Excel

The Quick Access Toolbar is used to store shortcuts to frequently used features in Excel. This tutorial shows you how to add the autoformat button to the Quick Access Toolbar.

Excel Spreadsheets Glossary of Terms - Value Definition

Definition of the term

Free Online Excel Training and Courses

This free online Excel training consists of free email courses that offer you training in a number of Excel topics. The free training includes beginners tutorials and data management in Excel.

Excel Bar Graph Formatting Tutorial

This tutorial covers a number of formatting options for bar graphs in Excel.

Find and Show a Microsoft Excel Toolbar

This quick tip shows you how to find and show a toolbar that isn't visible in Excel. Good for finding a toolbar in Excel 97 to Excel 2003.

Insert a New Excel Worksheet Using the Mouse and Sheet Tabs

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

Paste Values only with Excel Paste Special

Use paste special in Excel to paste only the values - the results - of formulas into worksheet cells. a step by step example is included.

Excel Spreadsheets - Sort Order Definition

Definition of the term

Excel Line Graph Tutorial

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

Excel Themes: Color Your Work

How to create, change, customize, and save, formatting themes in Excel.

Excel 2007 Office Button Definition

Definition of the Office Button found only in Excel 2007 and other Microsoft Office 2007 applications.

Excel Alternatives - Spreadsheet Software

As an alternative to Excel here you will find tutorials on other spreadsheet software such as EditGrid and Microsoft Works Spreadsheet program.

Free Excel Alternative Spreadsheet Tutorials

As an alternative to Excel here you will find tutorials on free spreadsheet software such as Calc, Google Docs Spreadsheets, Microsoft's Excel Web App Online, and Microsoft Works - which was usually given away free with new computers.

Excel Online Spreadsheet Program

Excel Online is a free web-based spreadsheet program by Microsoft that offers many of the tools and features of the regular program. Tutorials listed here cover how to use various features of the program.

Excel Online Spreadsheets Tutorials

Excel Online is part of Microsoft's OneDrive suite of Web Apps available free online with an Internet connection. These tutorials include step by step examples of how to use a variety of features and functions available in Excel Online.

Gridlines Definition - Excel Spreadsheets Glossary of Terms

Definition of the term

Excel Spreadsheets Glossary of Terms - Status Bar Definition

Definition of the term

Advanced Excel Tutorials

Here you will find tutorials on some of Excel's advanced features such as macros, lookup functions, array formulas, pivot tables, and data management.

Excel Training - Getting Started with Excel

Excel Training - Getting Started with Excel

Template Definition - Excel Spreadsheets Glossary of Terms

Definition of the term

Formatting the Line Graph (Continued)

This step in the tutorial continues with formatting options for the basic line graph.

Formatting the Line Graph

This step in the tutorial covers formatting the basic line graph.

Free Excel 2003 Training Videos

Watch these training videos on various aspects of Microsoft Excel. Through live screencasts, experts will show you how you can use a variety of features in Excel. A full transcript is provided so you can follow the training videos on your own.

Excel - Merge and Center the Worksheet Title

Excel's merge and center option allows you to merge a number of cells in a worksheet and center text across the merged cells. This step by step tutorial includes an example showing you how to merge cells and center text in Excel.

Freezing the Panes in Excel

The freeze panes feature in Microsoft Excel is located under the Window menu. This step in the tutorial works through the step needed for turning on freeze panes.

Entering Data Correctly

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

Columns are Fields

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

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.

How to Customize Excel 2003 Auto Fill Handle

This tutorial shows you how to customize the fill handle in Excel 2003.

Free Excel Pie Chart Tutorials

Free tutorials on how to create and format a pie chart in Excel. Each tutorial includes a step by step example of how to create and format a pie chart in Excel.

Excel Spreadsheets Glossary of Terms - Rounding Definition

Definition of the term Rounding as it is used in spreadsheet programs such as Excel.

Excel Training - Getting Started with Excel 2010

Getting Started with Excel 2010 provides free online training in Excel 2010. This set of tutorials includes step by step examples on how to create a basic spreadsheet in Excel 2010.

Edit Grid Free Online Spreadsheets

EditGrid is a free online spreadsheet program that has the same feature set as other speadsheets - like formulas, functions, and charts. As a

Microsoft Works Spreadsheets Tutorials

Microsoft Works Spreadsheets has the features most commonly used in other spreadsheets. This list of articles gives you straightforward instructions on how to carry out a variety of tasks in Microsoft Works Spreadsheets. Examples are included to make understanding the steps involved even easier to follow.

OpenOffice Calc Spreadsheet Tutorials

OpenOffice Calc, is an electronic spreadsheet program offered free of charge by openoffice.org. The program is easy to use and contains most, if not all of the commonly used features found in commercial spreadsheet programs. The tutorials found here contain step by step examples.

Excel 2010 Functions

The tutorials listed in this section are for functions that are only available in the latest version of Excel for PC's - Excel 2010.

Excel Training - Get Started with Excel Formulas

Excel Training - Get Started with Excel Formulas

Excel Training - Data Management in Excel

Excel Training - Data Management in Excel

Excel Spreadsheets Glossary of Terms - Chart Wizard Definition

Definition of the term

Excel Array Formula Tutorials

An array formula in Excel is a formula that carries out calculations on one or more elements in an array. An array formula can be a simple mathematical formula or it can be a complex calculation containing one or more functions. These tutorials include step by step examples of using array formulas to carry out calculations on multiple elements in an array.

Excel Math Functions - Perform Basic Math Operations in Excel

Excel's Math Functions can be used to perform common mathematical operations such as addition (SUM function), multiplication (product function), and rounding numbers (ROUND function).

Rounding Numbers, Rounding Numbers in Excel

Rounding numbers in Excel can be accomplished with a number of different functions - depending on the results you want. There are function for rounding numbers up or down as well as ones that can remove the decimal portion altogether.

Excel COUNT - Excel COUNT Functions

Excel has a number of Count functions that each have a specific job. One counts cells containing number data, another only counts cells that meet criteria that you specify, and another only counts cells that are blank. Each tutorial in this section contains a step by step example of using one of Excel's Count Functions.

IF Function - Excel IF Function Tutorials

Besides the IF function itself, Excel has a number of functions that combine the IF function with another well used function such as the SUM, AVERAGE, and COUNT functions to create SUMIF, COUNTIF, AVERAGEIF and so on. The tutorials in this section include a step by step example of using the IF function or one of Excel's Something - IF Functions.

Lookup and Reference Functions - Excel Lookup and Reference Functions

Excel's Lookup and Reference Functions can be used to simplify finding specific entries in a data table.

Text Functions - Excel's Text Functions

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

Excel DATE - Excel DATE Functions

Dates are very important in spreadsheet programs and Excel has a number of date functions. The articles below list a number of date-related tutorials, each or which includes a step by step example of working with dates in Excel 2010.

Excel Tips - Microsoft Excel Tips - Quick Excel Tips and Tricks

These tips gives you straightforward instructions and information on how to carry out a variety of tasks in Excel. Examples are included with many of the tips. The tips have been subdivided into a number of subcategories.

Excel 2010 Tools and Features

Covered in this section are tools and features available in Excel 2010. The first to be covered will be those that are new to the program, such as saving or converting files to PDF format.

Statistical Functions - Excel's Statistical Functions

Excel's Statistical Functions can be used to analyze the data in a spreadsheet. For example, they can be used to find the largest or smallest number in a list of data or the oldest or newest date.

Charts and Graphs Tips

These tips give you information on creating and using a charts and graphs in spreadsheets including creating a custom chart in Excel.

Excel FAQs - Excel Frequently Asked Questions - Excel FAQs

This group of Excel FAQs (frequently asked questions) gives you background information on various Excel features that will help you understand how these features work.

Excel Formulas and Functions - Excel Formula and Function Tips

These tips cover a variety of tasks related to formulas and functions in Microsoft Excel.

Keyboard Shortcuts - Excel Keyboard Shortcuts

These Excel tips show you how to use keyboard shortcuts to quickly accomplish common spreadsheet tasks such as adding the current time and date, applying formatting, or showing hidden columns or rows.

Lookup and Reference Functions - Excel Lookup and Reference Functions

Excel's Lookup and Reference Functions can be used to simplify finding specific entries in a data table.

Charts and Graphs - Chart and Graph Tips

These tips give you information on creating and using a charts and graphs in spreadsheets including creating a custom chart in Excel.

Excel 2007 - Excel 2007 Tips - Excel 2007 Information

These tips give you information on a number of topics in Excel 2007.

Excel Formatting - Excel Formatting Tips

These tips give you straightforward answers on how to carry out a variety of formatting tasks such as auto fill, autoformat, and using the format painter.

Excel Tips - Excel Function Tips - Excel Tips

These Excel tips specifically covers tips related to functions - including the IF function. Many of the articles include examples to make it easier to understand how the functions work.

Excel Tips - Other Excel Tips

Tips on a variety of topics. The odds and ends that don't fit neatly into one of the other categories.