LibreOffice

Create named scenarios. A scenario is a tool in Calc which helps in testing ‘what-if’ questions. Anything which depends on a particular condition can be defined using a scenario. Say you need to calculate some amount in different currencies; you can have different scenarios for different currencies and can use them as per the requirement.…

Use automatic sub-totaling features. Automatic sub-totaling features help in displaying the sub-totals of particular sections of a table. To use automatic sub-totaling features, first of all make sure that you have automatic filters enabled for all the columns for which sub-totaling needs to be done. After this, select any one cell from the entire range.…

Apply advanced filter options to a list. Advanced filter options help in filtering the data more precisely than it is possible with the default methods available in Calc. To apply advanced filter options to a list, select the list which needs to be filtered. After selecting the list, click on ‘Data’ from the main menu…

Automatically filter a list in place. To automatically filter a list, select the complete list which needs to be filtered. After selecting the list, click on ‘Data’ from the main menu bar and from the resulting drop-down click on ‘Filter’. From the sub-menu which is generated, click on ‘AutoFilter’. This will create a drop-down symbol…

Create a customized list and perform a custom sort. In some cases, when we might need to sort the data in a way other than the ones available by default in Calc, we can create our own custom list format. In the ‘Sort’ dialog box, under the ‘Options’ tab, we have the ‘Custom sort order’…

Sort data by multiple columns at the same time. Sorting data means arranging data as per some pre-defined structures. To sort any data in Calc, the first thing which needs to be done is to select the data which needs to be sorted. After selecting the data, click on ‘Data’ from the main menu bar.…

Automatically, manually group data in a pivot table/data pilot and rename groups. Grouping data is a simple process which can be used to create groups of data and then analyzing these groups instead of analyzing the individual values. This simply means that instead of focusing on the individual values, we analyze these values as a…

Filter, sort data in a pivot table/data pilot. Filtering data means applying some conditions to the data so that only those data fields get displayed which satisfy these conditions. To filter data in a pivot table, simply right-click anywhere on the table and from the resulting menu, click on ‘Filter’. This will open the ‘Filter’…

Create and modify a pivot table/data pilot. A pivot table is a very effective and efficient tool for comparing, combining, and analyzing large amounts of data in a simple manner. To use pivot table, the first thing which is required is some raw data. The data should be in the form of a database table…

Format columns, bars, plot area, chart area to display an image. In Calc charts, we cannot use custom images by importing them into the charts from our local machine. Though Calc does provide the option for using the different types of ‘Fill’ options for the columns, bars, plot area or chart area like ‘Color’, ‘Hatching’,…