Pivot Tables, also known as summary tables, are tables that allow the user to observe all of their collected data in one place to analyze it. Upon entering the data, the user will then be allowed to analyze, find, or use any of the data they may need. A Pivot Table can be used for plenty of topics as well. Such as sales, how often something happens, keeping records of people, and more. For example, we have a short Pivot Table that discusses foods and their sales, after entering more data or leaving it as is, you should be able to use the analyzer tool inside excel and add a slicer.
