# Spreadsheets: Most Popular Articles

These articles are the most popular over the last month.

Excel Formulas Step by Step Tutorial

This tutorial is intended for those just getting started with Excel. This tutorial covers basic information about formulas and walks you through creating a simple example in Excel.

This tutorial is intended for those just getting started with Excel. This tutorial covers basic information about formulas and walks you through creating a simple example in Excel.

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

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

The Excel SUM function makes it easy to quickly sum 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.

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.

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's VLOOKUP Function

Excel’s VLOOKUP function is used to find specific information that has been stored in a table of data in a spreadsheet. This tutorial includes a step by step example of how to use VLOOKUP in Excel.

Excel’s VLOOKUP function is used to find specific information that has been stored in a table of data in a spreadsheet. This tutorial includes a step by step example of how to use VLOOKUP in Excel.

How to Multiply in Excel

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

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

Trouble Dividing in Excel? Follow This Easy Guide

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.

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 Unhide Columns in Excel

This tutorial shows you how, with a click of the mouse, you can easily unhide columns in Excel spreadsheets - including Column A.

This tutorial shows you how, with a click of the mouse, you can easily unhide columns in Excel spreadsheets - including Column A.

Excel IF Function Step by Step Tutorial

The IF function allows for decision making in Excel. Specific criteria are setup that result in one of two actions occurring, depending on whether or not the criteria are met. This tutorial includes a step by step example of using the IF function in Excel

The IF function allows for decision making in Excel. Specific criteria are setup that result in one of two actions occurring, depending on whether or not the criteria are met. This tutorial includes a step by step example of using the IF function in Excel

How to Easily See 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.

Excel Nested OR and IF Function Tutorial

This article shows you how to use the OR function in Excel. The article includes a step by step example on using the OR function.

This article shows you how to use the OR function in Excel. The article includes a step by step example on using the OR function.

Excel Freeze Panes Step by Step Tutorial

Excel Freeze Panes Overview Related tutorial: Freeze Panes in Excel 2003 . When working with very large

Excel Freeze Panes Overview Related tutorial: Freeze Panes in Excel 2003 . When working with very large

A Simple Guide to Using Pie Charts and Graphs...

This tutorial covers creating a pie chart (pie graph) in Microsoft Excel. The tutorial includes a step by step example of creating a pie chart in Excel.

This tutorial covers creating a pie chart (pie graph) in Microsoft Excel. The tutorial includes a step by step example of creating a pie chart in Excel.

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:

Count Days Between Two Dates in Excel

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

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.

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.

Nested IF Functions in Excel Quick Tutorial

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

Excel Pivot Tables Step by Step 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.

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's Vlookup Function

This tutorial is a text only version of how to use Excel's VLOOKUP function. It is intended for those familiar with Excel functions.

This tutorial is a text only version of how to use Excel's VLOOKUP function. It is intended for those familiar with Excel functions.

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.

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.

Excel 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 Does Excel's IF Function Work?

The IF function tests to see if a certain condition in a spreadsheet is true or false. This tutorial includes an example of using the IF function in Excel.

The IF function tests to see if a certain condition in a spreadsheet is true or false. This tutorial includes an example of using the IF function in Excel.

Unhide Rows in Excel

This tutorial shows you how, with a click of the mouse, you can easily unhide rows in Excel spreadsheets.

This tutorial shows you how, with a click of the mouse, you can easily unhide rows in Excel spreadsheets.

A Beginner's Guide to Microsoft Excel and the...

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.

A Quick Guide to Making Column Charts in Excel

This tutorial covers creating a column chart in Microsoft Excel. The tutorial includes a step by step example of creating a column chart in Excel.

This tutorial covers creating a column chart in Microsoft Excel. The tutorial includes a step by step example of creating a column chart in Excel.

Excel ROUND Function

The ROUND function, one of Excel's math functions, 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, one of Excel's math functions, 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 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.

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

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.

Using Goal Seek in Excel

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.

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

Leaving Blank Cells When 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.

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

How to Use Excel Chart Wizard

This Excel Chart Tutorial covers creating charts in Microsoft Excel. This tutorial covers all the steps necessary for creating a chart using the Chart Wizard. The tutorial begins by discussing the best practices for entering the chart data and then walks you through each of the four screens of the Chart Wizard.

This Excel Chart Tutorial covers creating charts in Microsoft Excel. This tutorial covers all the steps necessary for creating a chart using the Chart Wizard. The tutorial begins by discussing the best practices for entering the chart data and then walks you through each of the four screens of the Chart Wizard.

Excel Math

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

: A worksheet is a single page or sheet in a spreadsheet program such as Excel. By default, in Excel

: A worksheet is a single page or sheet in a spreadsheet program such as Excel. By default, in Excel

A How-To Guide On Data Entry in Microsoft Excel

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

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

Formula

: Formulas in spreadsheet programs such as Excel are used to perform calculations. Formulas can range

: Formulas in spreadsheet programs such as Excel are used to perform calculations. Formulas can range

Subtract Dates in Excel

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.

Absolute Cell Reference

: In Excel and other spreadsheets, an absolute cell reference identifies the location a cell or group

: In Excel and other spreadsheets, an absolute cell reference identifies the location a cell or group

Excel Conditional Formatting Formulas

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.

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.

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

What are Excel Headers and Footers?

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.

Spreadsheet

: A spreadsheet application is a computer program such as Excel, OpenOffice Calc, or Google Docs Spreadsheets.

: A spreadsheet application is a computer program such as Excel, OpenOffice Calc, or Google Docs 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.

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.

Random Numbers in Excel

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.

Ribbon

: The Ribbon is the strip of buttons and icons located above the work area beginning with Excel 2007.

: The Ribbon is the strip of buttons and icons located above the work area beginning with Excel 2007.

Excel REPLACE Function

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.

Cell Reference

: Related Tutorial: Using Cell References in Excel Formulas In Excel, a cell reference identifies the

: Related Tutorial: Using Cell References in Excel Formulas In Excel, a cell reference identifies the

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

Excel ROUNDUP Function

The ROUNDUP function, one of Excel's math functions, is used to round a number upwards towards the next highest number. This tutorial includes a step by step example of using Excel's ROUNDUP function.

The ROUNDUP function, one of Excel's math functions, is used to round a number upwards towards the next highest number. This tutorial includes a step by step example of using Excel's ROUNDUP function.

Count 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

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

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.

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.

Free Excel Biweekly Time Sheet Template

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.

Excel's Go To Feature

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.

Using the IF Function to Enter Text

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.

Creating a Drop Down List in Excel Part 2

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

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

Function

: A function is a preset formula in Excel. Like formulas, functions begin with the equal sign ( = ) followed

: A function is a preset formula in Excel. Like formulas, functions begin with the equal sign ( = ) followed

Excel Conditional Formatting Date Formula

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

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.

Find Above or Below Average Numbers 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.

Excel Pivot Table Tutorials

These tutorials cover how to create a pivot table in Excel. Each tutorial includes a step by step example of how to create a pivot table in Excel.

These tutorials cover how to create a pivot table in Excel. Each tutorial includes a step by step example of how to create a pivot table in Excel.

Free Excel Templates

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.

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.

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.

Add the Current Date in Excel

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.

Excel Wrap Text

This tutorial covers how to use Excel's wrap text feature to type on multiple lines in a single worksheet cell. An example is included

This tutorial covers how to use Excel's wrap text feature to type on multiple lines in a single worksheet cell. An example is included

Excel 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

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

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.

Excel Conditional Formatting Data

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

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

Google Spreadsheet IF Function

The IF function in Google Spreadsheet tests to see if a certain condition in a spreadsheet is true or false. This tutorial includes a step by step example.

The IF function in Google Spreadsheet tests to see if a certain condition in a spreadsheet is true or false. This tutorial includes a step by step example.

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 to 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 to change column widths in Excel.

Cell

: In any spreadsheet program such as Excel, each rectangular box in a row worksheet is referred to as

: In any spreadsheet program such as Excel, each rectangular box in a row worksheet is referred to as

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

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.

When the TRIM Function Doesn't Work

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.

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

Hide Columns in Excel

This tutorial shows you how, with a click of the mouse, you can easily hide columns in Excel.

This tutorial shows you how, with a click of the mouse, you can easily hide columns in Excel.

Unhide Columns in Excel

This Excel shortcut keys tutorial shows you how to quickly unhide columns in Excel using just the keyboard.

This Excel shortcut keys tutorial shows you how to quickly unhide columns in Excel using just the keyboard.

Drag Select

: A method used to select a range of cells. To do so, click on a cell with the left mouse button and,

: A method used to select a range of cells. To do so, click on a cell with the left mouse button and,

Free Microsoft Excel Tutorial Series

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.

Insert Rows into Excel Worksheets

This tutorial shows you how to easily insert rows into an Excel worksheet

This tutorial shows you how to easily insert rows into an Excel worksheet

Excel Formulas Tutorials

These tutorials work for all versions of Excel. Spreadsheet formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. These tutorials walk you through creating formulas in Excel.

These tutorials work for all versions of Excel. Spreadsheet formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. These tutorials walk you through creating formulas in Excel.

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

Print Gridlines and Headings in Excel

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

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

Range

: A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells

: A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells

Dialog Box

: A dialog box in Excel is a form that allows users to input information and make choices about different

: A dialog box in Excel is a form that allows users to input information and make choices about different

Excel Sort Options

These tutorials cover using Excel's sort feature. Excel's sort options allow you to sort by date, perform a custom sort on multiple columns, or sort by font or cell color. The tutorials include step by step examples of using the sort feature in Excel spreadsheets.

These tutorials cover using Excel's sort feature. Excel's sort options allow you to sort by date, perform a custom sort on multiple columns, or sort by font or cell color. The tutorials include step by step examples of using the sort feature in Excel spreadsheets.

Insert a New Worksheet in Excel

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.

Google Spreadsheet COUNTIF Function

The COUNTIF function in a Google Drive 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 Drive 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.

Excel Negative Number Format

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.

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

Select All Cells in Excel

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.

Relative Cell Reference

: In Excel and other spreadsheets, a relative cell reference identifies the location of a cell or group

: In Excel and other spreadsheets, a relative cell reference identifies the location of a cell or group

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

Insert Columns to Excel Worksheets

This tutorial shows you how, with a click of the mouse, you can easily insert additional columns to Excel worksheets.

This tutorial shows you how, with a click of the mouse, you can easily insert additional columns to Excel worksheets.

What are Spreadsheet Number Formats?

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.

Dissecting the Excel HLOOKUP Function

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

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

Syntax

: The syntax of an Excel function refers to the layout and order of the function and its arguments .

: The syntax of an Excel function refers to the layout and order of the function and its arguments .

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.

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.

IF Function Comparison Operators

The logic test section of an Excel IF function is always a comparison between two values. Listed here are the different comparison operators that can be used in Excel functions.

The logic test section of an Excel IF function is always a comparison between two values. Listed here are the different comparison operators that can be used in Excel functions.

Mixed Cell Reference

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.

Data Definition

: Data is information that is stored in any spreadsheet program such as Excel. Data is stored in cells

: Data is information that is stored in any spreadsheet program such as Excel. Data is stored in cells

Workbook

: A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheets

: A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheets

Excel DEGREES Function

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

Excel INDIRECT Function Tutorial

Excel's INDIRECT function can be used to refer to the location of specific data in an Excel worksheet. The function is usually combined with other functions to create more complex formulas such as SUM, COUNT, and MATCH. This tutorial includes a step by step example.

Excel's INDIRECT function can be used to refer to the location of specific data in an Excel worksheet. The function is usually combined with other functions to create more complex formulas such as SUM, COUNT, and MATCH. This tutorial includes a step by step example.

Excel Formatting Options

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.

Active Cell

: In a spreadsheet program such as Excel, the active cell is identified by a black border or outline

: In a spreadsheet program such as Excel, the active cell is identified by a black border or outline

Performing Calculations with the 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.

Delete Rows in Excel Worksheets

This article shows you how, with a click of the mouse, you can easily delete rows from Excel worksheets.

This article shows you how, with a click of the mouse, you can easily delete rows from Excel worksheets.

Hide Rows in Excel

This article shows you how, with a click of the mouse, you can easily hide rows in Excel spreadsheets.

This article shows you how, with a click of the mouse, you can easily hide rows in Excel spreadsheets.

Column

: Columns are a fundamental part of any spreadsheet program such as Excel. Columns run vertically in

: Columns are a fundamental part of any spreadsheet program such as Excel. Columns run vertically in

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.

Want to Unhide Rows in Excel? Here's How

This Excel tip covers how to unhide rows in Excel using a keyboard shortcut.

This Excel tip covers how to unhide rows in Excel using a keyboard shortcut.