What is Pivot table and why we use it?

define pivot table and why we use it in Microsoft excel?explain it briefly.

24 Answers
Top Voted Recent Answer
1-20 of  24
24 Answers
Top Voted Recent Answer
  • A pivot table in Excel is a tool used to quickly summarise and analyze large seta of data in a simple format. It allows us to group information, perform calculations, rearrange data as needed without using complex formulas. We mainly used it to convert raw data into a clear and meaningful summary for better understanding and decision making.
    0
  • Pivot table helps tirn raw data into meaningful summaries and insights in just a few clicks
    0
  • Pivot Table is a tool built into Excel that allows you to summarize large quantities of data quickly and easily. Given an input table with tens, hundreds, or even thousands of rows, Pivot Tables allow you to extract answers to a series of basic questions about your data with minimal effort.
    0
  • Pivot Table is a tool that summarise rows and column data in table format. it quickly do calculations (like average sum count avg percentage) to make reports in very less time.. it is especially used in case of large amount of data where normal sum average formula takes longer time for calculation
    0
  • pivot table use to dump data to quickly show to summary.
    0
  • Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.
    0
  • Pivot table is a way to initialise any value using a graph...
    0
  • Pivot Tables are one of the most powerful and useful tools in Excel. They will save you a lot of time by allowing you to quickly summarize large amounts of data into a meaningful report.
    0
  • Pivot table is table with rows and coloum it is used for many purpose like making report card salarymaking
    0
  • Pivot table which is used to access the data very easily and in understand very simply
    0
  • It is a program tool that allows you to reorganize and summrize select columns and rows in a spread sheet to obtain a desired report
    0
  • A pivot table is a table of statistics that summarize the data of a more extensive table such as from a database, spreadsheet, or business intelligence program. This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way.
    0
  • A pivot table is a table of statistics that summarize the data of a more extensive table and it's summarize the data,average etcA pivot table is a data summarization tool that is used in the context of data processing. Pivot tables are used to summarize, sort, reorganize, group, count, total or average data stored in a database. It allows its users to transform columns into rows and rows into columns. It allows grouping by any data field.
    0
  • PIVOT TABLE IS A VERY EASY TO USE FOR INSTANTLY KNOW ABOUT DATA. USE THIS FOR DATA ANALYSIS.
    0
  • A pivot table is a table of statistics that summarize the data of a more extensive table and we use a pivot table to build a list of unique values. Because pivot tables summarize data, they can be used to find unique values in a field.
    0
  • A pivot table is a table of statistics that summarize the data of a more extensive table (such as from a database, spreadsheet, or business intelligence program). This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way
    0
  • A pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. A pivot table doesn't actually change the spreadsheet or database itself. In database lingo, to pivot is to turn the data to view it from different perspectives.
    0
  • A pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. A pivot table doesn't actually change the spreadsheet or database itself.
    0
  • Pivot table is a program tool that allow us to summarize and select the rows and columns of the data in a spreadsheet or a database table to obtain the report.
    0
  • pivot table helps us to summarize the rows and column of data into spreadsheet to obtain a desired report. Pivot tables summarize data, they can be used to find unique values in a field.
    0
loadAnswer
1-20 of  24
forum   Other Related Discussions
Ms Excel

Didn't get the answer.
Contact people of Talent-Ms Excel directly by clicking here