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
Смотрите видео Pivot Table For Data Analysis Part 1 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Akerele Oluwasogo (Mr Excel) 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 442 раз и оно понравилось 17 людям.