↓
 

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
1 2 >>

Monthly Archives: February 2016

Post navigation

← Previous Post

Advanced Spreadsheets – Templates

The Place For Free Online Training Courses

Create a spreadsheet based on an existing template. To create a spreadsheet based on an already existing template, click on ‘File’ from main menu bar. From the resulting drop-down, click on ‘New’, and from the sub-menu, click on ‘Templates’. This … Take lesson

Advanced Spreadsheets – Paste Special

The Place For Free Online Training Courses

Use paste special options: add, subtract, multiply, divide. Paste special options help in making some quick calculations and formatting changes by a special copy paste function. We need to have some data to use the special paste function. From the … Take lesson

Advanced Spreadsheets – Naming Cells

The Place For Free Online Training Courses

Name cell ranges, delete names for cell ranges. To name a cell range, click on ‘Insert’ from the main menu bar. From the resulting menu, click on ‘Names’ and from the sub-menu which gets generated, click on ‘Define’. This will … Take lesson

Advanced Spreadsheets – Comments & Notes

The Place For Free Online Training Courses

Insert, edit, delete, show, and hide comments/notes. To insert comments is a worksheet, select the cell to which you need to insert the comment and right-click on this cell. This will open a menu from which you need to click, … Take lesson

Advanced Spreadsheets – Show Formulas

The Place For Free Online Training Courses

Show all formulas in a worksheet, rather than the resulting values. To show formulas in the worksheet instead of the resulting values, click on ‘Tools’ from the main menu bar. From the resulting drop-down, click on ‘Options’. This opens the … Take lesson

Advanced Spreadsheets – Auditing

The Place For Free Online Training Courses

Trace precedent, dependent cells. Identify cells with missing dependents. Trace precedent gives us the cells on which the value of the current selected cell depends. To trace the precedent of a cell, select the cell and then click on ‘Tools’ … Take lesson

Advanced Spreadsheets – Validating

The Place For Free Online Training Courses

Set and edit validation criteria for data entry in a cell range like: whole number, decimal, list, date, time. To set validation criteria for data entry in a cell range, click on ‘Data’ from the main menu bar, and from … Take lesson

Advanced Spreadsheets – Scenarios

The Place For Free Online Training Courses

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

Advanced Spreadsheets – Sub-totaling

The Place For Free Online Training Courses

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

Advanced Spreadsheets – Filter

The Place For Free Online Training Courses

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

Post navigation

← Previous Post


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