• Share

# Articles Index

### Combine Chart Types in Excel

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

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

### Convert Measurements 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.

### Excel Column Chart Step by Step Tutorial

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

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

### Excel Left Lookup Formula Using VLOOKUP

This tutorial combines Excel's VLOOKUP and CHOOSE functions to create a "Left Lookup" formula, which can search for data from from right to left in a table of data. A step by step example is included with this tutorial.

### 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 COLUMN Function Tutorial

The Excel COLUMN function uses include finding the column number for the cell where the function is located in the worksheet or finding the number for a column of a given cell reference. A step by step example is included with this tutorial.

### Tutorial: Lookup Formula with Multiple Criteria in Excel

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

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

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

### Calculate Your Current Age with the Excel 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.

The COUNTA function in Google Spreadsheets can be used to total the number of cells in a range that contain data. A step by step example is included in this tutorial.

### Excel DSUM Function Tutorial

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

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

### Excel Split Options

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. This tutorial includes a step by step example of how to use the split box feature in Excel.

The MODE function in Google Spreadsheets can be used to find the middle or median value in a list of numbers. A step by step example is included in 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.

### 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 OFFSET Function Tutorial

Excel's OFFSET 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.

### Find the Start or End Date of a Project in Excel

Use Excel's WORKDAY function to find the start or end date of a project given a set number of work days. This tutorial includes a step by step example of how to use Excel's WORKDAY function.

### Excel SUMIF Function Step by Step Tutorial

The SUMIF function is used to sum up the number of cells in a selected range that meet certain criteria. This tutorial contains a step by step example of using the SUMIF function in Excel.