Friday, September 21, 2012

Too much data? You group together using automatic outlining and show

Puget Sound can not keep pets enough dog chews on the shelves for all Corgies that they sell (or rodents for the pet Pythons). And they can keep pace with the sales data, which they from their booming business to generate. To better understand their source of income, they have to show it on a basis of month-to-month, and shop-to-shop.

Excel Auto outline Feature offers to do a simple way for Puget Sound pets.  It allows them the group to restrict or expand-the types of data that show they out-.

So that you can learn with the feature for the Automatic outline , we have a sample workbook (fictional), created the data for pet supplies on a per month basis and pro shop presents.


SAMPLE WORKING SOLUTION

1. The pet shop supplier can go, on the data tab, select the button Group , and then click auto outline .

2. Now you will see may refer to: parentheses in the spreadsheet. By clicking on the plus or minus icons can expand and reduce their sales data to display more easily learn.

 

3. If they restore the spreadsheet file to its original state, so they want to see once again all sales for her exploding business, they simply back to the data , tab click on " Ungroup " and select clear outline.

 

The owner of which Kibbles exploding can now easily identify company, how much of their stores are generating from month to month and get a better feel for the most popular purchases. Pythons and corn snakes seem enormous popular downtown Seattle who would have thought have?


View the original article here

No comments:

Post a Comment