ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is the main purpose of Pivot Table in Microsoft Excel?

user-image
تم إضافة السؤال من قبل JAHIR HUSSAIN , HR Welfare officer , Iss world of service
تاريخ النشر: 2014/03/11
Donna Mae Gadioni
من قبل Donna Mae Gadioni , Accountant/Administrative Assistant , Lifelong Polyclinic

Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your data, the way you wanted it to be.

Mohamed Esam Mohamed Kamel
من قبل Mohamed Esam Mohamed Kamel , Financial Analyst , Egyptian Water & Wastewater Regulatory Agency (EWRA)

Use a PivotTable report to summarize, analyze, explore, and present summary data. Use a PivotChart report to visualize that summary data in a PivotTable report, and to easily see comparisons, patterns, and trends. Both a PivotTable report and a PivotChart report enable you to make informed decisions about critical data in your enterprise.

 

A PivotTable report is an interactive way to quickly summarize large amounts of data. Use a PivotTable report to analyze numerical data in detail and to answer unanticipated questions about your data. A PivotTable report is especially designed for:

 

  • Querying large amounts of data in many user-friendly ways.
  • Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.
  • Expanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you.
  • Moving rows to columns or columns to rows (or "pivoting") to see different summaries of the source data. 
  • Filtering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data to enable you to focus on the information that you want.
  • Presenting concise, attractive, and annotated online or printed reports.

 

You often use a PivotTable report when you want to analyze related totals, especially when you have a long list of figures to sum and you want to compare several facts about each figure.

Mohammed Kalache
من قبل Mohammed Kalache , Asistant Category Manager , Starbucks Middle East & Africa ( Alshaya )

It's To Change Row Data To Something You Need To Know 

Moin Mohamed
من قبل Moin Mohamed , Sr. Purchasing Analyst, , Al-Khafji Joint Operation - KJO

To have a summary of a huge details, very effective tool.

مستخدم محذوف‎
من قبل مستخدم محذوف‎

Represents a single data point by symbol in a chart.

Sameer Khan
من قبل Sameer Khan , Financial Accountant , Centro Salama by Rotana

They can be used to summarize, analyze, explore and present your data in a tabular form.

Sulayman Abbas Ladan
من قبل Sulayman Abbas Ladan , Deputy Bursar , Ahmadu Bello University

Pivot table in excel allows data summary.

It allows creation of reports

Provide means for listing of values into unique rows or columns.

It could serve as source of linkage with other windows out of excel.

It eases data transfer

Cornelia Buenviaje
من قبل Cornelia Buenviaje , Procurement / Inventory Controller / Logistics , Al Shirawi Enterprises

It helps to summarize the data that you required for reporting.

Ilham Mohammed
من قبل Ilham Mohammed , Senior Accountant , gulf center for foodstuff

mostly it will reduce your work  whie doing any report.

can customize in a easy way. and Etc..

 

 

 

FITAH MOHAMED
من قبل FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

Linking data and analyzing , and report them to easily extract

Zulfiqar Ali
من قبل Zulfiqar Ali , Data Analyst , Tech Consulting

dipicting aggrigate result from data

المزيد من الأسئلة المماثلة