How to Create a Pivot Table in LibreOffice Calc

Create a powerful pivot table in LibreOffice Calc with ease! In this tutorial, I'll show you step-by-step how to quickly create and customize your own pivot table to get the insight you need from your data. We'll go over everything from setting up the spreadsheet to formatting the output - so that you can make better, smarter decisions faster. Let me help you become an expert at using LibreOffice Calc and leverage the power of pivot tables!

CHAPTERS:
00:00 - Intro
00:52 - Current Selection Setup
06:09 - Structure
07:13 - Using the Pivot Table
08:45 - Changing the Pivot Table
09:16 - Charts
12:13 - Named Range Setup
14:05 - Structure
14:50 - Changes
14:54 - Charts
16:32 Outro

My Gear:

My Software:

Connect with me on social media:

This description contains affiliate links and I may be paid a small commission (the price is the same for you) should you purchase using these links.

#MelissaCompton #libreoffice #pivottable

[brlin]

Many thanks for this one!

One experience to share is that if you're processing a sheet given by a third party the numeric column cells may not set properly to the numeric type, which will cause the generated pivot table's value cells to be blank, to fix this convert the cell format to numeric type beforehand.

[sebastiankumlin]

This was helpful and I LEARNED SOMETHING! Thank you!

[enriqueblanco]

High quality video... thanks for taking your time in explaining in detail how to use pivot tables and create charts from them. By the way, have you ever tried creating stock type charts? I cannot figure out how do they work... :(

[tonyshield]

Lovely teaching and demonstration style. Content was great.

[Lyunpaw]

Great video. Thanks for the information.

[sizomabu]

Well done
Thanks
Is it possible to add calculated field in this pivot tables 🤔

[gio-cisco-si]

Excellent!! Is it possible to also make a Pivot Chart?

[beezeejo]

Thank you so much for the clear instructions, much better than the Libre Office official site! Would you mind answering 2 questions for me?
1. For some odd reason when I right click ( like you do at the 8:40 mark) anywhere on the table, I cannot get pivot table properties to come up. It could be an issue with my install but I thought it odd that I can't do that. Any suggestions?

2. Do you plan on doing more content showing the differences between Libre Calc and Excel for financial professionals?

Thank you and you have earned a like and subscribe!

[lxvideostuff]

you did not demonstrate how the named range works - add/remove row/column. essentially you demonstrated the same thing twice