The Tutorials in this series are created LibreOffice Suite 3.3. on windows. LibreOffice Base is the database front-end of the LibreOffice suite,Base is the equivalent of Microsoft Access. Read more
Foss : LibreOffice Suite Base - English
Outline: Turn information items into columns What is primary keys ? How to setup Primary keys What is Foreign Keys Set up the table relationships - One-to-One Relationship - One-t..
Outline: Refine the database design Apply the normalization rules First Normal Form Second Normal Form Third Normal Form Test the database design
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..
Foss : LibreOffice Suite Draw 6.3 - English
Outline: Introduction to LibreOffice Draw About LibreOffice Draw Difference between bitmap and vector graphics LibreOffice Draw workspace About various toolbars Create and save a do..
Outline: Drawing Basic Objects Define an object Select, move and delete an object Resize an object using the handles Insert objects from the shapes deck Change the properties of the ..
Outline: Working with Objects Select and move the objects Cut, copy and paste objects Resize the objects using the handles About dynamic resizing Arrange the objects using the Arrang..
Outline: Fill objects with color Make the outlines invisible Group the objects Edit the grouped objects by entering into the group Add and adjust a shadows to objects About gradient ..
Outline: Inserting text in objects Format the text in objects Draw a text box and insert text inside it Edit the objects in the group Insert lines and arrows Drag, adjust and delete ..
Outline: Common Edit and Print Functions About page margins Set the customized paper size Insert page numbers Change the page number format Insert date, time and author’s name. Abo..