Many thanks for this one! One experience to share is that if you're processing a sheet given by a third party the numeric column cells may not set properly to the numeric type, which will cause the generated pivot table's value cells to be blank, to fix this convert the cell format to numeric type beforehand.
High quality video... thanks for taking your time in explaining in detail how to use pivot tables and create charts from them. By the way, have you ever tried creating stock type charts? I cannot figure out how do they work... :(
Thank you so much for the clear instructions, much better than the Libre Office official site! Would you mind answering 2 questions for me? 1. For some odd reason when I right click ( like you do at the 8:40 mark) anywhere on the table, I cannot get pivot table properties to come up. It could be an issue with my install but I thought it odd that I can't do that. Any suggestions? 2. Do you plan on doing more content showing the differences between Libre Calc and Excel for financial professionals? Thank you and you have earned a like and subscribe!
@@lxvideostuff7200 The details on how to name a range of cells is not within the scope of this tutorial. I suggest that you seek out a tutorial on that other topic. Simply stated: Knowing how to set a name to a range of cells is a pre-requisite to appreciating the topic that is presented by Melissa in this tutorial.
Many thanks for this one!
One experience to share is that if you're processing a sheet given by a third party the numeric column cells may not set properly to the numeric type, which will cause the generated pivot table's value cells to be blank, to fix this convert the cell format to numeric type beforehand.
This was helpful and I LEARNED SOMETHING! Thank you!
Great explanation. Thank you.
Lovely teaching and demonstration style. Content was great.
High quality video... thanks for taking your time in explaining in detail how to use pivot tables and create charts from them. By the way, have you ever tried creating stock type charts? I cannot figure out how do they work... :(
Great video. Thanks for the information.
Wow, That's really Neat!
Excellent!! Is it possible to also make a Pivot Chart?
Thank you so much for the clear instructions, much better than the Libre Office official site! Would you mind answering 2 questions for me?
1. For some odd reason when I right click ( like you do at the 8:40 mark) anywhere on the table, I cannot get pivot table properties to come up. It could be an issue with my install but I thought it odd that I can't do that. Any suggestions?
2. Do you plan on doing more content showing the differences between Libre Calc and Excel for financial professionals?
Thank you and you have earned a like and subscribe!
It baffles me how you make a presentation but won't answer a question. Shows lack of interest.
you did not demonstrate how the named range works - add/remove row/column. essentially you demonstrated the same thing twice
I showed how to name it and said it’s basically the same process except naming the table. :)
@@MelCompton mmm... i mean you did show step 1 of 10. the other 9 steps are harder to figure and they are not in your video.
@@lxvideostuff7200 The details on how to name a range of cells is not within the scope of this tutorial. I suggest that you seek out a tutorial on that other topic.
Simply stated: Knowing how to set a name to a range of cells is a pre-requisite to appreciating the topic that is presented by Melissa in this tutorial.
@@vinceb7918 it does not matter, that you did not understand what i say