Creating Pivot Tables in Excel QUICK AND EASY
Introduction
Hello everyone! In this post, I will show you how you can create a pivot table. Pivot tables in Excel are very important as you can easily summarize data in an interactive way.
It's quite easy to make one! All it takes is a couple of clicks on your mouse.
Video for the Post
If you want to watch the video that goes with this post, you can check it out here: https://www.youtube.com/shorts/uVhRx8AZfD8. It will only take less than a minute of your time 🙂.
The Steps
-
Go to where your data is and make sure it is formatted as a table:
-
Click on anywhere inside of the data and go to the "Insert" ribbon and click on "Pivot Table" in the top left corner.
-
This will open up a pop-up window:
You can select the range of the table. You can also just include the table name inside the range box. In my example, the table's name is called "YearlySales".
Click on "OK".
-
You will see a blank pivot table and on the right hand side, you will see a pane called "PivotTable Fields":
-
You can drag whatever columns you want into the different sections in the PivotTable Fields pane. You'll notice that as you drag in columns, your pivot table will automatically update!
Conclusion
... and that's it! Creating pivot tables is very simple and you can make them as complex as you want them to be.
I hope you learned something from this post and I hope you have a good day! Thank you for reading!