Introduction to Pivot Tables | Microsoft Excel | Analytics
#PivotTables #MSExcel #DataAnalysis
Imagine you're walking past a colleague's work area while they are pondering over a report made with an Excel Pivot Table. In the event that you are new to how Pivot Tables are created, they can appear to be complex, confusing and intimidating.
In reality, Pivot Tables are perhaps the most straightforward and fundamental tools to use in Excel. With only a couple of snap n-drag steps, you can make a report with the help of a Pivot Table that would require DAYS to make using the conventional methods.
Probably the best element of Pivot Tables is their capacity to refresh the outcomes when the basic information changes. Editing information can be introduced with a snap.
Let's learn the MAGIC of Pivot Tables in this video.
Questions to answer about our products:
The total sales for each product.
The total sales for all products.
The ranking order from most sales to least sales by product.
We need to answer the following questions about our customers:
Questions to answer about our customer.
The percentage of sales for each customer.
Answering these questions will be as easy as playing a game of computer Solitaire but in a tiny fraction of the time.
Lessons:
Introduction - Why Use Pivot Tables?
1. Creating a Pivot Table
2. Making the table dynamic
3. Filtering of the report
4. Rearranging report fields
5. Creating a multi-level report
6. Customizing the Pivot Table Format
7. Collapsing and Expanding hierarchies
8. Removing a field from the field list
9. updating the default headings
10. Sorting the report results
11. Automatic column resize based on content
12. Creating additional aggregations
13. Updating the report
14. Creating our products report
15. Adding slicers to expedite filtering
16. Alternate way to create Pivot table
Other Related Videos:
• Introduction to Pivot Tables|| Excel Training
• Pivot Tables -Slicer|Excel Training
• Pivot Tables-Value Field Settings-1
• Pivot Tables-Value Filter||Excel Training
• Frequency Distribution Table Using Pivot T...
• Pivot Tables-Integrating Value Filters and...
• Grouping in Pivot Tables||Excel Training
You can follow me on all the following social media handles:
Facebook: / rwithrd
Linkedin: / rajeshdorbala
Instagram: rajeshdorbalatutorials
Twitter: @dorbalarajesh
Download the workbook here:
https://docs.google.com/spreadsheets/...