Tuesday, 7 May 2013

Use of Sub Total in Microsoft Excel 2007/10

Use of Sub Total in Microsoft Excel 2007/10:
Let’s consider an example to understand sub-total in Excel. Suppose we have different product in our shop /business, and we maintain record of each sell. With the help of sub-total we can calculate, analyze product wise sell and money earned by each product category sell.
Suppose we have different products on Electronics store like Tv, Washing Machine, Microwave, Refrigerator, LCD, LED. Total we sell these 6 products with different specification (like different size, capacity).
First, we just need to type product name and price.(Preparing list)
Second, we need to sort list by Product name(Item wise sorting)
Third, use of sub-total in Data menu to analyze income from different products.

Data after sub total

No comments:

Post a comment