Archive for December 2015
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 MoreAdvanced 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 MoreAdvanced 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 MoreAdvanced 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 MoreAdvanced 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 MoreAdvanced 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 MoreAdvanced 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 MoreAdvanced 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 MoreAdvanced 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