Use the ROUND function in Excel Online to round numbers up or down a set number of decimal places or digits. A step by step example is included.

Rounding Numbers in Excel with the ROUND Function

Use Excel's ROUND function to round values up or down a specific number of decimal places or digits. A step by step example is included.

Excel 101- How to Use Excel

Here you will find step by step tutorials for beginners on how to use the basic features and options of Microsoft Excel. Tutorials include how to create and use formulas for calculations, entering data, formatting worksheets, printing, and creating charts and graphs.

Excel PMT Function: Calculate Loans or Saving Plans

Use Excel's PMT function to calculate loan payments or saving plans for investments. Step by step examples included.

Financial Functions - Excel's Financial Functions

Excel's Financial Functions can be used to help you determine changes in dollar value of investments and loans.

Columns and Rows

Definition and uses of columns and rows in spreadsheet programs such as Excel and Google Spreadsheets.

Excel VALUE Function: Convert Text to Numbers

Use Excel's VALUE function to convert text data or dates and times to numbers for use in calculations. A step by step example is included.

Excel Stock Market Chart Tutorial

This tutorial covers creating a Hi-Lo-Close stock market chart in Microsoft Excel. The tutorial includes a step by step example of creating a Hi-Lo-Close stock market chart in Excel.

Excel Stock Market Chart Tutorial

This tutorial covers creating a Hi-Lo-Close stock market chart in Microsoft Excel. The tutorial includes a step by step example of creating a Hi-Lo-Close stock market chart in Excel.

Excel Stock Market Chart Tutorial

This tutorial covers creating a High-Low-Close stock market chart in Microsoft Excel. The tutorial includes a step by step example of creating a High-Low-Close stock market chart in Excel.

Entering the Data for the Excel Stock Market Chart Tutorial

This step in the tutorial covers entering the data for the Excel Stock Market Chart Tutorial.

Excel Stock Market Chart Tutorial

This tutorial covers creating a Hi-Lo-Close stock market chart in Microsoft Excel. The tutorial includes a step by step example of creating aHigh-Low-Close stock market chart in Excel.

Excel Stock Market Chart Tutorial

This tutorial covers creating a High-Low-Close stock market chart in Microsoft Excel. The tutorial includes a step by step example of creating a Hi-Lo-Close stock market chart in Excel.

Making a High, Low,& Close Stock Prices Chart in Excel

This tutorial covers creating a High-Low-Close stock market chart in Microsoft Excel. The tutorial includes a step by step example of creating a High-Low-Close stock market chart in Excel.

Count All Types of Data with Google Spreadsheets COUNTA

Use Google Spreadsheets' COUNTA function to count text, numbers, error values, and more in a selected range of cells. Step by step example included.

Counting All Types of Data with COUNTA in Excel

Use Excel's COUNTA function to count cells containing any type of data - text, numbers, error values etc. Empty cells are ignored.

Find the Remainder when Dividing with Excel's MOD Function

The MOD function is used to divide numbers in Excel. All it returns, however, is the remainder. A step by step example is included.

Divide in Excel with the QUOTIENT Function

Use Excel's QUOTIENT function to return the integer portion of division operations without the remainder. A step by step example is included.

Math Functions - Excel Math Functions

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

How to Divide in Excel using a Formula

How to divide in Excel shows you how easy it is to divide two numbers using a formula. Also covered are #DIV/O! errors and how to calculate percents.

Excel DATEDIF: Count Days, Months, or Years

Use Excel's DATEDIF function to count the number of days, months, or years between two dates. A step by step example is included.

Argument Definition and Use - Excel Spreadsheets Glossary

Definition, use, and examples of the term argument as it is used in spreadsheet programs such as Excel and Google Spreadsheets.

Excel Multi-Cell Array Formula Calculations

Multi-cell array formulas in Excel carry out calculations in multiple cells using the same formula but different data. Step by step example included.

Creating the Base Formula for the Excel Array Formula Tutorial

The first step in creating a multi cell array formula is to add the same base formula to all cells where the multi cell array formula will be located.

Excel Cell References - Relative, Absolute, and Mixed

Descriptions of and uses for relative cell references, absolute cell references, and mixed cell references in Excel and Google Spreadsheets.

Spreadsheet Definitions and Terms - Letter D

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

Excel Chart Data Series, Data Points, Data Labels

Definition and uses of the terms data points, data markers, data labels, and data series as used in Excel and Google Spreadsheets charts and graphs.

Excel DAYS360 Function: Count Days Between Dates

Use Excel's DAYS360 function to calculate payment schedules for accounting systems based on a 360-day year (twelve 30-day months).

Truncate Data in Excel and Google Spreadsheets

Truncating text and number data in Excel and Google Spreadsheets - what it means and how it is accomplished.

Excel INT Function - Round Down to the Nearest Integer

Use Excel's INT function to remove all decimal places from a number leaving just the integer or whole number. A step by step example is included.

Ignore Zeros when Finding the Average in Excel

Use Excel's AVERAGEIF function to ignore zeros when trying to find the average value for a range of data. A step by step example is included.

Excel Count Function Tutorial List

Excel's count functions allow you to count up the number of cells being used for a specific purpose such as the number of cells containing number values or the number of blank cells in a data range.

Zoom in Excel: Changing Worksheet Magnification

Change worksheet magnification in Excel using the zoom slider or shortcut keys on the keyboard. Step by step instructions are included.

Finding, Modifying, and Moving Excel 2003 Toolbars

How to change the default settings for toolbars in Excel 2003 and earlier versions of the program. Includes how to add/remove buttons to toolbars.

Review of Google Sheets

Google Sheets is a free spreadsheet program with many features and strengths. This article gives an overview of many of the programs features such as online file sharing and offline access to files.

Find Multiple Fields of Data with Excel VLOOKUP

The VLOOKUP and COLUMN function can be used to return multiple values from a single row or record of data in Excel. This tutorial includes a step by step example of creating a lookup formula to return multiple fields of data.

Entering the Lookup Criteria

This step in the tutorial covers entering the lookup criteria in order to return data values with the lookup formula in Excel.

Entering the Tutorial Data

This step involves entering the tutorial data.

Creating a Named Range in Excel

This step in the tutorial creates a named range for the data table.

Opening the VLOOKUP Dialog Box

This step in the tutorial covers opening the VLOOKUP dialog box.

Entering the Lookup Value Argument

This step in the tutorial covers entering the lookup value argument for the lookup formula in Excel.

Entering the Table Array Argument

This step in the tutorial covers entering the table array argument for the lookup formula in Excel.

Entering the COLUMN Function as the Column Index Number

This step in the tutorial covers entering the COLUMN function as the range lookup argument.

Entering the VLOOKUP Range Lookup Argument

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

Copying the Lookup Formula with the Fill Handle

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

Excel CHOOSE Function Tutorial

The CHOOSE function can be used to return a value from a list based upon its position in the list. A step by step example is included with this tutorial.

Excel CHOOSE Function Tutorial

The CHOOSE function can be used to return a value from a list based upon its position in the list. A step by step example is included with this tutorial.

Working with Worksheets in Excel

Information and links on Excel worksheet-related topics - add/delete/hide worksheets, lock cells of data, freeze worksheet columns and rows and more.

Excel EDATE Function: Add/Subtract Months to Dates

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

Excel TRANSPOSE Function: Flip Rows or Columns of Data

Use Excel's TRANSPOSE function to switch or flip data from a row into a column or from a column into a row. Step by step example included.

Insertion Point Definition and Use in Excel

Definition and use of the term

Find Cells Containing Numbers with Excel ISNUMBER

Use Excel's ISNUMBER function to check whether selected cells contain number data. A step by step example is included.

Transpose or Flip Rows or Columns of Data in Excel

Use Excel's TRANSPOSE function to switch or flip data from a row into a column or from a column into a row. A step by step example is included.

Excel SUMPRODUCT: Count Multiple Criteria

This tutorial uses the SUMPRODUCT function to count up the number of cells in selected ranges that meet multiple criteria in Excel. It can be used in place of COUNTIFS which is not available in Excel 2003 and earlier versions.

Excel Spreadsheets Glossary of Terms - Radio Button Definition

Definition of the term

Excel COLUMN Function Illustrated Tutorial

Uses include finding the column number for the cell where the function is located, or finding the number for a column of a given cell reference.

Entering the SUMIFS Function's Criteria2 Argument

This step in the tutorial covers entering the SUMIFS function's Criteria2 argument.

Entering the Average_range Argument for the Excel AVERAGE IF Function

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

Count Data in Selected Cells with Excel COUNTIF

Excel's COUNTIF function is used to count up the number of times specific data is found in a selected group of cells. Step by step instructions are included.

Entering the Data for the Excel COUNTIF Function Tutorial

This step covers entering the data for the Excel COUNTIF Function Tutorial.

The COUNTIF Function's Syntax

This step in the tutorial covers the syntax for the Excel COUNTIF Function.

Opening the COUNTIF Function Dialog Box

This step in the tutorial covers opening the COUNTIF function dialog box.

Entering the Excel COUNTIF Function Range Argument

This step in the tutorial covers entering the Excel COUNTIF function range argument

Entering the Excel COUNTIF Function Criteria Argument

This step in the tutorial covers entering the Excel COUNTIF function criteria argument.

Adding Search Criteria for the Excel COUNTIF Function Tutorial

This step in the tutorial covers adding search criteria for the Excel COUNTIF Function.

Excel SUMIFS: Sum Only Values Meeting Multiple Criteria

Use Excel's SUMIFS function to total up the number of cells in selected ranges that meet specific criteria that you set. Step by step example included.

Adding the Search Criteria and Completing the SUMIFS Function Tutorial

This step in the tutorial covers entering the SUMIFS function's Criteria2 argument.

Entering the SUMIFS Function Tutorial Data

This step covers entering the SUMIFS function tutorial data.

Excel SUMIFS Function Syntax

This step in the tutorial covers the SUMIFS function syntax.

Starting the SUMIFS Function

This step in the tutorial covers locating and opening the SUMIFS function dialog box.

Entering the SUMIFS Function's Sum_range Argument

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

Entering the SUMIFS Function's Criteria_range1 Argument

This step in the tutorial covers entering the SUMIFS function's Criteria_range1 argument.

Entering the SUMIFS Function's Criteria1 Argument

This step in the tutorial covers entering the SUMIFS function's Criteria1 argument.

Entering the SUMIFS Function's Criteria_range2 Argument

This step in the tutorial covers entering the SUMIFS function's Criteria_range2 argument.

Opening the AVERAGEIF Function Dialog Box

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

Entering the Criteria Argument for the Excel AVERAGEIF Function

Entering the criteria argument for the Excel AVERAGEIF Function step by step tutorial.

Adding the Search Criteria for the Excel AVERAGE IF Function

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

Entering the Range Argument for the Excel AVERAGEIF Function

Entering the range argument for the Excel AVERAGEIF Function step by step tutorial.

Excel Column Chart Tutorials

The tutorials in this section cover creating column charts or bar graphs in Excel,

Syntax for the Excel AVERAGEIF Function

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

Entering Tutorial Data for the Excel AVERAGEIF Function Tutorial

Entering Tutorial Data for the Excel AVERAGEIF Function Step by Step Tutorial.

Excel AVERAGEIF: Find the Average for Specific Criteria

The AVERAGEIF function finds the average value - but only if the selected values meet specific criteria that you set. Step by step example included.

Excel COUNTIFS Function Step by Step Tutorial

Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.

Google Docs Spreadsheet Formula Tutorial

This tutorial covers creating and using a simple Google Spreadsheet formula. The tutorial includes a step by step example of creating a Google Spreadsheet formula.

Google Spreadsheet Formula - Google Spreadsheet Formula Tutorial

This tutorial covers creating and using a simple Google Spreadsheets formula. The tutorial includes a step by step example of creating a Google Spreadsheets formula.

Google Spreadsheet Formula - Google Spreadsheet Formula Tutorial

This tutorial covers creating and using a simple Google Spreadsheet formula. The tutorial includes a step by step example of creating a Google Spreadsheet formula.

Google Spreadsheet Formula Tutorial

This tutorial covers creating and using a simple Google Spreadsheet formula. The tutorial includes a step by step example of creating a Google Spreadsheet formula.

Using Mathematical Operators in a Google Spreadsheet

This tutorial covers creating and using a simple Google Spreadsheet formula. The tutorial includes a step by step example of creating a Google Spreadsheet formula.

Order of Operations - Google Spreadsheet Order of Operations

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

Excel Dice Roller Tutorial

This tutorial covers how to create a pair of rolling dice in Excel. The tutorial makes use of the IF, AND, OR, and RANDBETWEEN functions to simulate the rolling of a pair of dice.

Excel Formatting Techniques: Create a Dice-Rolling Program

This step in the tutorial covers the formatting techniques used to graphically display one face of a pair of dice in your worksheet. Page 2.

Adding the RANDBETWEEN Function to the Excel Dice Roller Program

This step in the tutorial covers the RANDBETWEEN function to randomly generate the number of dots that will appear on the dice each time it is

Adding the IF and AND Functions to the Excel Dice Roller Program

This step in the tutorial covers nesting the IF and AND functions in the Excel Dice Roller program.

Adding a second IF Function to the Excel Dice Roller Program

This step in the tutorial uses a second IF function in the Excel Dice Roller program.

Adding the IF and AND Functions to the Excel Dice Roller Program

This step in the tutorial covers nesting the IF and AND functions in the Excel Dice Roller program.

Adding the IF and OR Functions to the Excel Dice Roller Program

This step in the tutorial covers nesting the IF and OR functions in the Excel Dice Roller program.

Rolling the Dice

This step in the tutorial covers

Hiding the RANDBETWEEN Function

This step in the tutorial covers hiding the RANDBETWEEN function in the Excel Dice Roller Program.

Open Office Calc Tutorial - Step by Step

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

Open Office Calc Tutorial - Open Office Calc Step by Step Tutorial

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

Open Office Calc Tutorial - Open Office Calc Step by Step Tutorial

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

Open Office Calc Basic Spreadsheet Tutorial

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

Open Office Calc Tutorial - Open Office Calc Step by Step Tutorial

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

Open Office Calc Step-by-Step Tutorial

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

Open Office Calc Tutorial - Open Office Calc Step by Step Tutorial

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

Excel's COUNTIFS Function Tutorial

Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. Step by step instructions are included.

Excel COUNTIFS Function Step by Step Tutorial

Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.

Excel COUNTIFS Function Step by Step Tutorial

Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.

Excel COUNTIFS Function Step by Step Tutorial

Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.

Excel COUNTIFS Function Step by Step Tutorial

Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.

Excel COUNTIFS Function Step by Step Tutorial

Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.

Excel COUNTIFS Function Step by Step Tutorial

Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.

Excel COUNTIFS Function Step by Step Tutorial

Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.

Open Office Calc Tutorial - Open Office Calc Step by Step Tutorial

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

Open Office Calc Tutorial - Open Office Calc Step by Step Tutorial

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

Free Spreadsheet Tutorials (Various Programs)

Listed here are tutorials on free spreadsheet programs such as Google Spreadsheets and OpenOffice Calc. The tutorials are also free. The tutorials cover a variety of topics about creating and using a spreadsheet.

Subtract Dates in Excel with the YEAR Function

Use the YEAR function to subtract dates in Excel. This tutorial includes an example of using the DAY function to subtract two dates in Excel.en two dates.

Excel Lookup Formula with Multiple Criteria

How to create a Lookup formula that uses multiple criteria in Excel. This tutorial includes a step by step example of creating a lookup function with multiple criteria in Excel.

Excel Lookup Formula with Multiple Criteria

How to create a Lookup formula that uses multiple criteria in Excel. This tutorial includes a step by step example of creating a lookup function with multiple criteria in Excel.

Excel Lookup Formula with Multiple Criteria

How to create a Lookup formula that uses multiple criteria in Excel. This tutorial includes a step by step example of creating a lookup function with multiple criteria in Excel.

Using Excel's INDEX Function in a Lookup Formula

The INDEX function can be used as part of a Lookup formula that allows multiple criteria in Excel. This step in the tutorial covers using the INDEX function in a lookup function with multiple criteria in Excel.

Entering Excel's INDEX Function Array Argument

The INDEX function can be used as part of a Lookup formula that allows multiple criteria in Excel. This step in the tutorial covers using the INDEX function in a lookup function with multiple criteria in Excel.

Using Excel's MATCH Function in a Lookup Formula

The MATCH function can be used as part of a Lookup formula that allows multiple criteria in Excel. This step in the tutorial covers using the MATCH function in a lookup function with multiple criteria in Excel.

Adding the Lookup_array for the MATCH Function

The MATCH function can be used as part of a Lookup formula that allows multiple criteria in Excel. This step in the tutorial covers using the MATCH function in a lookup function with multiple criteria in Excel.

Adding the Match type Argument for Excel's MATCH Function

The MATCH function can be used as part of a Lookup formula that allows multiple criteria in Excel. This step in the tutorial covers using the MATCH function in a lookup function with multiple criteria in Excel.

Entering the INDEX Function's Column_num Argument

The INDEX function can be used as part of a Lookup formula that allows multiple criteria in Excel. This step in the tutorial covers entering the INDEX function's Column_num argument.

Excel Array Formula Example

A Lookup formula with multiple criteria in Excel involves creating an array formula. This step in the tutorial covers creating an array formula in order to complete the lookup function with multiple criteria in Excel.

Excel Two Way Lookup Formula Using VLOOKUP

Excelâ€™s VLOOKUP function can be used along with the MATCH function to create a two way lookup formula that finds data at the intersection point of a row and column of data. This tutorial includes includes a step by step example of creating a two way lookup formula using VLOOKUP.

Entering the Tutorial Data

This step involves entering the tutorial data.

Opening the VLOOKUP Dialog Box

This step in the tutorial covers opening the VLOOKUP dialog box.

Entering the Lookup Value Argument

This step in the tutorial covers entering the lookup value argument for the VLOOKUP function.

Entering the Table Array Argument

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

Excel Two Way Lookup Using VLOOKUP - Part 1

This step in the tutorial creates a named range for the data table. Page 3.

Excel Spreadsheets Glossary of Terms - Marching Ants Definition

Definition of the term

Estimate Standard Deviation with Excel's STDEV Function

Use Excel's STDEV function to estimate standard deviation for each number in a list from the overall average. A step by step example is included.

Excel Median Function: Find the Middle (Average) Value

Use the MEDIAN function in Excel to find the middle or average value in a list of numbers. A step by step example is included.

Copy Formulas and Data with Excel's Fill Handle

Use Excel Fill Handle to copy formulas, data, a series of numbers, days of the week, and months of the year. Step by step examples are included.

Timeline Template - Free Timeline Template - Free Excel Timeline Template

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

Excel Timeline Template Guide - Timeline Topics

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

Downloading Free Excel Timeline Template

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

Timeline Template - Free Timeline Template - Free Excel Timeline Template

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

Timeline Template - Free Timeline Template - Free Excel Timeline Template

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

Timeline Template - Free Timeline Template - Free Excel Timeline Template

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

Timeline Template - Free Timeline Template - Free Excel Timeline Template

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

Timeline Template - Free Timeline Template - Free Excel Timeline Template

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

The IF Function Logical Test Argument

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

Excel IF Function - Starting the Function

This step in the tutorial covers entering the function's arguments using the IF function dialog box. A step by step example is included.

Entering the Value If True Argument

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

Entering the Value If False Argument

This step in the tutorial covers entering the IF function Value_if_false argument. A step by step example is included.

Copying the IF Function using the Fill Handle

This step in the tutorial covers copying the IF function using the Fill Handle.

Customize Cell Data with Excel's IF Function

Use Excel's IF function to customize data displayed in one or more worksheet cells based on conditions that you specify. A step by step example is included.

Round Numbers Up or Down to the Nearest 5 or 10 in Google Spreadsheets

Round numbers up or down to the nearest 5, 10, or other specified multiple in Google Spreadsheets. A step by step example is included.

How to Calculate Your Age With Excel's DATEDIF Function

One use for the DATEDIF function is to calculate a person's current age in years, months, and days. This tutorial includes a step by step example of using the DATEDIF function to calculate current age.

How to Create a Pictograph in Excel 2003

This step by step tutorial shows you how to create a pictograph / pictogram in Excel 97 to Excel 2003.

Pictograph - Pictograph Example - Create a Pictograph

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

Pictograph - Pictograph Example - Create a Pictograph

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

Pictograph - Pictograph Example - Create a Pictograph

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

How to Create and Format a Pie Chart in Excel

Use a pie chart in Excel to show the percentage each slice of the pie represents of the total chart value. A step by step example is included

Entering and Selecting the Chart Data in an Excel Pie Chart

This step in the tutorial covers selecting the chart data and creating a basic, unformatted pie chart.

Adding Data Labels to the Excel Pie Chart

This step in the tutorial covers adding data labels to the pie chart data and deleting the chart's legend.

Changing Colors in the Pie Chart

This step in the tutorial covers changing the colors of the pie slices, the background color, and the text color in the chart.

Adding Category Names and Rotating the Excel Pie Chart

This step in the tutorial covers adding category names to the data labels and rotating the chart on the X and Y axes.

Changing Fonts Type and Exploding a Piece of the Chart

This step in the tutorial covers changing the fonts used for the chart title and data labels. It also covers manually exploding out a slice of the chart to add emphasis to that piece.

Formatting Negative, Long, and Special Numbers in Excel

Use Excel's formatting options to correctly display special numbers - such as credit card, zip code, and negative numbers. Step by step examples included.

Formatting Numbers as Fractions in Excel

Formatting decimal numbers to display as fractions in Excel. Step by step instructions are included.

Formatting Special Numbers - phone, zip codes, etc. - in Excel

Applying special formatting to zip codes, phone or social security numbers in Excel. Step by step instructions are included.

Formatting Numbers as Text in Excel

Applying text formatting to long numbers - such as credit card numbers - in Excel to have them display properly. Step by step instructions are included.

Add and Delete Rows and Columns in Excel Using Shortcut Keys

How to quickly add and delete rows and columns in Excel - includes using a keyboard shortcut. Step by step examples are included.

Delete One or More Rows in Excel Using Shortcut Keys

How to delete one or more rows from an Excel Worksheet. Step by step examples are included.

Add One or More Columns in Excel Using Shortcut Keys

How to add or insert one or more columns to an Excel Worksheet. Step by step examples are included.

Delete One or More Columns in Excel Using Shortcut Keys

How to delete one or more columns from an Excel Worksheet. Step by step examples are included.

Excel Conditional Formatting Data Bars

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

Excel 2003 Page Setup Dialog Box – Page Tab Settings

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.

Setting and Clearing a Print Area in Excel

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.

Adding to a Print Area - Excel 2007 Print Options

This step in the tutorial covers how to add to an existing print area in Excel.

Print Titles on Multiple Pages in Excel

This step in the tutorial covers how to add to print titles on multiple pages in Excel.

Scale to Fit Print Options in Excel

This step in the tutorial covers how to use the scale to fit print options in Excel.

Spreadsheet Print Options

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

Print Gridlines & Headings - Excel 2007 Print Options

In this step in the tutorial we cover how to print gridlines and headings in Excel.

Excel Basic Step by Step Tutorial for Beginners

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

Entering Data into an Excel Worksheet

This step in the tutorial covers entering data into an Excel worksheet.

Widening Columns in Excel

This step in the tutorial covers widening worksheet columns in Excel in order to fully display the data in the cells.

Adding the Date and a Named Range in Excel

This step in the tutorial covers adding the date and a named range in Excel.

Using Formulas in Excel

This step in the tutorial covers entering formulas to perform calculations in Excel.

Using Formulas in Excel

This step in the tutorial covers entering formulas to perform calculations in Excel.

Copying Formulas with the Fill Handle

This step in the tutorial covers copying formulas with the Fill Handle in Excel.

Applying Number Formatting in Excel

This step in the tutorial covers applying number formatting - such as currency and percent formatting - to number data in Excel

Applying Cell Formatting in Excel

This step in the tutorial covers applying cell formatting - such as changing data alignment, adding borders, and using the merge and center feature in Excel.

Shortcut Keys to Common Excel Tools and Features

Ten of the most common spreadsheet terms and definitions used in programs such as Excel, Microsoft Works, and Google Docs Spreadsheets

Shortcut Keys to Common Excel Tools and Features

Ten of the most common spreadsheet terms and definitions used in programs such as Excel, Microsoft Works, and Google Docs Spreadsheets

Shortcut Keys to Common Excel Tools and Features

Ten of the most common spreadsheet terms and definitions used in programs such as Excel, Microsoft Works, and Google Docs Spreadsheets

Excel Volume-High-Low-Close Stock Market Chart

A Volume-High-Low-Close stock market chart is a bar chart used to show changes in the value of tradable assets over a given period of time. A step by step example is included.

Entering and Selecting the Stock Market Chart Data

This step in the tutorial covers entering and selecting the stock market chart data.

Creating a Basic Volume-High-Low-Close Stock Market Chart in Excel

This step in the tutorial covers adding a basic Volume-High-Low-Close stock market chart to an Excel worksheet.

Formatting the Stock Market Chart Using the Chart Tools

This step in the tutorial covers formatting the Volume-High-Low-Close stock market chart using the chart tools.

Formatting the Stock Market Chart Labels and Values

This step in the tutorial covers formatting the Volume-High-Low-Close stock market chart's labels and values.

Formatting the Stock Market Chart Close Marker

This step in the tutorial covers formatting the Volume-High-Low-Close stock market chart's close marker.

Change the Background Color of Excel Stock Market Chart

This step in the tutorial covers changing the background color of the Excel Volume-High-Low-Close stock market chart.

Change the Plot Area Background in Excel Stock Chart

This step in the tutorial covers changing the plot area background color of the Excel Volume-High-Low-Close stock market chart.

Adding 3-D Bevel Effect and Resizing Excel Chart

This step in the tutorial covers adding the 3-D bevel effect and resizing the Excel Volume-High-Low-Close stock market chart.

CONVERT Function Measurement Units and Their Shortforms

This page in the tutorial includes a list of unit shortforms that can be used with Excel's CONVERT function.

Convert Measurements Function in Excel

The CONVERT function is used to convert measurements from one set of units to another such as meters to feet. This tutorial includes a step by step example showing how to convert measurements in Excel.

Use a Dynamic Range with the COUNT Function in Excel

This tutorial combines the INDIRECT and COUNT functions to create a count formula with a dynamic range that is easily changed. A step by step example is included.

How to Create a Bar Graph/ Column Chart in Excel

This tutorial covers creating a bar graph (or column chart) in Microsoft Excel. This tutorial includes a step by step example of creating a bar graph in Excel.

Step by Step Excel 2003 Bar Graph Tutorial

Use a bar graph in Excel to compare and display values across categories using vertical bars. A step by step example is included.

Excel Bar Graph Tutorial

Use a bar graph in Excel to compare and display values across categories using vertical bars. A step by step example is included.

Excel Bar Graph Tutorial

Use a bar graph in Excel to compare and display values across categories using vertical bars. A step by step example is included.

Excel Bar Graph Tutorial

Use a bar graph in Excel to compare and display values across categories using vertical bars. A step by step example is included.

Excel Bar Graph Tutorial

Use a bar graph in Excel to compare and display values across categories using vertical bars. A step by step example is included.

Excel Bar Graph Tutorial

Use a bar graph in Excel to compare and display values across categories using vertical bars. A step by step example is included.

Excel Bar Graph Tutorial

Use a bar graph in Excel to compare and display values across categories using vertical bars. A step by step example is included.

Excel Bar Graph Tutorial

Use a bar graph in Excel to compare and display values across categories using vertical bars. A step by step example is included..

Emphasizing Chart Data - Exploding Pie Charts in Excel

Explode out a single slice of an Excel pie chart or create pie of pie or bar of pie charts to emphasize important data. Step by step instructions included.

Remove Duplicate Rows of Data in Excel

Use the Remove Duplicates data tool to find and remove identical or partially matching rows or data records from Excel databases or tables of data.

Remove Duplicate Data Records in Excel

This tutorial shows you how to remove rows of duplicate data or records from an Excel database. The tutorial includes a step by step example of how to remove duplicate data records in Excel.

Applying the Protect Sheet Option in Excel

Applying the Protect Sheet option is the second step to protecting specific cells containing formulas and other important data in an Excel worksheet.

How to Organize and Find Data with Excel Pivot Tables

Excel pivot tables makes it easy to organize and extract information from tables of data without the use of formulas. A step by step example is included.

Entering the Excel Pivot Table Data

This step in the tutorial covers entering the tutorial data.

Excel Pivot Tables Step by Step Tutorial

This step in the tutorial covers creating the pivot table.

Adding Data to the Excel Pivot Table

This step in the tutorial covers adding data to the pivot table.

Filtering the Pivot Table Data - Tutorial

This step in the tutorial covers filtering the pivot table data.

Changing the Pivot Table Data - Tutorial

This step in the tutorial covers changing the pivot table data.

How to Lock Cells and Protect Worksheets in Excel

Use Excel's security features to protect specific cells containing formulas and other important data by locking cells and protecting the worksheet.

Google Spreadsheets Table of Weekend Number Codes and Corresponding Weekend Days

Use Google Spreadsheets WORKDAY.INTL function to find the start or end date of a project given a set number of work days. A step by step example is included.

Find a Project's Start or End Date with Google Spreadsheets' WORKDAY.INTL Function

Use Google Spreadsheets WORKDAY.INTL function to find the start or end date of a project given a set number of work days. A step by step example is included.

Entering the WORKDAY.INTL Function

This step in the tutorial covers entering the WORKDAY.INTL function into a worksheet cell.

Excel Ecourse Step 7 - Adding the Net Salary Formula

This step in the Excel eCourse tutorial covers creating a basic formula in Excel.

How to Create a Line Graph in Excel 2010

How to create and format a line graph in Excel 2010. A step by step example is included.

Excel Line Graph Tutorial - Formatting

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 Line Graph Tutorial- Selecting a Line Graph Type

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 Line Graph Tutorial - Select the Line Data

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.

Entering the Tutorial Data

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

Create Simple Macros in Excel with the Macro Recorder

This step by step tutorial covers how to create simple macros in Excel using the macro recorder.

The Excel Macro Recorder Options

This step in the tutorial covers completing the Macro Recorder dialog box in Excel.

Recording the Macro Steps

This step in the tutorial covers recording the macro steps using the Macro Recorder in Excel.

Running the Macro in Excel

This step in the tutorial covers running the macro in Excel.

How to Create a Drop Down List in Excel

How to create a drop down list in Excel using data stored in a different workbook. A step by step example is included.

Opening the Data Validation Dialog Box in Excel

This step in the tutorial covers entering opening the data validation dialog box.

Using a Drop Down List for Data Validation in Excel

The data validation dialog box in Excel can be used to create a drop down list of acceptable data entries for a specific cell in a worksheet. This tutorial includes a step by step example of using the data validation dialog box to create a drop down list in Excel.

Adding Category and Data Labels to the Excel 2010 Pie Chart

This step in the tutorial covers adding category and data labels to the Excel 2010 Pie Chart.

Entering the Chart Data for the Excel 2010 Pie Chart

This step in the tutorial covers entering and selecting the data for the Excel 2010 Pie Chart.

Adding the Developer Tab in Excel (Macro Tutorial)

This step in the Excel macro tutorial covers how to add the Developers Tab. Page 2.

Opening the Excel Macro Recorder Dialog Box

This step in the tutorial covers opening the Macro Recorder dialog box in Excel.

Macro Errors and Editing a Macro in Excel

This step in the tutorial covers macro errors and editing a macro in Excel.

Entering the Tutorial Data

This step covers entering the tutorial data.

Creating a Named Range for the Excel Data Validation

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

Testing the Drop Down List in Excel

Creating a drop down list in Excel can be used to make data entry easier or it can be used to limit what data can be added to a worksheet. This tutorial includes a step by step example on creating a drop down list in Excel.

Options for Protecting the Drop Down List in Excel

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

Rotating the Pie Chart in Excel 2010

This step in the tutorial covers rotating the pie chart and exploding out a slice of the Excel 2010 Pie Chart.

How to Create a Pie Chart Excel 2010

This step by step tutorial covers how to create and format a pie chart in Excel 2010.

Adding Category and Data Labels to the Excel 2010 Pie Chart

This step in the tutorial covers adding category and data labels to the Excel 2010 Pie Chart.

Adding the Chart Title and Changing Fonts in an Excel 2010 Pie Chart

This step in the tutorial covers adding and formatting the chart title in an Excel 2010 Pie Chart.

Test Multiple Conditions with Google Spreadsheets' AND/OR Functions

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

Excel Online COUNTBLANK Function

The Excel Online COUNTBLANK function allows you to count up the number of blank or empty cells in a selected range. This tutorial includes a step by step example.

Change Column Colors / Show Percent Labels in Excel Column Chart

Change the column colors and show percent values for a single data series in an Excel column chart - 6 steps max. A step by step example is included.

Adding Percent Data Labels to an Excel Column Chart

This step in the tutorial covers adding percent data labels and deleting gridlines and axis titles in the column chart.

Starting the Column Chart

This step in the tutorial covers entering the tutorial data creating the basic column chart, and adding the chart title.

Adding a Background Color Gradient and Formatting the Text in an Excel Column Chart

This step in the tutorial covers using the formatting task pane in Excel to add a background color gradient, as well as using the font options to change the font type, size, and color of column chart's labels and headings.

Changing the Color of Columns in a Single Data Series in an Excel Column Chart

This step in the tutorial covers changing the color of each column, adding a legend to the column chart, and deleting the X-axis labels.

Moving Data to the Secondary Y Axis

This step in the tutorial covers moving the temperature data to a second vertical axis.

Moving Data to the Secondary Y Axis

This step in the tutorial completes the steps for moving the temperature data to a second vertical axis.

Formatting the Climate Graph

This step in the tutorial covers applying formatting options to the climate graph.

Moving the Legend and Changing the Background Area Colors

This step in the tutorial covers moving the legend and changing the background color of the Excel climate graph.

Adding the 3-D Bevel Effect and Resizing the Excel Climate Graph

This step in the tutorial covers adding the 3-D bevel effect and resizing the Excel climate graph.

Using the Formatting Task Pane with an Excel Column Chart

This step in the tutorial covers using the formatting task pane in Excel to move the data labels, widen the chart's columns, and add shadow effects to the column chart.

Make and Format a Column Chart in Excel 2010

6 steps to making and formatting a column chart/bar graph in Excel 2010. Includes adding a basic chart, changing colors and text, and moving the chart to a separate sheet.

Creating a Basic Column Chart/Bar Graph in Excel 2010

How to add a basic column chart/bar graph to an Excel worksheet

Formatting a Basic Column Chart in Excel

This step in the tutorial starts formatting the basic column chart/bar graph in Excel by removing gridlines from the plot area.

Modifying the Text in an Excel Column Chart/Bar Graph

This step in the tutorial covers adding a title to the chart and modifying the size and font used for all of the column chart text.

Changing Colors in an Excel Column Chart/Bar Graph

This step in the tutorial covers changing colors of various elements in the the Excel column chart.

Changing Chart Colors and Moving the Excel Column Chart

This step in the Excel column chart tutorial covers changing the color of the chart's data columns and moving the chart to a separate worksheet.

Entering and Selecting the Climate Graph Data

This step in the tutorial covers entering and selecting the climate graph data.

How to Combine Chart Types in Excel 2010

Combine two or more chart or graph types in Excel 2010 in order to display related information together. This tutorial combines a column chart and line graph using a second Y axis.

Creating a Basic Column Chart in Excel

This step in the tutorial covers adding a basic column chart to an Excel worksheet containing both precipitation and temperature data.

Switching Temperature Data to a Line Graph

This step in the tutorial covers switching the temperature data from columns to a line graph.

Using Formulas for Conditional Formatting in Excel

Use formulas to create custom conditional formatting rules in Excel. This tutorial includes a step by step example on using a formula to create a custom conditional formatting rule.

Adding New Conditional Formatting Rules in Excel

This step in the tutorial adds the formulas to the new conditional formatting rules.

Excel Conditional Formatting Rules of Precedence

The step in the tutorial covers the order of precedence Excel follows when two or more conditional formatting rules conflict.

Excel Conditional Formatting Formulas

This step in the tutorial enters formulas to check the accuracy of the conditional formatting rules.

Changing Cell Alignment of Data in Excel

This tutorial covers changing the alignment of data in a cell in Excel. This tutorial includes a step by step example of how to change the alignment of data in a cell in Excel.

Extract Text Characters with Excel's LEFT and LEFTB Function

Use Excel's LEFT or LEFTB functions to remove unwanted characters from imported data or to truncate existing text. A step by step example is included.

Convert Angles from Radians to Degrees in Excel

Use the DEGREES function in Excel to convert angles measured in radians to degrees. A step by step example is included.

Convert Angles from Degrees to Radians in Excel

Use the RADIANS function to convert angles measured in degrees into radians for use with Excel's trig functions. A step by step example is included.

Convert Angles From Degrees to Radians in Google Spreadsheets

Use the RADIANS function to quickly convert angles from degrees to radians in Google Spreadsheets for use with trig functions. A step by step example is included.

How to Subtract in Excel

How to subtract in Excel shows you how easy subtracting numbers can be. A step by step example of how to subtract two or more numbers is included.

Extract Days from Dates in Excel with the DAY Function

Use the DAY function to extract the day of the week from a specified date in Excel. A step by step example is included.

Excel MONTH Function

Use the MONTH function to extract the month from a specified date in Excel. Multiple examples and step by step instructions included.

Count Blank or Empty Cells in Excel

Use the COUNTBLANK function to count up blank or empty cells in one or more selected ranges of data in Excel. A step by step example is included

Statistical Functions - Excel Statistical Functions

Excel's Statistical Functions can be used to analysis the data in a spreadsheet. For example, they can be used to tell you the number of data entries you have or the average value of your data.

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

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

Extract Text with Excel's MID and MIDB Functions

Use Excel's MID or MIDB functions to remove unwanted characters from imported data or to truncate existing text. A step by step example is included.

Convert Text to Upper, Lower, or Proper Case in Excel

Use Excel's PROPER, UPPER, or LOWER functions to correct or convert text data to capital and small letters as needed. Step by step example included.

Multiply Numbers with Excel's PRODUCT Function

Use Excel's PRODUCT function to make it easy to multiply individual numbers, arrays, or ranges of values together. A step by step example is included.

Sum Columns or Rows of Numbers with Excel's SUM Function

Using shortcuts to Excel's SUM function makes it easy to quickly sum or add up columns, rows, or individual cells of data. Examples included.

Splitting the Screen in Excel

Use the Split Box feature in Excel to split the screen into multiple panes allowing you to see more than one copy of worksheet data. A step by step example is included.

Excel's Split Screen Option

Use Excel's split screen feature to see different areas of the same worksheet. A step by step example is included.

Parts of the Excel 2007 Screen

This labeled picture shows the main parts of the Micorosft Excel 2007 screen. Components include the Office button, ribbons, active cell, name box, column letter, row number, formula bar and sheet tabs.

Arrays and Array Formulas in Excel

Definition and use of the terms array, array formula, and table array as used in programs such as Excel and Google Spreadsheets.

Shortcut to Adding Borders in Excel

Adding, drawing, and formatting borders in Excel using shortcut keys and ribbon options. Step by step instructions are included.

Finding the Average Value with Excel's AVERAGE Function

Use Excel's AVERAGE function to find the average, or arithmetic mean for selected data. A step by step example is included.

Google Spreadsheets AVERAGE Function

Use Google Spreadsheets AVERAGE function to find the average, or arithmetic mean, of values for selected data. A step by step example is included.

Excel Date Function Tutorials

There are two basic groups of Date functions in Excel - functions that calculate the number of days, months, or years between two dates and functions that can be used to add the current date, time, or day of the week to a worksheet. The tutorials listed below cover both groups.

Generate Random Numbers with Excel's RAND Function

Use Excel's RAND function to generate random numbers between zero and one, one and ten or any other chosen range. A step by step example is included.

Excel YEARFRAC Function

Excel's YEARFRAC function finds what fraction of a year is represented by the period of time between two dates in decimal form, such as 0.65 years

Round Numbers Down in Excel with the ROUNDDOWN Function

Use the ROUNDDOWN function in Excel to round values down a specific number of decimal places or digits. A step by step example is included.

Round Numbers Up in Excel with the ROUNDUP Function

Use the ROUNDUP function in Excel to round values up a specific number of decimal places or digits. A step by step example is included.

Functions to Covert Case

The functions in this section can be used to change the case of text - upper, lower, and proper - in a worksheet. Each tutorial includes a step by step example.

Remove Non-Printable Characters from Excel Worksheets

These tutorials use one or more text functions to remove non-printable characters from data in an Excel worksheet. Step by step examples are included with each tutorial.

How to Subtract in Google Spreadsheets

How to subtract two or more numbers in Google Spreadsheets using a formula. A step by step example is included.

Merge Cells in Excel and Google Spreadsheets

How to merge cells in Excel and Google Spreadsheets. Also covered: Excel's Merge & Center and Center Across Selection options. Instructions included.

Find the Tangent of an Angle in Excel

Use Excel's TAN function to find the tangent of an angle measured in degrees or radians. A step by step example is included.

How to Find and Use Excel's Free Flowchart Templates

How to find, download and edit the free Excel flowchart templates available from Microsoft.

Excel SIN Function: Find the Sine of an Angle

Use Excel's SIN function to find the sine of an angle measured in degrees or radians. A step by step example is included.

Excel COS Function: Find the Cosine of an Angle

Use Excel's COS function to find the cosine of an angle measured in degrees or radians. A step by step example is included.

Excel Glossary of Terms

Here you will find common terms and definitions used in Excel and other spreadsheet programs such as Google Docs Spreadsheets and OpenOffice Calc.

Spreadsheet Definitions and Terms - Letter C

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

Excel Clipboard: Copy Multiple Items Multiple Times

What the Office Clipboard is and how to use it to copy and paste data between Excel worksheets, workbooks, or other programs. Examples included.

Excel Formatting Options

Excel's formatting options include conditional formatting, number formatting, and text and cell formatting Here you will find step by step tutorials, to help you format your worksheets easily and effectively.

Excel 2003 Formatting Tutorials

Excel 2003 Formatting Tutorials. Spreadsheets.

Add Headers and Footers to Excel Worksheets

How to add custom headers and footers - such as page numbers, dates, or file names - to the top and/or bottom of worksheets in Excel.

7 DOs and DON'Ts of Entering Data in Excel

Entering data DOs and DON'Ts covers the dangers of blank rows and columns, and why locking formulas, sorting, saving, and cell references are good in Excel.

Don't Leave Blank Rows or Columns in Related Data in Excel

Avoiding blank rows and columns is just one of many DOs and DON'Ts of entering data in Excel covered in this tutorial.

Do Save Your Work Frequently in Excel - and Back it Up

Saving frequently is just one of many DOs and DON'Ts of entering data in Excel covered in this tutorial.

Don't Use Numbers as Headings in Excel

Not using numbers for headings and labels and not entering units into cells along with data are some of the DOs and DON'Ts of entering data in Excel covered in this tutorial.

Do Use Cell References and Named Ranges in Excel Formulas

The value of using cell references and named ranges in formulas is just one of many DOs and DON'Ts of entering data in Excel covered in this tutorial.

Don't Leave Cells Containing Formulas Unprotected in Excel

Locking and protecting cells containing formulas is just one of many DOs and DON'Ts of entering data in Excel covered in this tutorial.

Do Sort Your Data in Excel

Sorting your data is just one of many DOs and DON'Ts of entering data in Excel covered in this tutorial.

DOs and DON'Ts of Entering Data in Excel

Entering data DOs and DON'Ts covers the dangers of blank rows and columns, and why locking formulas, sorting, saving, and cell references are good in Excel.