Pivot Table
Pivot Table helps you quickly summarize, analyze, and present large amounts of data. It provides the tools you need to organize fields by rows, columns, values, and filters, making your work more efficient and helping you accomplish tasks with ease. With Pivot Table, you can create a table from a selected data range, change value field summary methods such as Sum, Count, Average, Max, and Min, insert slicers, adjust layout and format, totals and filters, display, and data options, hide selected data, group or ungroup items, change the data source, clear content, move or delete the table, and use calculated fields, calculated items, solve order, and list formulas. Whether you're performing multi-dimensional statistics, drill-down analysis, or refreshing updated results, Pivot Table helps you stay productive and complete tasks efficiently across different work environments. Choose the documentation below that best matches your needs to learn more.