UrbanPro
true

Learn BI Reporting from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Pivot Tables In Excel

ITech Analytic Solutions
03/01/2018 0 0

i. Pivot Tables:

A pivot table is essentially a dynamic summary report generated from a database. The database can reside in a worksheet (in the form of a table) or in an external data file. A pivot table can help transform endless rows and columns of numbers into a meaningful presentation of the data. Pivot tables are very powerful tool for summarized analysis of the data.

Pivot tables are available under Insert tab » PivotTable dropdown » PivotTable.

ii. Pivot Table Example:

Now, let us see Pivot table with the help of example. Suppose you have huge data of voters and you want to see the summarized data of voter Information per party, then you can use the Pivot table for it. Choose Insert tab » Pivot Table to insert pivot table. MS Excel selects the data of the table. You can select the pivot table location as existing sheet or new sheet.

This will generate the Pivot table pane as shown below. You have various options available in the Pivot table pane. You can select fields for the generated pivot table.

  • Column labels: A field that has a column orientation in the pivot table. Each item in the field occupies a column.

  • Report Filter: You can set the filter for the report as year, then data gets filtered as per the year.

  • Row labels: A field that has a row orientation in the pivot table. Each item in the field occupies a row.

  • Values area: The cells in a pivot table that contain the summary data. Excel offers several ways to summarize the data (sum, average, count, and so on).

After giving input fields to the pivot table, it generates the pivot table with the data.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

Important points to keep in mind while trade
? Do not over trade – Do not put all your money in share market. ? Do Not put all your money in single share or single sector – Put or divide your money in multiple shares or sectors. This...

Variations Of Random Forest In R
One of the important steps in using analytics to generate insights is model fitting. Typical projects involve a lot of data cleaning so that high accuracy is achieved on application of the model. Competitions...

What is Logistic Regression Model ?
Logistic regression is a form of regression which is used when the dependent is a dichotomy (yes or no) and the independents of any type (either continuous or binary). Logistic regression can be used...

Variations Of Random Forest In R
One of the important steps in using analytics to generate insights is model fitting. Typical projects involve a lot of data cleaning so that high accuracy is achieved on application of the model. Competitions...

Learning excel complex function by using simple steps
Step 1: Understand and practice the individual excel functions thoroughly Step 2: Split the problem statement into N number of small pieces. Step 3: Use individual functions to solve the small piece...

Looking for BI Reporting Training?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
X

Looking for BI Reporting Classes?

The best tutors for BI Reporting Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn BI Reporting with the Best Tutors

The best Tutors for BI Reporting Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more