____  ___    _  _     _   _ _____     _______
 / ___|/ _ \  | || |   | | | |_ _\ \   / / ____|
| |  _| | | | | || |_  | |_| || | \ \ / /|  _|
| |_| | |_| | |__   _| |  _  || |  \ V / | |___
 \____|\___/     |_|   |_| |_|___|  \_/  |_____|

 --- A GOPHER-LIKE INTERFACE FOR HIVE BLOCKCHAIN ---

Sort & Filtering data using Pivot Table on LibreOffice calc

BY: @darsondrew | CREATED: May 18, 2018, 5:08 p.m. | VOTES: 8 | PAYOUT: $31.28 | [ VOTE ]

[IMAGE: https://steemitimages.com/DQmfDjdkXyuaJnVnPudq5LeaTx1wLWhDCx5eriVcUY5DQQi/canok.png]

Source Image

Repository

https://github.com/LibreOffice/core

What Will I Learn?

In the video I give an explanation how to create pivot table.
- You will learn how to using Pivot table.
- You will learn about Pivot table layout.
- You will learn about placing pivot table destinations.
- You will learn how to change display of pivot table.
- You will learn how to filter pivot table data.

What is LibreOffice Pivot table?

A pivot table make it easy rearrange, sort, and filter data in a table without using formulas. this is very useful and makes the data can be used more instantly.

Requirements

Information

Difficulty

Intermediate

Description

Pivot table is a unique function that makes users more easily get more instant data results. pivot table does not use a formula to determine the result, you can use pivot table to rearrange, sort, filter data very quickly and easily.

[IMAGE: https://steemitimages.com/DQmWM7iwtwdkivi7QYC4yuj5egofycsmZFG2UqeA5PZZVYT/five.PNG]

In the photo above, at the time of making pivot table, there are many functions such as Data Field, data field give some function like, Sum, Count, Average, Median, Max, Min, Product, StDev, StDevP, Var, VarP which have same function as formula.

[IMAGE: https://steemitimages.com/DQmYGKp2HhAHMZ6SRLQSArM97mcBa6Xcy9JCNAxVReViLvK/first.PNG]

In the photo above, the Pivot table can sort the data to be displayed by simply checking and unchecking the options.

[IMAGE: https://steemitimages.com/DQmVZc8eGNVbQpoWmfhPMFLP3qQEBf79nfWyej9fvh3dzWx/second.PNG]

In the photo above, sorting data by date can be done simply by checking and unchecking options.

[IMAGE: https://steemitimages.com/DQme1LUQJkzkSfn27j7wQeZbC4b3cmKL6ACJATcwP56RmNR/third.PNG]

In the photo above, adding a filter feature to the pivot table is done when creating a pivot table. filter provides a choice of criteria to determine the data to be filtered, the criteria filter has 2 operators namely AND & OR function. so you can determine the filter results you need more accurately.

[IMAGE: https://steemitimages.com/DQmXz2VHRZ7LsD1ouEgJzBFVk2oKCnrzpUXpco6oAghTQbA/fourth.PNG]

In the photo above, while filtering the data, you can also specify the data condition with some condition options, such as = , < , > , <= , >= , <> . and determine the value that makes the results more accurate.

Video Tutorial

https://youtu.be/AFClsKXG6Zk

Proof of Work: Pivot Table Sort & Filtering data

You can download my pivot table sort & filtering data files

Curriculum

TAGS: [ #utopian-io ] [ #video-tutorials ] [ #libreoffice ] [ #education ] [ #video ]

Replies

@khushbakht | May 18, 2018, 6:34 p.m. | Votes: 3 | [ VOTE ]

very very good content , i just read your content its have good nformation for us thanks for sharing :) @darsondrew

@darsondrew | May 20, 2018, 6:22 a.m. | Votes: 1 | [ VOTE ]

Thank you for your support :) @khushbakht

@khushbakht | May 20, 2018, 8:15 a.m. | Votes: 2 | [ VOTE ]

you are always welcome :)

@rosatravels | May 19, 2018, 6:17 a.m. | Votes: 0 | [ VOTE ]

Hi @darsondrew

Thank you for your contribution and here are some areas that you need to make improvement on.

  • In a video tutorial, the teaching element is very important to explain concepts and insights into the function.

  • Just showing on screen what you do is not enough for a tutorial. The learner needs to know the principles behind the working of the function so that they can apply it to their own situation.

  • Your video tutorial needs to supercede the tutorials that are already seen on you-tube and elsewhere. You need to give teaching on the functionalities of the techniques.

Your contribution has been evaluated according to Utopian rules and guidelines, as well as a predefined set of questions pertaining to the category.

To view those questions and the relevant answers related to your post,Click here

Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.
[utopian-moderator]

@utopian-io | May 19, 2018, 5:10 p.m. | Votes: 0 | [ VOTE ]

Hey @darsondrew
Thanks for contributing on Utopian.
We’re already looking forward to your next contribution!

Contributing on Utopian
Learn how to contribute on our website or by watching this tutorial on Youtube.

Want to chat? Join us on Discord https://discord.gg/h52nFrV.

Vote for Utopian Witness!

[ BACK TO TRENDING ] [ BACK TO MENU ]
CMD>