While Excel is an ideal software for creating and managing databases, it may not be easy to navigate when dealing with thousands of rows and columns. Here is where Power Pivot comes in ...

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.