Guide
Switching from Microsoft Office
Everything you did in Word, Excel and PowerPoint, you can also do with LibreOffice on your computer and Euro-Office in your WebOké Nextcloud. For each task, you'll read how it works in both: from a single landscape page and a table of contents to mail merge, pivot tables and pdf.
Contents
All topics
Click a topic to open the article. Each article has links to the previous and next article.
-
1
Getting started
- 1.1 Switching from Microsoft Office: LibreOffice and Euro-Office side by side
- 1.2 Word, Excel and PowerPoint: what they're called in LibreOffice and Euro-Office
- 1.3 Installing and setting up LibreOffice
- 1.4 Opening a Word or Excel file from your Nextcloud
- 1.5 Word and Excel shortcuts: what stays the same and what's different
-
2
File formats and compatibility
-
3
Text documents: tasks from Word
- 3.1 Make one page landscape in a portrait document, like in Word
- 3.2 Creating an automatic table of contents
- 3.3 Adding headers, footers and page numbers
- 3.4 Start page numbers from page 3
- 3.5 Use styles instead of manual formatting
- 3.6 Creating letters from an address list (mail merge)
- 3.7 Tracking changes and adding comments (track changes)
- 3.8 Comparing two versions of a document
- 3.9 Creating a template for your letterhead
- 3.10 Setting the spell check and language to English
-
4
Spreadsheets: tasks from Excel
- 4.1 Formulas from Excel: function names, separators and error messages
- 4.2 Vertical lookup with VLOOKUP and XLOOKUP
- 4.3 Creating a pivot table
- 4.4 Conditional formatting: colour cells automatically
- 4.5 Creating a chart
- 4.6 Freezing rows and printing a wide sheet on one page
- 4.7 Opening, splitting and saving a CSV file correctly
-
5
Presentations: tasks from PowerPoint
-
6
Pdf
-
7
Collaborating via Nextcloud