(Click image above to watch video tutorial)
In this video tutorial I will show you how to setup Libre Office pivot tables.
Pivot tables allow you to structure and filter vast amounts of information using custom table structures. In basic terms the goal of pivot tables is to give you an overview of information which can be easily viewed and interrogated. You can also create custom charts directly from a pivot table. For example if you had a spreadsheet which showed you daily sales over a month duration, the spreadsheet also contained the sales agent ID, the customers ID, the products sold, the cost of each product, the date of sale, then you should be able to create pivot tables which show you:
The above are only a few examples. Using pivot tables you can take spreadsheet information and restructure with a few simple mouse clicks but also maintain the original information for reference. Why not take a look at our other free Libre Office video tutorials?
Video tutorial by: DCP Web Designers London
Subscribe to our newsletter to receive an e-mail once a month with our latest video tutorials, blog articles and web design special offers!
Are you using any of the popular social networks such as Google+, You Tube, Twitter, Facebook or LinkedIn? Add us to your Social Network account and get special offers exclusive to our Social Network Followers!