Overview
LibreOffice (formerly known as OpenOffice and StarOffice) is a free and open-source set of desktop productivity applications. LibreOffice provides feature-rich tools and a user-friendly interface to enhance creativity and productivity in organizations.
This instructor-led, live training (online or onsite) is aimed at IT teams who wish to install, migrate, and use LibreOffice features and applications in their organizations.
By the end of this training, participants will be able to:
- Install LibreOffice applications to help teams be more productive.
- Create a migration plan to move enterprise documents from MS Office to LibreOffice.
- Learn LibreOffice components to process text, build spreadsheets, create presentations, and draw vector graphics.
- Develop macros and extensions to improve usage and productivity.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Requirements
- Experience with desktop productivity applications
Audience
- IT teams
Course Outline
Introduction
Overview of LibreOffice Features
- Components
- Extensions and add-ons
- User interface and options
Getting Started with LibreOffice
- Setting up LibreOffice
- Parts of the main window
- Document actions
- Using styles and templates
Migrating from MS Office for Organizations
- LibreOffice migration protocol
- Communicating the change
- Analysis and impact test
- Providing training and support
- Deployment steps
Word Processing with LibreOffice Writer
- Setting up and working with text
- Working with styles, graphics, tables, and templates
- Using mail merge
- Creating tables of contents, indexes, bibliographies
- Working with fields and forms
- Customizing Writer
Building Spreadsheets with LibreOffice Calc
- Entering, editing, and formatting data
- Charts, graphs, and images
- Formulas and functions
- Using DataPilot
- Data analysis tools
- Sharing documents
- Data linking and macros with Calc
- Customizing Calc
Creating Presentations with LibreOffice Impress
- Using slide masters, styles, and templates
- Adding text and pictures
- Managing graphic objects
- Inserting spreadsheets, charts, and other objects
- Working with slides, notes, and handouts
- Slide shows
- Customizing Impress
Making Graphics with LibreOffice Draw
- Drawing basic shapes
- Working with object and object points
- Object attributes
- Combining multiple objects
- Editing pictures
- 3D objects
- Creating charts and diagrams
- Advanced draw techniques
Managing Databases with LibreOffice Base
- Planning and creating a database
- Creating database tables
- Defining relationships
- Database forms
- Working with other data sources
- Creating queries
- Creating reports
Developing LibreOffice Macros and Extensions
- Adding, creating, and running macros
- Editing the macro
- Macro recorder
- Organizing macros
- Various ways to run macros
- Developing extensions
- Supported programming languages
Exploring Other LibreOffice Components and Features
- LibreOffice Math
- Printing, exporting, and emailing
- Graphics, gallery, and fontwork
- Creating web pages
Supporting End Users
- LibreOffice online community
- Training and certification
- Feedback
- Documentation
Troubleshooting
Summary and Conclusion