The Tutorials in this series are created using LibreOffice Suite 6.3.5 on Ubuntu 18.04. LibreOffice Calc is the spreadsheet component of LibreOffice Suite. It is the equivalent of Microsoft Excel in Microsoft Suite and has a number of unique features, including a system which automatically defines series of graphs, based on information available to the user. Read more
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 Workboo..
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 r..
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 Mo..
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 li..
Outline: Basic data manipulation in Calc Introduction to basics of using formula in Calc Basic arithmetic calculations - addition, subtraction, multiplication, division Sorting by column..
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 Se..
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 o..
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 Cha..
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 ..
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 Passwor..
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 fol..
Outline: Linking Calc Data Cell Referencing in Calc Inserting a Hyperlink in a spreadsheet Navigate between sheets using Hyperlink Navigate between documents using Hyperlink Hyperlin..