Office Software
Advanced Spreadsheets – Financial Functions
Use financial functions: fv, pv, pmt. In the same wizard, under the ‘Financial’ category, we have the ‘FV’ function. This function returns the future value of an investment based on regular payments and a constant rate of interest. This function takes up five values, ‘Rate’, ‘NPER’, ‘PMT’, ‘PV’ and ‘Type’. ‘Rate’ is the rate of…
Read MoreAdvanced Spreadsheets – Text Functions
Use text functions: left, right, mid, trim, concatenate. In the ‘Function Wizard’, under the ‘Text’ category, we have some functions which can be used to analyze text values. One such function is ‘LEFT’. This function returns a specified number of first characters from any word. This function takes two arguments, ‘text’ and ‘number’. The ‘text’…
Read MoreAdvanced 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 More