↓
 

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

Monthly Archives: June 2015

Post navigation

← Previous Post

Create Spreadsheet Charts

The Place For Free Online Training Courses

Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart. In Calc, we can represent our data with the help of different graphical representations like column chart, bar chart, line chart, or pie chart. … Take lesson

Spreadsheet Formats – Alignment and Border Effects

The Place For Free Online Training Courses

Apply text wrapping to contents within a cell, cell range. To apply text wrapping to contents within a cell or a cell range, first select the cell or the cell range and then right click anywhere on the entire range. … Take lesson

Change Spreadsheet Cell Content Appearance

The Place For Free Online Training Courses

Change cell content appearance: font sizes, font types. In the same ‘Format Cells’ dialog box, under the ‘Font’ tab, we have the ‘Font’ and ‘Size’ drop-down lists. The ‘Font’ drop-down list gives the different font types and ‘Size’ gives the … Take lesson

Formatting

The Place For Free Online Training Courses

Numbers/Dates Format cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands. It is possible in Calc to format cells to display any input in some particular styles. To … Take lesson

The IF Function

The Place For Free Online Training Courses

Use the logical function if (yielding one of two specific values) with comparison operator: =, >, <. To use the logical function ‘IF’, we need to follow the same steps as before to reach the ‘Function Wizard’. In the ‘Function … Take lesson

Functions

The Place For Free Online Training Courses

Use sum, average, minimum, maximum, count, counta, round functions. Functions help us in analyzing and referencing data. To use functions in a worksheet, first of all we need some data on which the functions are to be applied. Any function … Take lesson

Formulas and Functions

The Place For Free Online Training Courses

Arithmetic Formulas Recognize good practice in formula creation: refer to cell references rather than type numbers into formulas. We have been entering either text or numbers into the cells till now, but in case the data in a cell is … Take lesson

Worksheets

The Place For Free Online Training Courses

Switch between worksheets. To switch between different open worksheets, we just need to click on the appropriate sheet name from the bottom of the Calc window, as has been shown in the below given illustration. When we click on a … Take lesson

Managing Worksheets

The Place For Free Online Training Courses

Rows and Columns Select a row, range of adjacent rows, and range of non-adjacent rows. To select a row, simply click on the row header for that row. It should just be a single click and not a double click. … Take lesson

Copy, Move, Delete Spreadsheet Cells

The Place For Free Online Training Courses

Copy the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets. To copy the content of a cell or a range of cells within a worksheet, between worksheets or even to another open spreadsheet, simply … Take lesson

Post navigation

← Previous Post


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