Pivot Table For Data Analysis Part 1
Excel Video: How To Use Pivot Table For Sales Data Analysis Part 1
Data analysis on a large set of data is quite often necessary and important.
It involves summarizing the data, obtaining the needed values and presenting the results.
Excel provides PivotTable to enable you to analyze and summarize thousands of data values easily and quickly so as to obtain the required results.
Consider the following table of sales data.
From this data, you might have to summarize total sales region wise, customer wise, or salesperson wise.
The easy way to handle these tasks is to create a PivotTable that you can dynamically modify to summarize the results the way you want.
Creating PivotTable
To create PivotTables, ensure the first row has headers.
Click the table.
Click the INSERT tab on the Ribbon.
Click PivotTable in the Tables group. The PivotTable dialog box appears.
Click New Worksheet to tell Excel where to keep the PivotTable.
Click OK.
PivotTable Areas
You can even change the Layout of your PivotTable instantly. You can use the PivotTable Areas to accomplish this.
In PivotTable areas, you can choose −
What fields to display as rows
What fields to display as columns
How to summarize your data
Filters for any of the fields
Is the video helpful?
Drop a comment and share
Join our Advanced Excel Data Analytics Masterclass on Saturday 12th and Sunday 13th of February, 2022
Call us on +2348062468296 to register
Watch video Pivot Table For Data Analysis Part 1 online without registration, duration hours minute second in high quality. This video was added by user Akerele Oluwasogo (Mr Excel) 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 442 once and liked it 17 people.