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.

How to Create a Table That Makes Choices in Excel 2007. Excel enables you to include data validation for a cell, limiting the type and content of any inputted data. In addition, you can limit data ...

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

Learn how to create a Timeline in Excel using a Column Chart, SmartArt, or an Excel Template. Timelines are essential for planning and communicating time-based data.

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.

Learn how to use Excel pivot tables to QA bulk sheets, plus some tips and shortcuts to enhance your pivot table skills.

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

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