A look at the most simple ways of manipulating data in Calc.
Hosted by Ahuka on 2014-11-07 is flagged as Clean and is released under a CC-BY-SA license.
Tags: LibreOffice, Calc, Spreadsheet, sorting, autofilter.
Listen in ogg,
mp3 format. | Comments (0)
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 http://www.ahuka.com/?page_id=879
<< First, < Previous, Next >, Latest >>
Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.
Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).