This weeks lecture, I’m a little confused about Pivot Tables. Since the lecture was only a few minutes long, I searched Wikipedia and found a lot of great information to help better understand. http://en.wikipedia.org/wiki/Pivot_table 
I found that a pivot table is a data summarization tool used for spreadsheets like Microsoft Excel. They are used to automatically sort, count, and total the data stored in one table to create a second table (pivot table) which will display the summarized data.
They usually consist of a row, column, and data fields which allow several kinds of aggregations like sum, average, etc.
Pivot Tables benefit in the business world because unlike a typical data entry where the data is stored only in columns and rows, a pivot table can help summarize the flat data, giving it depth, and highlighting the desired information. Pivot tables are better if you have a lot of information that needs to be summarized and they are now considered an important part of a spreadsheet application.
I found that a pivot table is a data summarization tool used for spreadsheets like Microsoft Excel. They are used to automatically sort, count, and total the data stored in one table to create a second table (pivot table) which will display the summarized data.
They usually consist of a row, column, and data fields which allow several kinds of aggregations like sum, average, etc.
Pivot Tables benefit in the business world because unlike a typical data entry where the data is stored only in columns and rows, a pivot table can help summarize the flat data, giving it depth, and highlighting the desired information. Pivot tables are better if you have a lot of information that needs to be summarized and they are now considered an important part of a spreadsheet application.
**(photo) Trainsignal Training a free computer training site.
http://www.trainsignaltraining.com/wpnew/wp-content/uploads/2008/01/Kasia_Pivot/1.jpg
http://www.trainsignaltraining.com/wpnew/wp-content/uploads/2008/01/Kasia_Pivot/1.jpg
No comments:
Post a Comment