Pankaj Shah

I hope you enjoy reading our blog posts. If you want DCP to build you an awesome website, click here.

Libre Office pivot table tutorial

01-10-2017

Back

(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


Tell Us Your Thoughts

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


Releated Posts


Open Office 4 Writer Tutorial | Business Letterhead Template Design

14-12-2018

Open Office 4 Writer Tutorial

In this video tutorial, I will show you how to create a business letterhead using Open Office 4 Writer. You will be able to save the letterhead as a PDF file and you can then simply email to your customer so no printing required :)

How to convert Mac pages document to Microsoft Word document

17-03-2018

How to convert Mac pages document to Microsoft Word document

In this video tutorial, I will show you how to convert Mac Pages document to Microsoft Word document. Sometimes a client will send you a formatted document which you can simply not open, in most cases this is a compatibility issue between Windows and Apple Mac software.

How to Nail your Elevator Pitch | Get More Clients

16-12-2022

How to Nail your Elevator Pitch (And Get More Clients)

While it may seem like a simple question, there often is not a simple answer. So you start a business and you have products or services that you sell, customers you serve, industries you work in and the problems you solve. That’s just the basics. You can add to that answer by talking about where you’re located, how many employees you employ when you were founded and your role.

How to install Libre Office on Windows 10

21-02-2017

How to install Libre Office on Windows 10

This is a free video tutorial. In this video tutorial, I will show you how to install Libre Office on Windows 10. Libre Office is a free software application which you can download for Windows, Linux and Apple Mac computers.

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