Guide
Euro-Office guide
Everything about working online with documents, spreadsheets, presentations and pdfs in your WebOké Nextcloud. Explained step by step, with screenshots for every step.
Start reading
Download as pdf
Nederlands18 MB
English18 MB
Deutsch18 MB
Français18 MB
Dansk18 MB
Español18 MB
Svenska18 MB
Italiano18 MB
Polski18 MB
Português18 MB
Română18 MB
Čeština18 MB
Ελληνικά18 MB
Magyar18 MB
Slovenčina18 MB
Български18 MB
Suomi18 MB
Hrvatski18 MB
Norsk18 MB
Lietuvių18 MB
Slovenščina18 MB
Latviešu18 MB
Eesti18 MB
Contents
All chapters
Click on a topic to open the article. Each article has links to the previous and next article.
-
1
Getting acquainted
-
2
Getting started
-
3
Getting to know the editor
-
4
Text documents
- 4.1 Formatting text: font, size, colour and alignment
- 4.2 Using styles and headings
- 4.3 Creating an automatic table of contents
- 4.4 Bullets and numbering
- 4.5 Inserting and formatting tables
- 4.6 Images, shapes and text boxes
- 4.7 Headers, footers and page numbers
- 4.8 Page settings, columns and breaks
- 4.9 Footnotes, endnotes and links
- 4.10 Find and replace
- 4.11 Creating a letter or quote
- 4.12 Printing and saving as PDF
-
5
Spreadsheets
- 5.1 Working with cells, rows and columns
- 5.2 Formulas and functions: SUM, AVERAGE, IF and VLOOKUP
- 5.3 Formatting numbers, dates and currency
- 5.4 Conditional formatting
- 5.5 Sort and filter
- 5.6 Creating charts
- 5.7 Pivot tables
- 5.8 Managing sheets
- 5.9 Freezing rows and columns
- 5.10 Data validation and drop-down lists
- 5.11 Importing and exporting CSV files
-
6
Presentations
-
7
Pdf
-
8
Collaborating
-
9
Sharing
-
10
On your computer and on the go
- 10.1 Euro-Office as a program on your computer: what is it and when do you use it?
- 10.2 Downloading and installing on Windows (x64 and ARM64)
- 10.3 Downloading and installing on Mac (Apple Silicon)
- 10.4 Downloading and installing on Linux (deb and rpm)
- 10.5 Linking the program to your WebOké Nextcloud
- 10.6 Working together with colleagues in the browser and the program
- 10.7 Euro-Office in the Nextcloud app on your phone or tablet
- 10.8 Working with the Nextcloud desktop app (synchronisation)
-
11
Shortcuts and tips
-
12
Troubleshooting
-
13
For the administrator of your Nextcloud
-
14
Frequently asked questions
-
15
Advanced: questions and solutions
- 15.1 A total overview from multiple worksheets: expenses, income and balance
- 15.2 Copying formulas from Excel: English function names and the comma
- 15.3 VLOOKUP returns #N/A: here's how to fix it
- 15.4 XLOOKUP: looking up to the left and with your own message
- 15.5 Dates that come in as text or have day and month swapped
- 15.6 Keeping the leading zero in a phone number or postcode
- 15.7 Opening a CSV file with semicolons and strange characters correctly
- 15.8 Finding and removing duplicate customers
- 15.9 Colour the whole row when the invoice is paid
- 15.10 A checklist with check boxes in a spreadsheet
- 15.11 Protecting formulas in a shared spreadsheet
- 15.12 Filtering without bothering your colleagues
- 15.13 Splitting first name and surname from one column
- 15.14 Calculating working days between two dates, excluding public holidays
- 15.15 Printing a wide worksheet on one A4 page, with the header row on every page
- 15.16 Speed up a slow spreadsheet
- 15.17 Starting page numbers from page 3 onwards
- 15.18 One page in landscape within a portrait document
- 15.19 A blank page at the end that won't go away
- 15.20 Repeating the header row of a long table on every page
- 15.21 Images that jump around as you type
- 15.22 Creating letters from a recipient list
- 15.23 Seeing what's changed between two versions of a contract
- 15.24 Removing comments and changes before sending a document
- 15.25 Adding the logo to all slides at once
- 15.26 Making a presentation loop continuously (trade fair, waiting room, shop window)
- 15.27 Converting an old 4:3 presentation to widescreen 16:9
- 15.28 Making sensitive data invisible in a PDF
- 15.29 Rotating, deleting or merging PDF pages
- 15.30 An Excel file with VBA macros: what now?
- 15.31 Converting a PDF into an editable Word file
- 15.32 You don't see your changes when you download the file or open it on your computer
Also as a program on your computer
With Nextcloud Office, you work with the same documents in a program on your Windows PC, Mac or Linux computer.
To the downloads