(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 customer's 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?
Pivot table Libre Office calc tutorial video tutorial by: DCP Web Designers London
Libre Office Calc - How to format cells
In this video tutorial, I will show you how to format cells in Libre Office Calc 6. It is important to understand how to format cell correctly in LibreOffice Calc. When cells are formatted correctly the data entered will display in the correct format. You can also change how data is displayed depending on the chosen format, for examples, currently, values may contain a "£" or "$" sign.
How to Customise Your Start Menu in Windows 10
In this video tutorial, I will show you how to Customize Your Start Menu in Windows 10. This tutorial is useful if you want super fast access to your applications. I like to organise my start menu so I can access the applications with a few simple mouse clicks.
How to create a custom background for Libre Office Impress slides
In this video tutorial, I will show you how to create a custom background for Libre Office Impress presentation slides. Have you ever wanted to create a presentation but need to add some flair to the slides? Libre Office contains a powerful set of application which includes Impress. Best of all Libre Office is free to download and use.
Bookkeeping for small business tutorial part 1 - open office calc spreadsheets
This is a free video tutorial for small business bookkeeping - part 1 - open office calc spreadsheets - invoice tracking - bookkeeping training. In this video tutorial, I will show you how to keep track of invoices which you have sent to your clients. By the end of this tutorial, you will be able to keep track of all your invoices and know who has paid and more importantly how has NOT paid so you can chase up payments.
Thank you for contacting us.
We will reply to you in next 2 working days.