Organizing data in Excel properly is a complex process. Pivot Table is a solution for this complex work. We can organize data according to our requirements. This figure shows a portion of the dataset we have used to create the pivot tables in this chapter.Ī Pivot table can organize, summarize, and analyze data easily and present the out based on requirements.įor clarification, we have a dataset for sales information of a super shop in our hand. Status determines whether the customer is new or existing.Store is the branch name of the super shop.Bill represents the amount of transaction.Weekday is for the corresponding day of the date.Each row represents sales information with date, weekday, customer name, bill amount, store name, etc. This database contains a good amount of information. The following questions the bank’s management may want to know:īut in its current form, the data doesn’t reveal much to you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |