Advanced Spreadsheets – Statistical Functions

Use statistical functions: countif, countblank, rank. In the same wizard, under the ‘Statistical’ category, we have the ‘COUNTIF’ function. This function counts the number of arguments which meet the set conditions. This function takes two arguments, ‘range’ and ‘criteria’. These give the range of cells to be evaluated and the criteria to be used for…

Read More

Advanced Spreadsheets – Mathematical Functions

Use mathematical functions: rounddown, roundup, sumif. To use mathematical functions, in the same ‘Function Wizard’, select the ‘Mathematical’ category. From the ‘Function’ drop-down list, select ‘ROUNDDOWN’. This function rounds a number down to a predefined accuracy. This means that the number is rounded in such a way that the lower value is always displayed. After…

Read More

Advanced Spreadsheets – Date and Time Functions

Use date and time functions: today, now, day, month, and year. To use the different types of functions and formulas in Calc, select the cell in which you want to display the result of the function, and then click on ‘Insert’ from the main menu bar, and from the resulting drop-down menu, click on ‘Function’.…

Read More

Advanced Spreadsheets – Hide and Show

Hide, show rows, columns, worksheets. To hide a row or a column, just select the row or column you want to hide. After selecting the row or column, click on ‘Format’ from the main menu bar and from the drop-down, click on ‘Row’ or ‘Column’ as per the selected data range. From the sub-menu, click…

Read More

Advanced Spreadsheets – Split Bars

Split a window. Move and remove split bars. Splitting a window into multiple instances can help us in viewing and operating with multiple spreadsheets at the same time. To split a window, Click on the row header below the rows where you want to split the screen horizontally or click on the column header to…

Read More

Advanced Spreadsheets – Worksheets

Copy, move worksheets between spreadsheets. To copy or move a worksheet between spreadsheets, right-click on the sheet name which needs to be moved or copied and from the resulting menu, click on ‘Move/Copy Sheet’. This will open the ‘Move/Copy Sheet’ dialog box. In this dialog box, we have two radio buttons to choose if we…

Read More

Advanced Spreadsheets – Formatting Numbers

Create and apply custom number formats. We have a variety of number formats which can be used to format the data in a cell in Calc. But sometimes we might need to format our data in some format which might not be available in Calc by default. In such situations, we can create our own…

Read More

Advanced Spreadsheets – Conditional Formatting

Apply conditional formatting based on cell content. Conditional formatting helps us in formatting only those particular cells which satisfy the specified conditions. This means that in any selected cell range, we will define some condition and the cells which satisfy this condition will get formatted while the others will remain as it is. To apply…

Read More

Advanced Spreadsheets – Formatting Cells

Apply an auto-format/table style to a cell range. Auto formatting for a cell range formats that particular cell range as per the selected options automatically. This means that the complete selected cell range will get formatted in the selected manner without having to manually format each individual cell. To apply auto-formatting to a cell range,…

Read More