Create a Report for Every Department

In today's epiosde of Call for Help, I discuss an amazing feature of pivot tables in Excel.

Say that you have built a perfect pivot table of data by product and date. You add a customer field to page area of the pivot table.

Normally, you would choose the first customer from the page field dropdown, then print. Choose the next customer from the page field dropdown, then print. Continue forever.

Using the tip shown in today's episode, you can have Excel replicate the report in seconds, once for every customer in the page field dropdown. The Show Pages feature is probably one of the best in Excel.

Read more here.