Excel Pivot Tables: Everything You Need to Know in Under 20 Minutes
Welcome to Hey Ivan, a channel where you can ask a tech guy tech questions. In this video, I share everything you need to know about how to use Excel PivotTables in under 20 minutes.
CHAPTERS
00:00:00 Introduction
00:00:24 Chapters
00:00:32 Three Reasons People Use Excel
00:00:54 Structuring Data for a PivotTable
00:02:58 Create a PivotTable
00:04:48 Anatomy of a PivotTable
00:07:20 Why is it called “PivotTable?”
00:07:57 Calculations
00:09:54 Compare Rows & Columns
00:11:24 More Than One Field
00:12:41 Remove a Field
00:13:08 Drill into Data
00:14:04 Filtering
00:15:55 Refreshing PivotTable Data
GOT A QUESTION?
Do you have a tech question? Just shout “Hey Ivan” in the comments.
If you like this video, subscribe — it’s free!
If you know of anyone who could benefit by watching this video, tell them about it and send them a link.
Thanks for stopping by!
#excel #pivottable
~Ivan
Music by Mr. Chase - Rainbow Road - https://thmatc.co/?l=E0C8AACC
Music by VirgoZilla Beatz - Feelin’ Good - https://thmatc.co/?l=480153D6
Channel Art by Len Peralta - http://www.lenperalta.com