Spreadsheets Sitemap - Page 3 2016-09-26

Remove a Drop Down List in Excel
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.