Libre Office pivot table tutorial

Back

01-10-2017

(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:

  • How many products sold each day of the month
  • How much each sales agent sold on a day or whole month
  • Which product sold the most
  • Which days the sales agents worked
  • Total sales of a specific product

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?

Subscribe to DCP YouTube for more free Libre Office Calc video tutorials.

# LibreOffice calc

# create a pivot table in libre office calc

# libre office calc pivot table tutorial


Pivot table Libre Office calc tutorial video tutorial by: DCP Web Designers London


Releated Posts

Libre Office Calc - How to format cells | LibreOffice Spreadsheet Cell Formatting Tutorial

17-10-2018

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 | Video Tutorial

29-04-2019

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

25-07-2017

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

23-08-2014

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.

GET YOUR FREE QUOTE


CLAIM YOUR 2 HOURS

FREE CONSULTANCY


  • AFFORDABLE PRICING
  • 15 YEAR KNOWLEDGE
  • LONDON BASED DESIGN AGENCY

NO OBLIGATION QUOTE

arrow
Please enter your name
Please enter correct email
Please enter your phone number
Please enter your message

Your data is encrypted and never shared.
View our privacy policy.

Thank you for contacting us.
We will reply to you in next 2 working days.

back