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


How to install free Fonts on Windows 10

26-10-2018

How to install free Fonts on Windows 10

In this video tutorial, I will show you how to install free Fonts on Windows 10. Finding free fonts you can use on your artwork projects is super simple.there are lots of websites where you can download free fonts. In this tutorial, we will download fonts from Font Squirrel.

How to calculate percentages using Open Office Calc spreadsheet

05-08-2017

How to calculate percentages using Open Office Calc spreadsheet

In this video tutorial, I will show you how to calculate percentages using Open Office Calc spreadsheet. Save yourself some time and use formulas to calculate percentages for small or big data sets.

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.

Creating effective titles and headlines for website page content

13-03-2017

Creating effective titles and headlines for website page content

Before fashioning a domain and getting creative on the keyboard, you must first learn what your prospective customers want from you. What’s the best way to help them understand your content? And what’s the most effective way to obtain and keep them as customers?

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