In case of pivot tables, we can summarize the data to our liking. Using Standard tables we can filter the data, and take a quick look at our data.įrom the image, we can see that how we may summarise or reorganise the data without deleting any information from the data set. We can use standard tables, but they have a very limited functions as compared to a Pivot tables. Instead of separating rows or columns one by one, we can use pivot tables. It can help see Data patterns and decision making. Pivot Tables are helpful for large amounts of data. Pivot tables have different features and they can be used accordingly. It can be used to manipulate data for our own convenience. Pivot tables are one of the most useful features of Excel. In Excel, we create a pivot table for a range of cells. It collects individual terms of an extensive table. Pivot tables are used for handling, arranging or summarizing large amounts of data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |