How to Create Excel Pivot Tables & Pivot Charts - Beginner's Guide

[@AnshikaSharma-ov8xs]

i love how it uses The Office's reference , so cute. Good work Jim Halpert !!!

[@colleenswain2703]

This was absolutely perfect. I've been using Pivot Tables for a while and I learned so much more. Also why I previously could not get the results I wanted. With this tutorial now I can make better sense of my data.

[@TeachersTech]

Glad I could help!

[@dominiqued.4114]

What an excellent teaching and demonstration!!

[@PawanAdhikari-kd5qk]

I love that you are using The Office's Names

[@BlacBoi-bd3bn]

Assisted a lot. Appreciated

[@joycewong1175]

Hi Teacher, at 9:15, while you press 'Total' and get the column of 'Sum of total', i cannot get the 'Sum of total', any idea which part when wrong?

[@lindakirby2540]

Clearly explained thanks. Very helpful

[@mergerysichembe3961]

this great teaching thanks looking forward to more leaning in depth step by step.

[@lateishachristian1773]

LOVE IT

[@JesiwiththeTea]

I love that you are using The Office 🙂

[@KwantumKitty]

Awesome tutorial. Thanks!

[@mackensonreginaldmichel399]

Thanks for your videos. I have a question: can I have all the features of Excel online with the paid version, without having to install it, just with my account?

[@fastrobreetus]

Excellent. TY!

[@AmySubblett]

This was very helpful and a great refresher. I had not created pivot tables for a long time. After watching this I feel like I have been missing out. Thank you!

[@TeachersTech]

You're very welcome!

[@arlenaf.3503]

Thanks for sharing.

[@marcw.5492]

Nicely done ! - Is there any reason the formatting changes when refreshing data in Pivot Tables ? really hard to fix - annoying. I notice that has been the case even in Query refreshing when there is new data. Formatting just doesnt hold - been doing that for many years.

[@TECHMAN92335]

How do you print a multi page excel sheet or document 3:55AM

[@Mandy12468]

I would like to know how to calculate the difference between 2 data sets. Example- I used multiple patient samples and tested for a specific analyte using 2 different methods. I want to have it show the difference between the 2 methods for each patient.

[@princealbertz]

Do you mind giving us exercise files to follow along?

[@daniyagullage5098]

If you click on the description, it will show you the file he is using, and you can download it.

[@temiladeadesina275]

Thank you.

[@jflartner117]

what is a pivot table and why would I use one?

[@TeachersTech]

You can quickly summarize large amounts of data.

[@MrBusiness-vc7bs]

​@@TeachersTechHey Jamie can you teach us X lookup that is in Microsoft excel

[@ramamoorthyshanmugam1730]

Thanks

[@unicornpearlz]

I've been trying to learn pivot tables for about 5 years, so I know these questions are because I don't get something. 1) My Rows can't be dragged into columns - is there somewhere special I'm supposed to click to make that happen? 2. the names of the pivot table fields do not show up on my pivot table... but when I click on the drop down in Rows, it all shows up there in name and then numerical order. What am I doing wrong?

[@jadabalber3598]

I'm not sure what version you have but my Excel does not look the same :(

[@julius43461]

I used sheets and Excel for years and I ended up creating extremely complex but easy to use sheets without ever touching pivot tables. Now I tried using them to see what's the deal with them, and I couldn't even figure out how to my sales data in descending order. I feel so dumb, but is there really any use to this if you are an advanced user? I imagine pivot tables could be more useful for someone who would rather avoid creating everything from the ground up.

[@alberthovhannisyan6555]

Interesting fact all employers are working in Dunder Mifflin

[@markg6854]

Why is Dwight paying $20 for each pen?! Dwight would know better than this.

[@potterylady44]

LMAOOOOOOOO

[@MoniMeka]

😂😂😂😂

[@pablo-xr8rb]

Nope

[@Angelalove22]

What a waste of time