↓
 

The Place For Free Online Training Courses

Improve Your Career Prospects

  • Home
  • Office Software
    • Understanding Spreadsheets
    • Advanced Spreadsheets
    • Understanding Word Processing
    • Advanced Word Processing
    • Understanding Presentations
    • Advanced Presentations
    • Understanding Databases
    • Advanced Database
    • Math
  • ICDL Syllabus
    • ICDL Base Module Syllabus Word Processing
    • ICDL Base Module Syllabus Spreadsheets
    • ICDL Base Module Syllabus Presentations
    • ICDL Base Module Syllabus Databases
    • ICDL Advanced Module Syllabus Word Processing
    • ICDL Advanced Module Syllabus Spreadsheets
    • ICDL Advanced Module Syllabus Presentations
    • ICDL Advanced Module Syllabus Databases
  • FaQ

Monthly Archives: December 2015

Advanced Spreadsheets – Statistical Functions

The Place For Free Online Training Courses

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 … Take lesson

Advanced Spreadsheets – Mathematical Functions

The Place For Free Online Training Courses

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 … Take lesson

Advanced Spreadsheets – Date and Time Functions

The Place For Free Online Training Courses

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 … Take lesson

Advanced Spreadsheets – Hide and Show

The Place For Free Online Training Courses

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, … Take lesson

Advanced Spreadsheets – Split Bars

The Place For Free Online Training Courses

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 … Take lesson

Advanced Spreadsheets – Worksheets

The Place For Free Online Training Courses

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’ … Take lesson

Advanced Spreadsheets – Formatting Numbers

The Place For Free Online Training Courses

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 … Take lesson

Advanced Spreadsheets – Conditional Formatting

The Place For Free Online Training Courses

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 … Take lesson

Advanced Spreadsheets – Formatting Cells

The Place For Free Online Training Courses

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 … Take lesson



  • Terms and Conditions
  • Privacy Policy
  • Site Map
©2021 - The Place For Free Online Training Courses Privacy Policy
↑