This tutorial will help you work with Filters feature in LibreOffice Calc (an alternative to Microsoft Excel) to create and use them. This feature, also known as AutoFilter, can help filtering and sorting out data in certain ways. You can download the …
This collection of tutorials will help you learn LibreOffice Calc like Microsoft Excel. We published these gradually since 2022 and is still continuing. We hope these helps you all regardless your occupation being a student, a teacher or a worker. Hap…
This is the ninth part of Calc Basics and here we will learn about the functions MIN and MAX to seek for minimum and maximum value. We still use the same exercise document following Part VIII from the series of this tutorial and you can download it bel…
This tutorial will help you be more productive with LibreOffice Calc by taking benefit of the existing, thousands of Microsoft Excel’s templates on the internet. Thanks to LibreOffice compatibility features, this is possible. With this, you can qui…
Please welcome Cryptpad, an excellent Google Docs alternative from the free software community. For end-users, it provides online facilities of storage drive, text editor (pads), forms, spreadsheet, presentation, kanban boards, and a programming IDE. F…
This is the seventh part of Calc Basics and in this chance we will learn about VLOOKUP formula. For that purpose, we will make a simple student score viewer, so we can select a student’s name for the computer to display his/her scores. As a reminder, i…
This tutorial continues Calc Basics V and now we will learn a new formula namely ROUND. With this, we can simplify numbers. For example, we will simplify student scores based on the previous AVERAGE exercise. As a reminder, if you haven’t followed this…
This tutorial will explain with examples how to draw charts with LibreOffice Calc. You will need some data prepared beforehand. We will create very basic charts in form of Bar Charts to visualize student scores of their subjects of Math, English, Scien…
When you need to create a table quickly, for whatever numeric data in it, you can always use RANDBETWEEN formula in LibreOffice Calc. We prepare this tutorial for Creating Charts next time. Now, let’s learn how to below. Subscribe to UbuntuBu…
Are you tired to do manual data entry into a spreadsheet? Would you like to make it easier with a form window? If you think this requires macros, no, it doesn’t require one. LibreOffice Calc can help you making data entry form instantly out of any tabl…
This tutorial continues Calc Basics III now with LEFT, MID, and RIGHT formulas. By practicing this, you will be able to cut some text by number of characters to help you, for example, get first, middle and last names of students. Like usual, if you hav…
sc-im is lightweight, fast, and intuitive. Here’s what you ned to know.
The post Meet sc-im, an ‘Excel’ for the Terminal appeared first on Linux Today.
When it comes to creating and editing spreadsheets, Microsoft Excel is probably the most popular program. However, the Microsoft software is not natively available for Linux and its costs might be an obstacle for many users. Learn more about the best M…