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.

Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them ...

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.

If you want to create a dashboard in Microsoft Excel, this post will help you. A dashboard is a type of graphical representation that depicts the key performance indicators for a particular topic ...

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