Beginner’s Guide to Excel Pivot Tables (for Dummies)
Вставка
- Опубліковано 10 лип 2024
- Discover why pivot tables are the ultimate game-changer in Excel. From novice to advanced, this tool empowers you to not only analyze but also visualize your data with precision and finesse.
This is a beginner's guide to Microsoft Excel pivot tables (a 101 for dummies if you will), which will take you step by step through how to set up your first pivot table to extract data, insert slicers and create graphs.
Unleash the full potential of pivot tables as we explore how they effortlessly summarize, sort, and filter through large datasets-giving you the power to navigate your data with ease. With just a few clicks, you'll be crafting dynamic charts and graphs that showcase your expertise like a pro.
This is a step by step tutorial where you will learn how to create excel pivot tables for beginners that will take your Excel spreadsheets from data chaos to structured analysis and nice visualizations.
M Y C H A N N E L
If you like this video and is looking for more of similar content, subscribe my channel where we help each other excel in our work and personal life through learning tools and skills, being productive and simplifying our lives:
ua-cam.com/users/emelieli...
M E N T I O N E D I N T H I S V I D E O
www.excel-easy.com/data-analy...
T H I N G S I M E N T I O N O F T E N
Notion: www.notion.so/
TickTick: ticktick.com/
Skillshare: www.skillshare.com/en/
Getting Things Done: amzn.to/3ihwmst
C H A P T E R S
00:00 Why use Excel Pivot tables?
00:48 Crucial data prepping
01:22 Create the pivot table
01:42 Setting up your first pivot table
06:58 Formatting the Excel pivot table
07:37 Sorting, filtering and grouping data
09:29 Adding new data to the pivot table
10:41 Sliders, timeline and graphs
In the description box you can find a link to a data set that is similar to mine if you want to play around with Excel Pivot tables!
I never understood why or how to use pivot tables before but it all makes sense now. This will save me so much time. Thank you 😊
I'm happy to help! I actually used pivot tables today, they are so useful when you are working in Excel! :D
This is so informative but also easy to follow! Well done!
Thank you so much! 🤗
Excellent tutorial, thank you
I'm glad you liked it! Thanks for telling me!
How do I see the sheet of data it is pulling from? One of my clients had someone do a pt and it is pulling from a previous spreadsheet of data. They duplicated the spreadsheet so it is pulling from the previous year. How do I get it to pull from the current worksheet in this workbook?
It is the same principle as what I show starting at 09:29. On the "PivotTable Analyze" tab you can click on "Change Data Source" and there you can see where it is pulling the data from and also change the data source :)
Oh my goodness... I have avoided pivot tables for so long because I couldn't understand them at all. I'm so glad I decided to try again to learn and found your tutorial! This is a game changer for me. Thank you so much... you have magical teaching powers! 🪄
That makes me so happy to hear! I'm glad you liked the video, I strive to make all my videos super helpful and easy to follow :D