Foss: LibreOffice Suite Calc 6.3 - English

Outline: Introduction to LibreOffice Calc. Various toolbars in Calc window Opening new spreadsheet in Calc Opening an existing spreadsheet in Calc Save and close a spreadsheet Workbook in Calc Grid of c..

Foss: LibreOffice Suite Calc 6.3 - English

Outline: Working with cells in Calc Enter numbers in cells Enter text in cells Enter date and time in cells Use the Format Cells dialog-box Navigate between cells Select items in rows Select items i..

Foss: LibreOffice Suite Calc 6.3 - English

Outline: Working with Sheets in Calc Insert a single row or a single column Inserting multiple rows Inserting multiple columns Inserting sheets Deleting sheets Renaming Sheets Moving Sheets Deletin..

Foss: LibreOffice Suite Calc 6.3 - English

Outline: Formatting data in Calc Applying border styles from available list Formatting borders of cells as per our preference Adding background colors in cells Formatting multiple lines within a single ..

Foss: LibreOffice Suite Calc 6.3 - English

Outline: Basic data manipulation in Calc Introduction to basics of using formula in Calc Basic arithmetic calculations - addition, subtraction, multiplication, division Sorting by columns Basics of filteri..

Foss: LibreOffice Suite Calc 6.3 - English

Outline: Working with data in Calc Speed up using Fill tools Sharing content between sheets Removing data Replacing data Changing part of a data Different Fill tool Different Fill Series

Foss: LibreOffice Suite Calc 6.3 - English

Outline: Viewing and Printing a Spreadsheet in Calc Viewing in Normal mode Viewing in Page Break mode Viewing in Full Screen mode Setting up Page Style options Setting up the page order Setting up Pag..

Foss: LibreOffice Suite Calc 6.3 - English

Outline: Using Charts and Graphics in Calc Create, edit and format Charts Resize and move Charts Different Chart formats 3D Look in Chart Add a title to the Chart Data Series in Chart Data Ranges in C..

Foss: LibreOffice Suite Calc 6.3 - English

Outline: Inserting Images and inbuilt Graphics in Calc Insert an Image file directly Insert an Image file from a graphics program Insert an Image with the help of a clipboard Insert an Image from the ga..

Foss: LibreOffice Suite Calc 6.3 - English

Outline: Advanced Formatting and Protection in Calc Password protect from a spreadsheet Remove Password protect from a spreadsheet Password protect from a single sheet Remove Password protect from a sin..

Foss: LibreOffice Suite Calc 6.3 - English

Outline: Formulae and Functions in Calc Usage of Conditional Operator in Calc Usage of If.. Or statement in Calc Rounding off numbers Usage of Function Wizard in Calc Usage of following functions in ..

Foss: LibreOffice Suite Calc 6.3 - English

Outline: Linking Calc Data Cell Referencing in Calc Inserting a Hyperlink in a spreadsheet Navigate between sheets using Hyperlink Navigate between documents using Hyperlink Hyperlinking to a website U..