Using the Internet, conduct a thorough search for more information onBusiness Studies with pivot tables in Excel. Choose ONE bullet (explain and also include a use) from the following list:

 

  • Do approximate match lookups
  • Work with logical functions
  • Calculate statistics with summary IF functions
  • Create a PivotTable
  • Change a PivotTable layout
  • Format a PivotTable
  • Create a Pivot Chart
  • Apply a slicer to multiple PivotTables
  • Create a timeline slicer