What are pivot tables What is the table format and how can i

What are pivot tables?

What is the table format and how can it save your time?

What data sources can Excel connect to and why is this important?

Solution

Pivot table is a excel work sheet which helps you to use the data in the excel sheet to compare the data among the fields against each other fields.

Pivot table format can save time by comparing the fields against each other fields instead of manually counting the number of cases common in two fields.

The data sources of excel can connect to is the neighbouring work sheet, other excel sheet, manual input of values, result to be returned in a work sheet from the calculation made in other sheets.