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
📌 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