Thanks for this. Getting ready to recertify for G4E L2 and I never figured it out the first time. I watched another one of your videos as well. A little feedback: it would be great if you could zoom in more - I could see where you were moving, but it was hard to read text. :)
When i make a pivot table and make changes to the original worksheet from where the data was extracted..it does not automatically change in the pivot table as well. Is there a way to fix this?
I usually do not comment on Videos. But the way you guys have presented in such a calm and clear way, I felt I should comment in this video. Awesome tutorial. I felt like I am sitting in my high school class and this really good teacher patiently explaining the concept of a topic which I am learning for the first time.
Thank you for this tutorial, this really helps me. I have a question. I'm trying to found the function "show data as"(% of, %difference from, % of row, % of column, etc) on google sheets but I can't. Can you tell where is it? :)
I am only six minutes into this video and it is absolutely amazing! I am trying to learn how to utilise pivot tables and this is such a great way to learn. Thank you!
really like your videos, thank you! very informative and well presented. my only advice would be to buy a mic (if you don't have one) or somehow increase the volume of the videos and clean (the sound) a bit your voices. lastly, congrats on the 1k subscribers!
Thanks for watching our videos and giving us some feedback on the sound in our videos. We are investigating new mics and will be sounding cleaner in future videos ;)
Thanks for this. Getting ready to recertify for G4E L2 and I never figured it out the first time. I watched another one of your videos as well. A little feedback: it would be great if you could zoom in more - I could see where you were moving, but it was hard to read text. :)
How can I disable auto update of Pivot Table in Spreadsheet?
I only want manual update option for my pivot table. Is it possible in spreadsheet?
TIA
Is there more information you can give regarding why the option "COUNTA" is named thus?
When i make a pivot table and make changes to the original worksheet from where the data was extracted..it does not automatically change in the pivot table as well. Is there a way to fix this?
I usually do not comment on Videos. But the way you guys have presented in such a calm and clear way, I felt I should comment in this video. Awesome tutorial. I felt like I am sitting in my high school class and this really good teacher patiently explaining the concept of a topic which I am learning for the first time.
Is there a function in Google Sheets similar to the one in MS Excel that changes the Report Layout of a Pivot Table to a Compact view?
Thank you for this tutorial, this really helps me.
I have a question. I'm trying to found the function "show data as"(% of, %difference from, % of row, % of column, etc) on google sheets but I can't. Can you tell where is it?
:)
Another great tutorial! 100% use full
Thanks, glad you found our video helpful. Thanks for taking the time to comment - we appreciate it! ;0
from now on, i'll skip Google's default tutorial and jump right to your channel if i ever need to see a tutorial!!
Is there a way range of values for the row and collumn of the pivot table? The data I am using is continuous data.
I am only six minutes into this video and it is absolutely amazing! I am trying to learn how to utilise pivot tables and this is such a great way to learn. Thank you!
Sparkles! Love it, thanks ladies!
Got love that auto-correct! ;0
Great tutorial. My question is how do you add multiple sheets to your pivot table?
This was perfect! Very clear and really helped me understand filters and how they can be used effectively. Thank you!
Wow are those mini graphs showing HW and test score trends? Please say you did another video on that!
really like your videos, thank you! very informative and well presented. my only advice would be to buy a mic (if you don't have one) or somehow increase the volume of the videos and clean (the sound) a bit your voices. lastly, congrats on the 1k subscribers!
Thanks for watching our videos and giving us some feedback on the sound in our videos. We are investigating new mics and will be sounding cleaner in future videos ;)
Great Tutorial, thx so much!!!
Thanks, just made my life a whole lot easier!
Excellent demystification! This has improved my check register/budget spreadsheet greatly. Thank you!
Awesome! We're pleased to help demystify you! ;0
great tutorial, thanks!
Great vids ladies
Thanks