Use an Excel Pivot Table to Find the Frequency of Invoice Amounts
When your manager asks you, "How many small invoices do we process?" Don't just shrug your shoulders. Instead, follow the steps from this video lesson and produce as Excel Pivot Table Report to get the answer.
In this tutorial, I show you how to do this using both Excel 2010/2007 and Excel 2003. The steps are basically the same in all versions. The key concept is "Grouping Fields." In this case, you create a "frequency distribution by grouping the Invoice Amounts,
Watch the video - you will be amazed at how easy it is to create this response!
I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my videos and to sample the many resources that I offer you.
Danny Rocks
The Company Rocks