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


30 inspirational quotes that every business owner should read

04-04-2019

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 ]

14-05-2020

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

14-06-2013

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

05-06-2019

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.

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