LibreOffice Training - Malaysia

LibreOffice Training​ Course Outline

Module 1: Introduction to LibreOffice

• What is LibreOffice?
• Advantages of LibreOffice
• Minimum Requirements
• Installing Software
• Extensions and Add-Ons
• Starting LibreOffice and New Documents
• Open and Save Files on Remote Servers
• Using Navigator and Document Properties
• Closing Document and LibreOffice
• Problem Solving Using Safe Mode 

Module 2: Setting Up LibreOffice

• Introduction
• Choosing Options for 
  • All of LibreOffice
  • Loading and Saving Documents
• Choose Language, Settings, and Internet Options
• Control LibreOffice Autocorrect Functions

Module 3: Working with Styles and Templates

• What are Styles?
• Applying, Creating, and Modifying Styles
• Using the Style Inspector (Writer)
• What are Templates? Why Use Them?
• Create a Document from Templates
• Create and Edit a Templates
• Organising Templates

Module 4: Getting Started with Writer

• Introduction to Writer and Writer Interface
• Working with Documents and Text
• Format Text and Pages
• Create Table of Contents, Indexes, and Bibliographies
• Use Footnotes and Endnotes
• Working with Graphics and Mail Merge
• Printing and Exporting to PDF or EPUB 
• Use Fields
• Using Master Documents
• Create Fill-in-Forms

Module 5: Introduction to Calc and Impress

• Calc
• Spreadsheets, Sheets, and Cells
• Calc Main Window
• Saving, Navigating, and Selecting Items in Spreadsheets
• Importing External Data – Web Query
• Working with Columns, Rows, and Sheets
• Edit and Format Data
• Auto Formatting of Cells
• Using Themes and Conditional Formatting
• Cell Protection and Cell Comments
• Analysing Data 
• What is Impress?
• Impress Main Window
• Workspace View
• Adding Text, Pictures, Tables, Charts, and Media
• Working with Slide Masters and Styles
• Creating Photo Album and Setting Up a Slide Show

Module 6: Working with Draw

• What is Draw?
• Overview of 3D Objects, Layers, and Shapes
• Glue Points and Connectors
• Positioning and Adjusting Objects
• Insert and Edit Pictures

Module 7: Introduction to Base and Math

• Plan and Create a Database
• Create Database Tables and Form
• Creating Queries and Reports
• Creating and Editing Formulas
• Formula in Writer, Calc, Draw, and Impress

Module 8: Print, Export, E-Mail, and Sign Documents

• Control Printing
• Export to PDF and EPUB Format
• Email Documents
• Digital Signing of Documents
• Removing Personal Data 
• Redaction

Module 9: Working with Graphics and Gallery

• Add Images to Document
• Modify, Handle, and Position Graphics
• Manage LibreOffice Gallery
• Create Image Map
• Use LibreOffice Drawing Tools and Fontwork

Module 10: Introduction to HTML Files and Macros

• Relative and Absolute Hyperlinks
• Save and Export Documents as HTML Files
• Create, Edit, and Save HTML Files Using Writer or Web
• Create a Macro
• Running Macro
• Write Macros without the Recorder

Module 11: Customise LibreOffice

• Customise Menu Content and Toolbars
• Assign Shortcut Keys and Macros to Events
• Add Functionality with Extensions