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.
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!
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?
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.
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.
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.
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?
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.
Glad I could help!
i love how it uses The Office's reference , so cute. Good work Jim Halpert !!!
What an excellent teaching and demonstration!!
Assisted a lot. Appreciated
I love that you are using The Office's Names
Clearly explained thanks. Very helpful
this great teaching thanks looking forward to more leaning in depth step by step.
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?
Awesome tutorial. Thanks!
Excellent. TY!
LOVE IT
I love that you are using The Office 🙂
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!
You're very welcome!
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?
Thanks for sharing.
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.
Thank you.
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.
How do you print a multi page excel sheet or document 3:55AM
Thanks
Do you mind giving us exercise files to follow along?
If you click on the description, it will show you the file he is using, and you can download it.
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.
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?
what is a pivot table and why would I use one?
You can quickly summarize large amounts of data.
@@TeachersTechHey Jamie can you teach us X lookup that is in Microsoft excel
I'm not sure what version you have but my Excel does not look the same :(
Interesting fact all employers are working in Dunder Mifflin
Why is Dwight paying $20 for each pen?! Dwight would know better than this.
LMAOOOOOOOO
😂😂😂😂
Nope
What a waste of time