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



(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

30 inspirational quotes that every business owner should read


30 inspirational quotes that every business owner should read

sometimes in business, we run out of inspiration, so why not check out 30 inspirational quotes from leading business owners. Running a business can be overwhelming and very challenging so read through these 30 inspirational quotes to give you a boost in the right direction.

Libre Office 6 Writer Beginners Tutorial - [ Word Processing Tutorial - Document Editing ]


Libre Office 6 Writer Beginners Tutorial

In the tutorial, I will go through some of the fundamentals of using Libre Office 6 Writer. We will build a letterhead document which you can use in your business using free Libre Office 6 Writer software. I will show you how to: Create a custom header and footer, Add your company logo, add your business address, add your website address, add URL links, create font styles, create bullet lists, add images, add and format tables, + much more

Skype - Business communication tool


Skype - Business communication tool

Use Skype to communicate with your staff and clients for free. Skype is software that enables you to make free calls anywhere in the world. Skype uses innovative P2P (peer-to-peer) technology to connect you with other users.

Top 10 branding tips to drive your business to success


Top 10 branding tips to drive your business to success

Generating an attractive homepage is vital for any business website. Clear and captivating images to high quality and readable content should be a top priority.






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.