hpr1635 :: 41 - LibreOffice Calc - Data Manipulation 1: Sorting and AutoFilter
A look at the most simple ways of manipulating data in Calc.
Hosted by Ahuka on Friday, 2014-11-07 is flagged as Clean and is released under a CC-BY-SA license.
LibreOffice, Calc, Spreadsheet, sorting, autofilter.
(Be the first).
The show is available on the Internet Archive at: https://archive.org/details/hpr1635
Listen in ogg,
spx,
or mp3 format. Play now:
Duration: 00:12:42
LibreOffice.
In this in-depth series on LibreOffice we examine Writer, Calc and Impress
The next major area of investigation for this series is how we can do data manipulation in Calc. Although Calc is not a database, it can be used for some data analysis and manipulation. When I worked for the finance department of a hospital, it was very common for the financial analysts to get a data dump from a centralized system as a CSV file, load it up in a spreadsheet, and then slice-and-dice the data to get the answers they wanted. It is not anywhere near what you can do with a good relational database and a structured query, but you can do some quick-and-dirty analysis here. - For more go to https://www.ahuka.com/?page_id=879