Excel things to know Flashcards
What is a Pivot Table
Trademark name by Microsoft in Excel – sum up and reorganized selected columns and rows of data in a spreadsheet/database table. Do not change the info in the table, just pivot, so change the view of the data.
- Process and highlight large amounts of data
- what Pivot Table can do :
* ID sum
* ID average
* Range and outliers
- Common use:
* Sum complex report
* ID max and min
* Generate a list of unique values
* Show total percentages of a whole
* Calculate sum and Averages
In Tables in Excel, what is Convert to range mean
It means turning a table into a range, it removes the filter button ( where all the little filers are ), and making it a table. The titles in the table will no longer have the drop-down selection to filter.
