| by Arround The Web

How to Move Columns in LibreOffice Calc [Tutorial]

Moving columns in LibreOffice has some confusing steps. It’s a little different from traditional Microsoft Excel. Here’s a basic guide explaining how to move columns in LibreOffice Calc.
The post How to Move Columns in LibreOffice Calc [Tutorial]…

Share Button
Read More
| by Arround The Web

Highlight Rows and Columns of Active Cell in LibreOffice Calc

This is a simple guide to highlight rows and columns of active cells in LibreOffice Calc as you move around the spreadsheet.
The post Highlight Rows and Columns of Active Cell in LibreOffice Calc appeared first on Linux Today.

Share Button
Read More
| by Arround The Web

LibreOffice 24.2: Best New Features

LibreOffice 24.2 is currently under beta testing. From this release onwards, the team will change the versioning scheme to YY.MM is based on year and month. Earlier, it used to be a simple increment to the major and minor versions, which was a little d…

Share Button
Read More
| by Arround The Web

LibreOffice Calc: Create and Use Filters

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 …

Share Button
Read More
| by Arround The Web

LibreOffice Calc Productive Exercises for Students and Workers

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…

Share Button
Read More
| by Arround The Web

LibreOffice Calc Basics IX: MIN and MAX

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…

Share Button
Read More
| by Arround The Web

How To Add XLOOKUP Function to LibreOffice Calc

This tutorial will explain in short how to make LibreOffice Calc able to do XLOOKUP by adding an extension called Lox365. It will give you abilities of xlookup and more features like Excel. We would love to say thank you very much to the developer, Goo…

Share Button
Read More
| by Arround The Web

LibreOffice Calc: How To Convert Numbers to Text

This tutorial will show you an example of converting numbers to words with a function in LibreOffice Calc. It works by translating number, say 1234, into English words one thousand two hundred thirty four. The function in question is NUMBERTEXT, that s…

Share Button
Read More
| by Arround The Web

How To Make Calendar with LibreOffice Calc

This tutorial will show you the exercise of making calendars with LibreOffice Calc. It works with multilingual translations automatically so you can easily print ones with English, Indonesian, German, Chinese, Japanese and other languages. Now let’s ex…

Share Button
Read More
| by Arround The Web

How To Import and Use Microsoft Excel Templates on LibreOffice Calc

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…

Share Button
Read More
| by Arround The Web

LibreOffice Calc: Pivot Table Made Easy

This tutorial will show you how to create Pivot Table using LibreOffice Calc — the complete, free spreadsheet program for everyone. We will learn with examples and pictures by using a simple sales table to create sales report with multiple pivot tab…

Share Button
Read More
| by Arround The Web

LibreOffice Writer: Mail Merge Made Easy

This tutorial will help you to create mail merge with LibreOffice explained step by step with pictures and examples. Mail merge is a method of making stuffs consisted of multiple personalized copies like official letters, invitations, envelops, ident…

Share Button
Read More
| by Arround The Web

LibreOffice Calc Spreadsheet Basic Tutorials Collection

We have finished publishing a collection of very basic Calc Spreadsheet tutorials for beginner grade since January 2022. Calc is a spreadsheet for everyone from LibreOffice — the most excellent free alternative to Microsoft Excel. This collection expl…

Share Button
Read More
| by Arround The Web

LibreOffice Calc Basics VIII: HLOOKUP

This tutorial explains the horizontal variant of vlookup formula, called HLOOKUP, on LibreOffice Calc. We will learn first about data transposing, then manipulating it with the formula. As a reminder, if you haven’t followed this LibreOffice Calc seri…

Share Button
Read More
| by Arround The Web

LibreOffice Calc Basics VII: VLOOKUP

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…

Share Button
Read More
| by Arround The Web

LibreOffice Calc Basics VI: ROUND

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…

Share Button
Read More
| by Arround The Web

LibreOffice Calc: Create Charts

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…

Share Button
Read More
| by Arround The Web

LibreOffice Calc: Create Random Data

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…

Share Button
Read More
| by Arround The Web

LibreOffice Calc: Create Data Entry Form

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…

Share Button
Read More
| by Arround The Web

LibreOffice Calc Basics V: LEN and CONCATENATE

This tutorial continues Calc Basics IV and now we will learn two new formulas namely LEN and CONCATENATE. As an addition, you will also learn new skills called Paste Special and also Compare Sheets to help you copying formula and text to your needs. As…

Share Button
Read More
  • 1
  • 2