How to Build A Database in Microsoft Office Excel 2007. Small databases of a few rows, to... How to Create a Drop-Down Box With Color How to Create a Drop-Down Box With Color. One way to ...

Here, we show you how to create a pivot table in Excel to take advantage of one of the application’s most powerful tools. Before we start, just what exactly are pivot tables good for?

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter ...