1A PIVOT TABLENAME:INSTITUTIONCOURSE NUMBERCOURSE TITLE:INSTRUCTOR’S NAME:DUE DATE:2A PIVOT TABLEA pivot table is a unique and essential feature that allows one to extract important detailsfrom a large data set. Therefore it acts as a unique summary of a large piece of information.Thus, the pivot table was essential for extracting some important information related to hospitalpayment claims.Through the pivot tables, we had various pages, columns, rows, and data fields that maybe re-arranged to help in expanding, isolating, and summing data within a relatively shorterperiod. Therefore, through the pivot study, we focused on only the essential information and datafrom the table, which gave us relevant insights concerning the medical hospital claim.The importance of a PIVOT table.It helped in the filtering of data and information from the table. Therefore allowing … Purchase document to see full attachment