Creating Running Totals in Regular Ranges To create a running total in an Excel range that isn't formatted as an Excel table, you need to use a combination of absolute and relative references.

Pivot tables are one of several Excel tools for extracting meaning out of large groups of numeric data. They can be applied whenever raw data in a spreadsheet or database has to be summarized.

In this tutorial, we will explain how to make a Step Chart in Microsoft Excel with or without dates. Charts are a graphical representation of data.

Show users how to create a quick table of contents in Excel using the power of hyperlinks.

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

How to create an automated list of worksheet names in Excel -- and add a table of contents.

It is particularly beneficial to use data-entry forms when your data range or table has many columns. A standard data-entry form in Excel looks similar to the screenshot below. (To follow along, ...

A treemap chart provides a hierarchical view of data and makes it easy to spot patterns. Learn how to create a treemap chart in Excel.