Excel: Create an Ad-Hoc Reporting Tool

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I have an operations manager who is famous for asking many ad hoc questions. One day, he will want to know who bought XYZ product. The next day, he will want to know all sales to Air Canada. How can Excel help me quickly answer his questions?

Strategy: You can build a pivot table report with many fields in the Report Filter area. You can then use the information here to answer just about any ad hoc query your manager can dream up. For example, your operations manager can easily figure out how many ABC products were shipped to the East region on a given date.

Additional Details: Take the Date field to the row labels area, group it up to Years, Quarters, and Months, then drag those fields to the Report Filter area.

  1. Ad hoc reporting tool.

For more resources for Microsoft Excel