EL389
Essential knowledge

ONLYOFFICE: Document, Folder and Presentation

Master ONLYOFFICE to create documents, analyze data, and collaborate efficiently

Switching to ONLYOFFICE or deepening your use of it might seem simple—until you discover the nuances of formatting, pivot tables, or collaborative editing. This training covers the suite’s three main applications: word processing, spreadsheets, and presentation software. Plus, it includes collaborative editing features for a complete mastery of the tool in a modern work environment.

Is it for you ?

Any user wishing to learn how to use the Document, Filing and Presentation applications in the ONLYOFFICE office suite.

Prerequisites

No knowledge of ONLYOFFICE is required.

What You'll Walk Away With

  • Use the three main ONLYOFFICE applications effectively on a daily basis
  • Master advanced features: pivot tables, formulas, animations, and styles
  • Collaborate in real-time on shared documents with the right habits

Training content

1 The ONLYOFFICE office suite

  • Launch ONLYOFFICE and familiarize yourself with the environment
  • Managing files
  • Presentation of side panels
  • Define ONLYOFFICE settings
  • Protecting files by password or signature

2 ONLYOFFICE Document

  • Overview of the ONLYOFFICE Document environment
  • Editing, selecting and formatting text
  • Paragraph formatting
  • Apply bullets and numbers
  • Insert and manage images in text
  • Insert tables in text
  • Modify and format a table
  • Manage table size
  • Apply, modify and create styles
  • Number headings and display outline
  • Insert and modify a table of contents
  • Add footnotes or endnotes
  • Arrange text in columns and display a letterhead
  • Layout and print a document
  • Create headers and footers
  • Layout using sections
  • Add comments
  • Use track changes

3 ONLYOFFICE Binder

  • Overview of the ONLYOFFICE Spreadsheet environment
  • Enter and modify cell contents
  • Manage workbook sheets
  • Manage workbook rows and columns and use Plan mode
  • Copy, move and use special pasting
  • Format data and cell borders
  • Apply a numerical format
  • Apply a format and perform calculations on dates
  • Apply a conditional format
  • Apply a table model
  • Perform and copy simple calculations
  • Use simple calculation functions and the Function Wizard
  • Recopy a formula with an absolute reference
  • Name a cell or cell range
  • Freeze rows and/or columns in a workbook
  • Filter and sort data
  • Use data validation
  • Delete duplicates
  • Import data in CSV format and convert data
  • Layout and print a workbook
  • Creating workbook headers and footers
  • Repeat titles and use the print area
  • Create a pivot table
  • Add calculations to a pivot table
  • Filter and sort a pivot table and add a segment
  • Add subtotals and group rows or columns in a pivot table
  • Display totals and format a pivot table
  • Create a chart
  • Modify a line chart
  • Modify a histogram or pie chart

4 ONLYOFFICE Presentation

  • Overview of the ONLYOFFICE Presentation environment
  • Formatting slides with themes and layouts (version 8.1)
  • Using slide masks and page layouts (version 8.1)
  • Managing slides
  • Adding and formatting text in a slide
  • Adding and managing drawing shapes in a slide
  • Add and modify a table in a slide
  • Add images, video and sound to a slide
  • Adding and editing SmartArt graphics on a slide
  • Adding a graphic to a slide
  • Adding hypertext links
  • Adding transitions
  • Add animations
  • Launch slideshow and add notes
  • Print and protect your presentation

5 Collaborative publishing

  • Principles of collaborative editing with ONLYOFFICE
  • Use Strict mode and exchange comments on a workbook
  • Exchanging comments on a text document and using Review mode
  • Exchanging comments on a presentation

6 Book

This module lets you consult a digital course aid:

  • ONLYOFFICE 8 - Document, Workbook, Presentation
See more

📌 Practical information

100% online training. Accessible anytime from anywhere for one year. If you have any questions about registration, the language of instruction, or the cancellation terms, please consult our FAQ

Trainers

Upcoming information
Duration
10.0 hours
Regular fee
$250
Private or personalized training

Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.

Request a quote

Request in-company training

Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.

Tell us more
Added to cart View my cart