# Spreadsheets: Most Popular Articles

These articles are the most popular over the last month.

How to use Excel's VLOOKUP Function

How to use VLOOKUP in Excel to retrieve specific data from a database or table of data. A step by step example is included.

How to use VLOOKUP in Excel to retrieve specific data from a database or table of data. A step by step example is included.

How to Quickly Add Columns or Rows of Numbers...

The Excel SUM function makes it easy to quickly sum or add up columns, rows, or individual cells of data in a worksheet.

The Excel SUM function makes it easy to quickly sum or add up columns, rows, or individual cells of data in a worksheet.

How to Subtract in Excel

How to subtract in Excel shows you how easy subtracting numbers in Excel can be. The tutorial includes a step by step example of how to subtract two numbers in Excel.

How to subtract in Excel shows you how easy subtracting numbers in Excel can be. The tutorial includes a step by step example of how to subtract two numbers in Excel.

Excel Beginner? Start Here

How to Use Excel is a series of free Excel tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, how to use Excel formulas and functions, adding and removing columns and rows, how to create charts, and how to use Excel's format options including autoformat.

How to Use Excel is a series of free Excel tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, how to use Excel formulas and functions, adding and removing columns and rows, how to create charts, and how to use Excel's format options including autoformat.

A Beginner's Guide to Excel Formulas

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

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

How to Divide in Excel

How to divide in Excel shows you how easy it is to dividing numbers in Excel can be. The tutorial includes a step by step example of how to divide two numbers in Excel.

How to divide in Excel shows you how easy it is to dividing numbers in Excel can be. The tutorial includes a step by step example of how to divide two numbers in Excel.

Using Excel's IF Function

The IF function allows for decision making in Excel. This tutorial includes a step by step example of using the IF function in Excel.

The IF function allows for decision making in Excel. This tutorial includes a step by step example of using the IF function in Excel.

How to Multiply in Excel

How to multiply in Excel shows you how to easily multiply numbers in Excel using a formula. The tutorial includes a step by step example of how to multiply two numbers in Excel.

How to multiply in Excel shows you how to easily multiply numbers in Excel using a formula. The tutorial includes a step by step example of how to multiply two numbers in Excel.

Create/Format a Line Graph in 5 Steps in Excel

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

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

Easy as Pie Charts in Excel

Use a pie chart in Excel to show the percentage each slice of the pie represents of the total chart value. This tutorial includes a step by step example.

Use a pie chart in Excel to show the percentage each slice of the pie represents of the total chart value. This tutorial includes a step by step example.

Learn a Basic Excel Formula with These Easy Tips

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

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

How to Use "TODAY" Functions to Add the Current...

The TODAY function can be used to add today's date to a spreadsheet. This tutorial includes a step by step example of using Excel's TODAY function.

The TODAY function can be used to add today's date to a spreadsheet. This tutorial includes a step by step example of using Excel's TODAY function.

How to Combine (Nest) the OR and IF Functions...

This tutorial covers how to use the OR function in Excel. A step by step example is included.

This tutorial covers how to use the OR function in Excel. A step by step example is included.

Understanding Excel's RANDBETWEEN Function

Rather than getting any random number the RANDBETWEEN function lets you specify a range between two numbers it is to select from.

Rather than getting any random number the RANDBETWEEN function lets you specify a range between two numbers it is to select from.

How to Sort and Filter Data in Microsoft 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.

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.

What is Microsoft Excel and When Would I Use it?

What is Microsoft Excel? It is an electronic spreadsheet program used for storing, organizing and manipulating data. Excel uses formulas to perform mathematical calculations ranging from the simple to the very complex. The program can also be used for graphing data.

What is Microsoft Excel? It is an electronic spreadsheet program used for storing, organizing and manipulating data. Excel uses formulas to perform mathematical calculations ranging from the simple to the very complex. The program can also be used for graphing data.

An Easy Way to See All Formulas in Excel

Show formulas allows you to quickly show all the formulas in your Excel Spreadsheet. Doing so does not change your spreadsheet, just the way it is displayed. Show formulas allows you to quickly and easily check your spreadsheet for errors in your formulas.

Show formulas allows you to quickly show all the formulas in your Excel Spreadsheet. Doing so does not change your spreadsheet, just the way it is displayed. Show formulas allows you to quickly and easily check your spreadsheet for errors in your formulas.

Using Date Functions in Excel: A Quick How-To

There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This tutorial covers the most common date functions used in Excel.

There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This tutorial covers the most common date functions used in Excel.

How to Use Excel to Count Days Between Two Dates

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

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

Using "Nested" and "IF" Functions in Excel: A...

Note: These instructions will work for all versions of Excel from Excel 95 to Excel 2010. Related Tutorial:

Note: These instructions will work for all versions of Excel from Excel 95 to Excel 2010. Related Tutorial:

Make a Column Chart in Excel

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

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

How Does the CONCATENATE Function in Excel Work?

The CONCATENATE function is used to join two or more words or text strings together. This tutorial includes a step by step example of using Excel's CONCATENATE function.

The CONCATENATE function is used to join two or more words or text strings together. This tutorial includes a step by step example of using Excel's CONCATENATE function.

How to Create a Named Range in Excel

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

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

Freezing Panes in Excel Keeps Information From...

Freeze panes in Excel keeps the headings at the top and down the side of the sheet from disappearing when you scroll away from the top left corner of the sheet. This tutorial includes step by step examples.

Freeze panes in Excel keeps the headings at the top and down the side of the sheet from disappearing when you scroll away from the top left corner of the sheet. This tutorial includes step by step examples.

How to Find the Weighted Average in Excel

This tutorial covers finding the weighted average for data using Excel's SUMPRODUCT function. A step by step example is included with the tutorial.

This tutorial covers finding the weighted average for data using Excel's SUMPRODUCT function. A step by step example is included with the tutorial.

How to Use Excel to Add, Subtract, Divide, and...

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.

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.

Worksheet

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

Cell Reference

Definition of the term. Spreadsheets.

Definition of the term. Spreadsheets.

Which Function Do You Use to Find the Square...

This article covers finding the square root of numbers in Excel. The article includes a step by step example of finding square roots in Excel.

This article covers finding the square root of numbers in Excel. The article includes a step by step example of finding square roots in Excel.

How to Generate Random Numbers with Excel's...

Generate random numbers in Excel using the RAND function. This tutorial includes a step by step example.

Generate random numbers in Excel using the RAND function. This tutorial includes a step by step example.

Take Advantage of a Free Flowchart Template for...

This article walks through how to download and use the free flowchart template available from Microsoft.

This article walks through how to download and use the free flowchart template available from Microsoft.

A Quick Guide to Using "IF" Functions in Excel

This series of articles and tutorials the basics of using IF functions to perform calculations in Excel.

This series of articles and tutorials the basics of using IF functions to perform calculations in Excel.

How to Use Excel's ROUND Function

The ROUND function is used to reduce a number to a specific number of decimal places. This tutorial includes a step by step example of using Excel's ROUND function.

The ROUND function is used to reduce a number to a specific number of decimal places. This tutorial includes a step by step example of using Excel's ROUND function.

How to Save Time With Excel's Fill Down Command

This Excel tip covers using the Fill Down command in Excel using a keyboard shortcut.

This Excel tip covers using the Fill Down command in Excel using a keyboard shortcut.

Absolute Cell References

Definition of the term Absolute Cell Reference as used in Excel and Google Spreadsheets.

Definition of the term Absolute Cell Reference as used in Excel and Google Spreadsheets.

A Simple Guide to Data Entry Forms in Excel

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

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

Understanding Excel's Goal Seek Function

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

How Excel's Nested IF Functions Work

Related Tutorial: - Excel Nested IF Function Step by Step Tutorial What the IF function does The IF function

Related Tutorial: - Excel Nested IF Function Step by Step Tutorial What the IF function does The IF function

Ribbon

Definition of the term. Spreadsheets.

Definition of the term. Spreadsheets.

Here's What a 'Spreadsheet' Really Is

Definition of the term spreadsheet.

Definition of the term spreadsheet.

Function

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

Which Excel Function Calculates the Number of...

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

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

How to Use the IF Function in Excel

Excel's IF function can be used to leave cells blank when certain conditions are met. This tutorial includes a step by step example of how to leave blank cells in a worksheet using the IF function.

Excel's IF function can be used to leave cells blank when certain conditions are met. This tutorial includes a step by step example of how to leave blank cells in a worksheet using the IF function.

How to Round Numbers Up in Excel

This tutorial contains a step by step example of how to use the ROUNDUP function in Excel. Links to more examples of using the function are included.

This tutorial contains a step by step example of how to use the ROUNDUP function in Excel. Links to more examples of using the function are included.

7 DOs and DON'Ts of Data Entry 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.

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.

Cell

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: In

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: In

How to Add the Date in Excel With Just a...

This Excel shortcut keys tutorial shows you how to add the current date to a worksheet using a keyboard key combination.

This Excel shortcut keys tutorial shows you how to add the current date to a worksheet using a keyboard key combination.

Row

: Rows run horizontally in an Excel worksheet . Each row is identified by a number in the row header

: Rows run horizontally in an Excel worksheet . Each row is identified by a number in the row header

A Quick Guide to Using AVERAGE Functions in Excel

Excel's AVERAGE function can be used to find the average value, or arithmetic mean, of values in a selected range of cells.

Excel's AVERAGE function can be used to find the average value, or arithmetic mean, of values in a selected range of cells.

How to Sort Data by Cell Color in Excel

This tutorial uses a step by step example to show you how to sort data by cell color in Excel.

This tutorial uses a step by step example to show you how to sort data by cell color in Excel.

Google Spreadsheet's 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.

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.

Range

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

Column

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Columns

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Columns

Excel VLOOKUP Step by Step Tutorial

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.

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.

Active Cell

Definition of the term Active Cell as it is used in spreadsheet programs such as Excel and Google Spreadsheets.

Definition of the term Active Cell as it is used in spreadsheet programs such as Excel and Google Spreadsheets.

Using Excel's Go To Command

The Go To feature in Excel can be used to navigate to different cells in a spreadsheet. This article includes an example of how to use the Go To feature to move to different cells.

The Go To feature in Excel can be used to navigate to different cells in a spreadsheet. This article includes an example of how to use the Go To feature to move to different cells.

A Step by Step Guide to Setting Up an Excel...

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

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

Excel Can Subtract Dates With These Commands

There are a number of functions in Excel that can be used to subtract dates. They can be used to subtract days, months, or years. The following tutorials include examples of subtracting two dates in Excel using the different date functions.

There are a number of functions in Excel that can be used to subtract dates. They can be used to subtract days, months, or years. The following tutorials include examples of subtracting two dates in Excel using the different date functions.

How Excel's IF Function Can Automatically Enter...

Words or text statements can be used with Excel's IF function. This tutorial includes a step by step example of how to use the IF function to enter text into a worksheet.

Words or text statements can be used with Excel's IF function. This tutorial includes a step by step example of how to use the IF function to enter text into a worksheet.

How to Perform Basic Calculations in Excel...

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

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

Formula Bar

: The formula bar in Excel is located above the work area of the spreadsheet . The formula bar displays

: The formula bar in Excel is located above the work area of the spreadsheet . The formula bar displays

Insert a New Worksheet in Excel Using Shortcut...

This Excel tip covers how to insert a new worksheet into Excel using a keyboard shortcut.

This Excel tip covers how to insert a new worksheet into Excel using a keyboard shortcut.

Understanding Excel's COUNT Function

Excel's COUNT function can be used to count up the number of cells containing numbers in a selected range. This tutorial includes a step by step example of using the COUNT function in Excel

Excel's COUNT function can be used to count up the number of cells containing numbers in a selected range. This tutorial includes a step by step example of using the COUNT function in Excel

10 Simple Steps to Using Excel's 'DEGREES'...

The DEGREES function in Excel converts angles measured in radians to degrees. This tutorial includes a step by step example of converting radians to degrees

The DEGREES function in Excel converts angles measured in radians to degrees. This tutorial includes a step by step example of converting radians to degrees

Workbook

Definition of the term workbook as it is used in Excel and Google Spreadsheets.

Definition of the term workbook as it is used in Excel and Google Spreadsheets.

Everything You Need to Know About the TRANSPOSE...

The TRANSPOSE function is used to transfer data located in a row into a column or data located in a column into a row. This tutorial includes a step by step example of using Excel's TRANSPOSE function

The TRANSPOSE function is used to transfer data located in a row into a column or data located in a column into a row. This tutorial includes a step by step example of using Excel's TRANSPOSE function

Relative Cell References

Definition of the term Relative Cell Reference as it is used in spreadsheet programs such as Excel and Google Spreadsheets.

Definition of the term Relative Cell Reference as it is used in spreadsheet programs such as Excel and Google Spreadsheets.

'Cell Address

Definition of the term cell address as it is used in spreadsheet programs.

Definition of the term cell address as it is used in spreadsheet programs.

2 Ways to Select Bar Graph Data 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.

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.

How to Use Excel's MAX Function

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

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

Troubleshooting Excel's TRIM Function

In certain circumstances the TRIM function cannot remove extra spaces from a text entry. This tutorial covers an alternative for removing extra spaces between data in Excel.

In certain circumstances the TRIM function cannot remove extra spaces from a text entry. This tutorial covers an alternative for removing extra spaces between data in Excel.

Select Non-Adjacent Cells in Excel With...

This Excel shortcut keys tutorial shows you how to select non-adjacent cells in Excel using the keyboard and mouse.

This Excel shortcut keys tutorial shows you how to select non-adjacent cells in Excel using the keyboard and mouse.

How to Select All Cells in an Excel Worksheet

This Excel tip covers how to select all cells in Excel using a keyboard shortcut.

This Excel tip covers how to select all cells in Excel using a keyboard shortcut.

How to Find Duplicates in Excel With Conditiona...

This tutorial shows you how find duplicate data - formulas, numbers, dates, data records - in Excel using conditional formatting. The tutorial includes a step by step example of using conditional formatting to find duplicates in Excel.

This tutorial shows you how find duplicate data - formulas, numbers, dates, data records - in Excel using conditional formatting. The tutorial includes a step by step example of using conditional formatting to find duplicates in Excel.

How to Use Excel's 'REPLACE' Function to...

The REPLACE function is used to replace unwanted characters with good data. The tutorial includes a step by step example.

The REPLACE function is used to replace unwanted characters with good data. The tutorial includes a step by step example.

How to Use the MIN Function in Excel

The MIN function is used to find the smallest or minimum value in a given list of numbers. This tutorial includes a step by step example on using the MIN function in Excel.

The MIN function is used to find the smallest or minimum value in a given list of numbers. This tutorial includes a step by step example on using the MIN function in Excel.

Dissecting the Excel HLOOKUP Function

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

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

Identifying Excel Screen Elements

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

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

What is a Mixed Cell Reference in Excel?

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

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

Select an Entire Row in Excel Using Shortcut Keys

This Excel shortcut keys tutorial shows you how to quickly select an entire row in a worksheet using just the keyboard.

This Excel shortcut keys tutorial shows you how to quickly select an entire row in a worksheet using just the keyboard.

Dialog Box

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: A

How to Use Headers and Footers in Excel

Headers and footers are used to add the same information on every page of the spreadsheet without actually typing the information on each page. Headers and footers often contain company information as well as the date, time and filename of the spreadsheet.

Headers and footers are used to add the same information on every page of the spreadsheet without actually typing the information on each page. Headers and footers often contain company information as well as the date, time and filename of the spreadsheet.

Understanding Excel Function Syntax

Spreadsheet definition - Syntax. This glossary entry defines

Spreadsheet definition - Syntax. This glossary entry defines

Free Excel Templates From Microsoft

This article covers templates in Excel: how to make your own as well as free templates that you can download.

This article covers templates in Excel: how to make your own as well as free templates that you can download.

Understanding Excel's Conditional Formatting

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.

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.

Free Excel Lessons for Beginners and Intermedia...

Each tutorial in this free series covers either an introductory or intermediate level topic in Microsoft Excel. The tutorials include step by step examples related to each topic.

Each tutorial in this free series covers either an introductory or intermediate level topic in Microsoft Excel. The tutorials include step by step examples related to each topic.

10 Spreadsheet Terms Every Excel User Should Know

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

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

Using a Dynamic Range in Excel Formulas

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

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

Highlight Cells

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: To

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: To

Bothered by Excel AutoComplete? Here's How to...

This quick tip covers how to turn AutoComplete on or off in Excel.

This quick tip covers how to turn AutoComplete on or off in Excel.

Data

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Data

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Data

Change Column Widths in Excel

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

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

Argument

Definition of the term arguments as used in Excel and Google Spreadsheets

Definition of the term arguments as used in Excel and Google Spreadsheets

Name Box

: The Name Box is located next to the formula bar above the worksheet area. The Name Box displays the

: The Name Box is located next to the formula bar above the worksheet area. The Name Box displays the

Here's How to Fix '#REF!' Errors in Excel

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

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

A Free Excel Biweekly Time Sheet Template from...

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

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

An Easy Guide to Using Negative Number...

This tutorial covers how to format negative numbers in Excel to display in a different color. A step by step example is included in the tutorial.

This tutorial covers how to format negative numbers in Excel to display in a different color. A step by step example is included in the tutorial.

Instantly Add the Current Time to Excel...

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

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

How to Use the AutoMAX Function in Excel

Excel's AutoMAX feature is a shortcut to using the MAX function to find the largest number in a range of data. A step by step example is included.

Excel's AutoMAX feature is a shortcut to using the MAX function to find the largest number in a range of data. A step by step example is included.

Choosing the Right Graph - Excel Graphs and...

This article covers the main types of Excel graphs and their uses. The graphs covered include the bar graph, line graph, scatter plot graph, and the pie chart.

This article covers the main types of Excel graphs and their uses. The graphs covered include the bar graph, line graph, scatter plot graph, and the pie chart.

How to Fix '#####' Error Messages in Excel

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

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

Label

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: The

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: The

How to Use Excel's "NETWORKDAYS" Function to...

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

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

Creating Custom Conditional Formatting Rules in...

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.

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.

A Quick Guide to Formatting Spreadsheets with...

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

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

How Conditional Formatting Works in Excel

Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells based on the data entered into the cell(s). This tutorial includes an example of using conditional formatting to find above and below average values.

Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells based on the data entered into the cell(s). This tutorial includes an example of using conditional formatting to find above and below average values.

Google Spreadsheets AVERAGE Function

The AVERAGE function in Google Spreadsheets can be used to find the average value, or arithmetic mean, of values in a selected range of cells. A step by step example is included with this tutorial.

The AVERAGE function in Google Spreadsheets can be used to find the average value, or arithmetic mean, of values in a selected range of cells. A step by step example is included with this tutorial.

How to Select All the Cells in a Data Table...

This Excel tip covers how to select all cells in an Excel data table using a keyboard shortcut.

This Excel tip covers how to select all cells in an Excel data table using a keyboard shortcut.

Learn to Use Excel's UPPER Function

The UPPER function is used to convert text to all upper case or capital letters. An example of using this function is included in the tutorial.

The UPPER function is used to convert text to all upper case or capital letters. An example of using this function is included in the tutorial.

How to Count the Days Between Dates in Excel...

When entering dates into a worksheet that will be used in calculations, it is a good idea to entering them using the DATE function to avoid problems that can arise if Excel reads the date as text.

When entering dates into a worksheet that will be used in calculations, it is a good idea to entering them using the DATE function to avoid problems that can arise if Excel reads the date as text.

How to Use Freeze Panes to Lock Columns and...

Lock Columns and Rows in Excel 2003 with Freeze Panes Related tutorial: Excel 2007 / 2010 Freeze Panes

Lock Columns and Rows in Excel 2003 with Freeze Panes Related tutorial: Excel 2007 / 2010 Freeze Panes

Fill Handle

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: The

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: The

How to Convert Angles from Degrees to Radians...

Use Excel's RADIANS function to convert an angle measured in degrees into radians so that it can be used with one of Excel's trig functions.

Use Excel's RADIANS function to convert an angle measured in degrees into radians so that it can be used with one of Excel's trig functions.

Value

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: The

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: The

Performing Calculations With Excel's IF Function

The IF function is one of Excel's most useful functions. What it does is test to see whether a certain condition is true or false. This tutorial covers using the IF function to perform calculations on spreadsheet data.

The IF function is one of Excel's most useful functions. What it does is test to see whether a certain condition is true or false. This tutorial covers using the IF function to perform calculations on spreadsheet data.

Here's What a 'Table Array' Is in Spreadsheet...

Table Array. Spreadsheets terms - definition of the term table array as used in spreadsheets such as Excel.

Table Array. Spreadsheets terms - definition of the term table array as used in spreadsheets such as Excel.

Macros

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: An

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: An

Tips and Tricks for Formulas in Microsoft Excel

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

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

Comparison Operator

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Comparison Operators

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Comparison Operators

Need a Timeline Template for Excel? This One's...

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.

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.

Chart

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Charts

class="no-js" itemscope itemtype="http://schema.org/Article" > itemprop="description" >Definition: Charts

Row Header

Definition of the term Row Header as used in Excel and Google Spreadsheets.

Definition of the term Row Header as used in Excel and Google Spreadsheets.

Excel SUM OFFSET Formula Tutorial

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

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

How to Make a Stock Market High, Low, and Close...

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.

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.

How to Use QUOTIENT Functions in Excel

The QUOTIENT function is used to divide numbers in Excel. This tutorial includes an example to walk you through using the QUOTIENT function.

The QUOTIENT function is used to divide numbers in Excel. This tutorial includes an example to walk you through using the QUOTIENT function.

A Quick Guide to Using Date Functions and...

The functions listed below can be used to add the current date to an Excel spreadsheet. Each tutorial includes step by step examples of working with dates in Excel 2007.

The functions listed below can be used to add the current date to an Excel spreadsheet. Each tutorial includes step by step examples of working with dates in Excel 2007.

Understanding Excel's Number Format's Options

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

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

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.

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.

A Quick Guide to Using Shotrcut Keys to Undo...

This Excel shortcut key tutorial shows you how to "undo" changes made to an Excel worksheet. Related

This Excel shortcut key tutorial shows you how to "undo" changes made to an Excel worksheet. Related

How to Use the COUNT Function in Google...

The COUNT function in Google Spreadsheets is used to count up the cells in a selected range that contain numbers - the function ignores blank cells, text and other types of data. This tutorial includes a step by step example .

The COUNT function in Google Spreadsheets is used to count up the cells in a selected range that contain numbers - the function ignores blank cells, text and other types of data. This tutorial includes a step by step example .

Formatting Cells in Excel Can Make Information...

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

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

10 Steps to Change Excel Text to Proper Case

The PROPER function is used to convert text data to proper case letters (combination upper and lower case). A step by step example is included with this tutorial.

The PROPER function is used to convert text data to proper case letters (combination upper and lower case). A step by step example is included with this tutorial.

How to Use the COUNTIF Function in a Google...

The COUNTIF function in a Google Spreadsheets is used to count up the number of cells in a selected range that meet criteria that you specify. An example of using the COUNTIF function is included in this tutorial.

The COUNTIF function in a Google Spreadsheets is used to count up the number of cells in a selected range that meet criteria that you specify. An example of using the COUNTIF function is included in this tutorial.

Learn How to Add Borders Instantly in Excel...

This Excel shortcut keys tutorial shows you how to quickly add a border to selected cells in Excel using a keyboard shortcut.

This Excel shortcut keys tutorial shows you how to quickly add a border to selected cells in Excel using a keyboard shortcut.