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

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

Summary and Next Steps

Requirements

  • Experience with desktop productivity applications

Audience

  • IT teams
 14 Hours

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Upcoming Courses

Related Courses

LibreOffice

 21 Hours

This instructor-led, live training in the US (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.
Read more...

LibreOffice Calc for Data Analysis

 14 Hours

This instructor-led, live training in the US (online or onsite) is aimed at data analysts who wish to use LibreOffice Calc to conduct many forms of data analysis (from basic to advanced), leveraging similar functionalities found in Excel and other spreadsheet software.

By the end of this training, participants will be able to:

  • Install the LibreOffice suite on any operating system.
  • Understand the full features and functionalities available in LibreOffice Calc.
  • Learn how to clean, validate, manipulate, and visualize data in Calc.
  • Apply the various functions and tools in Calc to perform complex data analysis.
  • Gain some tips and insights on conducting advanced data analysis.
Read more...