When something goes wrong, everyone wants to go through the data and find out what happened. The Data Tools are: Sort, Filter, Group and Subtotal. A PivotTable combines all of the best Data Tools together. A PivotTable presents the data in a visual, interactive format. PivotTables summarize, sort, compare and filter the data. A PivotTable summarizes data and displays the results. It is a reporting tool that works very well. Here is how you start.
Here is a YouTube video you can watch if you wish.
Microsoft Excel 2013 Advanced: PivotTables
Thanks for stopping by.
eBeth
Elizabeth Nofs, the Computer Mama
Buy the books at Amazon: https://thecomputermama.us/books-page/
Please evaluate my Courses: Visit our school at UDEMY