Скачать или смотреть Pivot Table 101: Beginner’s Guide To Mastering Pivot Tables In Excel

We cover how to create, sort, filter and customise pivot tables. A pivot table is a tool that allows you to quickly summarise and analyse large amounts of data by easily sorting, filtering and grouping data. Let’s say you have a list of sales data – product, quantities sold and the total revenue. A pivot table can help you summarise this data to answer questions like “Which product sold the most?” or “What’s the total revenue by region?” in just a couple of steps.

Access the templates featured in The Excel Hub's video tutorials here:
https://theexcelhub.myshopify.com/

Subscribe for weekly Excel tutorials, techniques and examples:
   / @theexcelhub  

Please share this video with others that may find it useful:
   • Pivot Table 101: Beginner’s Guide To Maste...  

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram:   / theexcelhub  

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:
[email protected]

Overview: (0:00)
Create A Pivot Table: (0:45)
Sort Data: (1:47)
Add Slicer: (2:07)
Calculated Fields: (2:37)
Format Numbers: (3:47)