# Tag Archives | INDEX

## How To Create A Simple Sales Evaluation Dashboard In Excel

In this tutorial we’ll take a look at how to create a simple dashboard using a combo box, a chart, an INDEX/MATCH combination formula and a few simple formatting concepts to easily evaluate the sales for any individual salesperson.

## How To SUM A Range Of Values In An Array Using INDIRECT, ADDRESS, and MATCH Functions In Excel

In this tutorial we are going to explore a variation of the traditional INDEX/MATCH combination to extract and sum only a portion of a row or column within an array.

## How To Analyze Completed Projects Using A PivotTable In Excel

In this tutorial we’ll take a look at how to add a column with a formula outside of our PivotTable for project analysis that pulls results from a Table, then use Conditional Formatting to dress it up.

## You Need To Change How You Think When Using Formulas In Conditional Formatting!

I recently received a request to use Conditional Formatting when performing two different comparisons on two data ranges.  How I approached the task was WRONG! Read on to see how I finally got myself on the right track.

## How To Use INDEX and MATCH In A Table With INDIRECT In Excel

In this video we’ll look at the traditional data range lookup using the INDEX and MATCH functions, but add a twist to look up the values in a table, plus a bonus twist using the INDIRECT function.

## How To Create A Dynamic Chart In Excel

This video will take you through the steps of creating a chart that dynamically changes based on the selection you make from a Data Validation drop down list. We’ll use various functions including INDEX, MATCH, COLUMNS, and ROWS.