Pivot Table’s are extremely useful when it comes to putting together data, and then manipulating that data in order to build predictions, or simply view a report at the end of the month. It’s very rare to see schools use software other than Microsoft, when it comes to Windows PC’s. It’s the standard program / software used in schools to help students learn, create reports and even gain degrees. This “rotation” or pivoting of the summary table gives the concept its name.Įverybody who has ever touched a computer knows what Microsoft Office is, and more importantly, what Excel is. The user sets up and changes the summary’s structure by dragging and dropping fields graphically. Pivot tables are also useful for quickly creating unweighted cross tabulations. It displays the results in a second table (called a “pivot table”) showing the summarized data. Among other functions, a pivot-table can automatically sort, count total or give the average of the data stored in one table or spreadsheet. In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software.
0 Comments
Leave a Reply. |