Course
digicode: COLO
Collabora Online & LibreOffice in Everyday Office Work: The Open-Source Alternative to Microsoft 365
Leaving Microsoft 365 without falling behind? Work with Writer, Calc, and Impress, exchange files with Word users, and run LibreOffice offline or Collabora Online in your browser – even on your own servers. One day of hands-on practice.
Duration
1 day
Price
850.–
Course documents
Digicomp courseware
Course facts
Download as PDF- Working confidently with Writer, Calc, and Impress, and finding familiar features from Word, Excel, and PowerPoint
- Opening, editing, and saving Word, Excel, and PowerPoint files without losing layout or content, and recognizing common pitfalls
- Working offline on your desktop or collaboratively in a browser with Collabora Online—including comments and sharing via the platform in use
- Determining when ODF and when DOCX, XLSX, or PPTX is the right format, as well as seamlessly exchanging documents with clients and partners
- Exporting documents as PDF and PDF/A, for example, for archiving and submission to government agencies
- Efficiently designing templates, style sheets, and mail merges
1 Getting Started and Orientation
- Why Open-Source Office: Data Sovereignty, Costs, Independence
- The Synergy: LibreOffice offline on the desktop, Collabora Online in the browser, and even on your own servers
- User Interface, Menus, and Toolbars Compared to Microsoft 365
- Hands-On Exercise: Opening Your First Documents and Customizing Views
2 Word Processing with Writer
- Formatting with Style Sheets Instead of Manually
- Table of Contents, Headers and Footers, Page Templates
- Tables, Images, and Links
- Track Changes and Comments
- Mail Merge (Demo)
- Hands-On Exercise: Revising a Report from a Word File
3 Spreadsheets with Calc
- Formulas and Functions: Similarities and Differences from Excel
- Sorting, Filtering, and Analyzing Data
- Pivot Tables (Demo) and Charts
- Conditional Formatting and Data Validation
- Hands-On Exercise: Continuing an Existing Excel Analysis
4 Presentations with Impress
- Slide Masters and Layouts
- Graphics, Charts, and Simple Drawings
- Importing and Reviewing PowerPoint Presentations
- Hands-On Exercise: Revising a Presentation and Exporting It as a PDF
5 Compatibility in Everyday Use
- ODF and OOXML: Which Format to Use When?
- Common Issues: Fonts, Layout, Special Features, Macros (VBA Works Only Partially)
- Check documents before sending; use PDF/A for archiving and government agencies
- Collaborating with Microsoft 365 users: Rules and tips
- Hands-on exercise: Sending documents back and forth and identifying discrepancies
6 Collaborating in the Browser with Collabora Online
- Opening and Editing Documents in the Browser
- Real-Time Collaborative Editing, Comments, and Versions
- Sharing and External Partners via the Platform in Use (e.g., Nextcloud)
- Feature Set: What Browsers and Desktops Do Best
- Hands-On Exercise: Creating and Revising a Document Together
7 Transition and Wrap-Up
- Transition plan for your daily work routine: What comes first, what comes later?
- Using Help, Documentation, and the Community
- Open Questions and Practical Examples from Participants
- Handouts: Transition Checklist and Keyboard Shortcut Overview
The course is hands-on: brief presentations alternate with exercises using your own documents or those provided. You’ll work directly in LibreOffice and Collabora Online, allowing you to experience the differences from Microsoft Office firsthand. A large portion of the time is devoted to your exercises. There’s plenty of room to address questions related to your day-to-day work.
- Office and administrative staff who will or want to work with LibreOffice and Collabora Online
- Specialists and teams who collaborate on documents with Microsoft users
- Users in organizations that are switching to open-source office software
You have taken the following course or have similar knowledge: Microsoft Office 365 Basics