Search Tutorials

About 97 results found.

Foss : LibreOffice Calc on BOSS Linux - English

Working with Cells How to enter numbers,text,numbers as text,date and time in Calc. How to Navigate between cells and in between sheets. How to select items in rows,columns and sheets..

Basic

Foss : LibreOffice Calc on BOSS Linux - English

Formulas and Functions Creating formulas,operator types and referencing Basic arithmetic and statistic functions - relative and fixed ($) referencing in a function Rounding off number..

Intermediate

Foss : LibreOffice Calc on BOSS Linux - English

Basic Data Manipulation Paste and paste special (values, transpose), pasting a spreadsheet into writer as a table Introduction to Formulas – Sum, Average, basic formula (=a*b+c) Subto..

Basic

Foss : LibreOffice Calc on BOSS Linux - English

Formatting Data Borders, Color, Formatting Text, Increasing Cell Size Formatting multiple lines of text,numbers,fonts,cell borders,cell background Automatic Wrapping and Using manual ..

Basic

Foss : LibreOffice Suite Draw - English

Insert text in drawings Insert text directly inside an object Changing the text color Working with text boxes and formatting text in objects Making the line wider. Set preferences for text Inden..

Basic

Foss : LibreOffice Suite Draw - English

Curves and Polygons Various types of Polygons Draw directions using arrows Flow charts Insert tables and graphs Page Margins and Orientation Font Type and Size modification

Intermediate

Foss : LibreOffice Suite Draw - English

Create simple drawings Basic shapes (lines, arrows, rectangles and squares, circles) (How to improve upon a water cycle diagram by adding shapes and so on.) Geometric shapes (basic shapes, symbols)..

Basic

Foss : LibreOffice Suite Draw - English

Use the Edit Points toolbar Insert new points Move existing points Using control lines to change the shape of the objects Group the objects together

Intermediate

Foss : LibreOffice Suite Draw - English

Fill objects with color, gradients, hatching and bitmaps Making outlines invisible Adding a shadow to the objects Creating new colors How to import a bitmap into Draw. Set page backgrounds

Basic

Foss : LibreOffice Suite Draw - English

Common editing and print functions Set the draw page for page size and margins Paper size, page count, page numbers, date, and time Undo and redo actions Rename a page Print a page

Basic

Foss : LibreOffice Suite Calc - English

Working with data Selection lists Speed up using Fill tools Sharing content between sheets Removing data Replacing data Changing part of a data Different Fill tool Different Fill Series

Basic

Foss : LibreOffice Suite Calc - English

Working with Sheets Inserting rows and columns Inserting and deleting sheets Renaming Sheets Deleting rows and columns Insert a single row or a single column

Basic

Foss : LibreOffice Suite Draw - English

Basics of working with objects Cut, copy, paste objects Resize objects dynamically using handles Object Arrangement Adding a new page to a file Group and ungroup objects Edit individual objects ..

Basic

Foss : LibreOffice Suite Calc - English

Working with Cells Enter numbers Text Numbers as text Date and time in a spreadsheet. Use the Format Cells dialog-box. Navigate between cells and in between sheets Select items in rows, columns..

Basic

Foss : LibreOffice Suite Calc - English

Images and graphics in Calc Add Inserting an image file directly Add Inserting an image file from a graphics program Add Images Help of a clipboard Add Images From the gallery. Picture toolbar..

Intermediate

Foss : LibreOffice Suite Calc - English

Linking Calc Data Referencing Working with Hyperlink Use of Hyperlink in C Remove the hyperlink Cell referencing

Intermediate

Foss : LibreOffice Suite Calc - English

Using Charts and graphs in Calc Creating, editing and formatting charts Resizing and moving of charts. Chart formats Create a chart Data Series Format Selection Title option Axis option Forma..

Intermediate

Foss : LibreOffice Suite Calc - English

Formulas and Functions Conditional Operator If..Or statement Basic statistic functions Rounding off numbers. SUM for addition PRODUCT for multiplication QUOTIENT for division

Intermediate

Foss : LibreOffice Suite Base - English

Tables and Relationships Adding data to a table. Define and create relationships.

Basic

Foss : LibreOffice Suite Calc - English

Advanced Formatting and Protection Password protect a spreadsheet Password protect a single sheet Define Ranges for a database Use the Subtotal option Validate cells Database range Protect S..

Intermediate