White icon for the Office tutorials category
Office courses
Complete your tasks quickly and safely
Complete your tasks quickly and safely

Office courses: in-depth knowledge of Word, Google Sheets, Excel & Co.

A helpful tip for your work with Word, time-saving shortcuts for Excel and Google Sheets and then getting into data management with Access? Our courses on the most important Office programs offer you all this and more. Whether you want to get into Word, Excel, Access, PowerPoint or manage your emails even better with Outlook and GMail - we'll show you how to make your office work even more effective . You'll be able to create your next presentation, documents and spreadsheets in no time at all!

Design Thinking: 3.10 | Product description

Design thinking: a method for ideas and solutions (video training)

Google Slides tutorial: 3.1 | Add sections

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 3.2 Entering text, numbers and dates

Google Sheets tutorial: Create tables, formulas and charts

Creating diagrams in Excel: 4.10 | HeatMap visualization

Create Excel charts and visualize data - the complete course

Create charts in Excel: 5.10 | 2D Map World

Create Excel charts and visualize data - the complete course

Pivot tables in Excel: 2.10 | Solution Exercise 1

Creating and formatting pivot tables in Excel: from analysis to dashboards

Pivot tables in Excel: 3.10 | Solution Exercise 2

Creating and formatting pivot tables in Excel: from analysis to dashboards

Statistics with Excel: 2.10 Chi-square fit test for normal distribution in Excel

Statistics with Excel - learn and practice in practice

Smart performance: 12.10 What do your Heroes actually do for their success?

Mindset training smart performance - your goals, your life!

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.10 Fractions in Excel

Excel tutorial: Pivot, charts and table design for clear data presentation

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.10 Excel table on a single page

Excel tutorial: Pivot, charts and table design for clear data presentation

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.10 Calculate mean value

Excel tutorial: Pivot, charts and table design for clear data presentation

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.10 Color code formatting of cells

Excel course for controlling and sales: assortment list, units, currency & Co

Excel course for controlling and sales: Assortment list, units, currency, etc. - 4.10 REFERENCE or INDEX/ COMPARISON

Excel course for controlling and sales: assortment list, units, currency & Co

Excel training for more efficiency in the office: Calendar, organization chart & Co - 2.10 Repairing a defective workbook

Excel training for more efficiency in the office: calendar, organization chart & Co

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.10 Convert hours into minutes

Excel training for more efficiency in the office: calendar, organization chart & Co

Excel training for more efficiency in the office: calendar, organization chart & co - 4.10 Integrating Excel tables into Word documents

Excel training for more efficiency in the office: calendar, organization chart & Co

Understanding and setting up OpenVPN - secure in the network: 2.10 OpenVPN compatibility

Understanding and setting up OpenVPN - secure in the network

Understanding and setting up OpenVPN - secure in the network: 5.10 Client configuration

Understanding and setting up OpenVPN - secure in the network

Better in Access: Become a data hero - 6.10 How many zip codes does a city have?

Access course: Learn the basics & create a database - become a data pro!

Better in Access: Become a data hero - 9.10 Include subforms

Access course: Learn the basics & create a database - become a data pro!

Linux for beginners - 5.10 Clearing the screen with clear and exiting the current session

Linux tutorial for beginners: Learn the basics & set up Ubuntu

Linux for beginners - 6.10 Copying files securely over the network with SSH and FTP

Linux tutorial for beginners: Learn the basics & set up Ubuntu

Better in Word - 20 bookmarks, links & cross-references

Word course for beginners: Learn the basics from A to Z

Better in Word - encrypt 54 documents with a password

Word course for beginners: Learn the basics from A to Z

Better in Outlook: Become an Office hero - 13 Create an email template for recurring emails

Outlook course: e-mail & time management with a system

Razor-sharp Acrobat recipes: 1.10 | Convert tons of files to PDF with just a few clicks

Razor-sharp Acrobat recipes: masterfully editing PDF files

More productive in Google Mail - The best tricks - 10 newsletters to get rid of faster/send when it suits me

More productive in Google Mail - The best shortcuts, tricks and help

Prezi for beginners - Presentations that inspire - 2.10 Summary

Creating Prezi presentations - practical tutorial

Prezi for beginners - presentations that inspire - 4.10 Prezi in practice

Creating Prezi presentations - practical tutorial

PDF portfolios with Acrobat - Part 1

Acrobat Training - Basics & Tricks

Excel tips: 11 | Cleverly automatically insert a blank row every second row

Excel: Tips & tricks - 40 ingenious best-of hacks for effective working

Microsoft Copilot: 4.11 | Copilot in Microsoft Excel: Many possibilities

Microsoft Copilot (video training) - working more effectively with AI

PowerPoint course: 10.11 | Special case: Changing page numbers with "flags" in the design

PowerPoint course: Basics & expert tips for convincing presentations

PowerPoint course: 12.11 | Exercise Animations (Part 3), Top Hack: Change objects without losing the animation

PowerPoint course: Basics & expert tips for convincing presentations

AI for texts: 13 | Otter - Record online meetings with text using this tool!

AI guide: Have texts written with ChatGPT & 12 alternative tools

ChatGPT training: 10 | The best tips and tricks for using ChatGPT & alternatives

ChatGPT: What AI can do - how it can help you with texts, codes, SEO and Excel

Microsoft OneNote: 1.11 | Using the search function

Microsoft OneNote (Tutorial): How to keep track of everything with the digital notebook

MS Project-Tutorial: 7.11 | Print project

MS Project (Tutorial): Planning, controlling and monitoring projects

Design Thinking: 3.11 | Step 6: Testing

Design thinking: a method for ideas and solutions (video training)

Google Slides tutorial: 3.2 | Edit master slides - placeholders

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 3.3 Cell alignment

Google Sheets tutorial: Create tables, formulas and charts

Create charts in Excel: 4.11 | Dynamic progress bar

Create Excel charts and visualize data - the complete course

Create charts in Excel: 5.11 | Dynamic world map

Create Excel charts and visualize data - the complete course

Smart performance: 12.11 Let go

Mindset training smart performance - your goals, your life!

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.11 Swapping columns and rows

Excel tutorial: Pivot, charts and table design for clear data presentation

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.11 Hide error messages when printing

Excel tutorial: Pivot, charts and table design for clear data presentation

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.11 Important Excel macros for everyday use

Excel tutorial: Pivot, charts and table design for clear data presentation

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.11 Converting units of measurement

Excel course for controlling and sales: assortment list, units, currency & Co

Excel course for controlling and sales: Assortment list, units, currency, etc. - 4.11 Extending the SVERWEIS search function

Excel course for controlling and sales: assortment list, units, currency & Co

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.11 Calculate negative hours and minutes correctly

Excel training for more efficiency in the office: calendar, organization chart & Co

Excel training for more efficiency in the office: Calendar, organization chart & Co - 4.11 Inserting an interactive search field into the worksheet

Excel training for more efficiency in the office: calendar, organization chart & Co

Understanding and setting up OpenVPN - secure in the network: 5.11 Client configuration: Create OVPN file

Understanding and setting up OpenVPN - secure in the network

Better in Access: Become a data hero - 9.11 Task: Create customer list with booked seats

Access course: Learn the basics & create a database - become a data pro!

Better in Word - 21 Comment: additional notes for your document

Word course for beginners: Learn the basics from A to Z

Better in Outlook: Become an office hero - 14 rules for managing emails

Outlook course: e-mail & time management with a system

Razor-sharp Acrobat recipes: 1.11 | Edit/replace images afterwards

Razor-sharp Acrobat recipes: masterfully editing PDF files

More productive in Google Mail - The best tricks - 11 Manage/collection of other email addresses

More productive in Google Mail - The best shortcuts, tricks and help

Prezi for beginners - presentations that inspire - 4.11 Summary

Creating Prezi presentations - practical tutorial

PDF portfolios with Acrobat - Part 2

Acrobat Training - Basics & Tricks

Excel tips: 12 | Filter data better

Excel: Tips & tricks - 40 ingenious best-of hacks for effective working

Microsoft Copilot: 4.12 | GitHub Copilot: The AI solution for programmers

Microsoft Copilot (video training) - working more effectively with AI

AI for texts: 14 | Supermeme - a bit of fun is a must!

AI guide: Have texts written with ChatGPT & 12 alternative tools

ChatGPT training: 11 | A few critical words about ChatGPT

ChatGPT: What AI can do - how it can help you with texts, codes, SEO and Excel

MS Project-Tutorial: 7.12 | Shortcuts

MS Project (Tutorial): Planning, controlling and monitoring projects

Google Slides tutorial: 3.3 | Slide options

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 3.4 Formatting

Google Sheets tutorial: Create tables, formulas and charts

Create charts in Excel: 4.12 | Dynamic status display

Create Excel charts and visualize data - the complete course

Create charts in Excel: 5.12 | Bing Maps

Create Excel charts and visualize data - the complete course

Smart performance: 12.12 Get out of your comfort zone

Mindset training smart performance - your goals, your life!

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.12 Database mask in Excel

Excel tutorial: Pivot, charts and table design for clear data presentation

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.12 Format codes in headers and footers

Excel tutorial: Pivot, charts and table design for clear data presentation

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.12 Formatting currencies left- and right-aligned

Excel course for controlling and sales: assortment list, units, currency & Co

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.12 Useful birthday list

Excel training for more efficiency in the office: calendar, organization chart & Co

Better in Word - 22 headers and footers

Word course for beginners: Learn the basics from A to Z

Better in Outlook: Become an Office hero - 15 Create and delete a search folder

Outlook course: e-mail & time management with a system

Razor-sharp Acrobat recipes: 1.12 | Output the same form fields several times in different places

Razor-sharp Acrobat recipes: masterfully editing PDF files

More productive in Google Mail - The best tricks - 12 signatures for every email address on file

More productive in Google Mail - The best shortcuts, tricks and help

Enriching PDF files with Acrobat - Part 1

Acrobat Training - Basics & Tricks

Excel tips: 13 | Fill data automatically

Excel: Tips & tricks - 40 ingenious best-of hacks for effective working

Microsoft Copilot: 4.13 | Conclusion and a small work task

Microsoft Copilot (video training) - working more effectively with AI

AI for texts: 15 | Notion - the organization savior

AI guide: Have texts written with ChatGPT & 12 alternative tools

ChatGPT Training: 12 | New functions in ChatGPT-4 - Part 1

ChatGPT: What AI can do - how it can help you with texts, codes, SEO and Excel

Google Slides tutorial: 4.1 | Presentation notes

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 3.5 Filtering and sorting data

Google Sheets tutorial: Create tables, formulas and charts

Create charts in Excel: 4.13 | Sunburst charts

Create Excel charts and visualize data - the complete course

Create charts in Excel: 5.13 | 3D Map (Power Map)

Create Excel charts and visualize data - the complete course

Smart performance: 12.13 Find your influencers

Mindset training smart performance - your goals, your life!

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.13 Help for formulas

Excel tutorial: Pivot, charts and table design for clear data presentation

Better in Word - 23 text fields, quick blocks, WordArt and initials

Word course for beginners: Learn the basics from A to Z

Better in Outlook: Become an Office hero - add and use 16 contacts

Outlook course: e-mail & time management with a system

Razor-sharp Acrobat recipes: 1.13 | Activate special keyboard shortcuts

Razor-sharp Acrobat recipes: masterfully editing PDF files

More productive in Google Mail - The best tricks - 13 ways to skillfully remove text formatting + insert photos better

More productive in Google Mail - The best shortcuts, tricks and help

Enriching PDF files with Acrobat - Part 2

Acrobat Training - Basics & Tricks

Excel tips: 14 | Remove numbers after the decimal point

Excel: Tips & tricks - 40 ingenious best-of hacks for effective working

AI for texts: 16 | Perplexity - like ChatGPT, only with sources!

AI guide: Have texts written with ChatGPT & 12 alternative tools

Google Slides tutorial: 4.2 | Ask participants questions during the presentation

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 3.6 Sharing with colleagues

Google Sheets tutorial: Create tables, formulas and charts

Creating diagrams in Excel: 4.14 | Point XY diagrams and network diagrams

Create Excel charts and visualize data - the complete course

Smart performance: 12.14 Ask and learn

Mindset training smart performance - your goals, your life!

Effective in the office

Online courses and templates

Video training for faster processes

Learn online and integrate directly into your own workflow

Office programs have become an integral part of our everyday working lives. From receptionists to financial advisors to lawyers - for business letters, calculations and, above all, for the internal organization of every company, the proficient use of Office programs is part of the basic equipment. No matter what you want to use them for or how familiar you are with the individual programs: with our courses on Word, Excel & Co. you will acquire sound knowledge and will master your everyday office life with ease in the future.

Increase your work efficiency and improve your workflow

There are many ways to reach your goal. Be clever, take the shortest one. Microsoft Excel in particular offers countless functions and methods that allow you to perform complicated calculations or create statistics in just a few seconds. Invest a few hours in your Office course now and save days of time later that you would have to spend without these smart tricks to achieve the desired results. Word processing, spreadsheets, presentations - integrate the tricks you learn into your everyday work and increase your efficiency.

Design templates for business

All-round packages for start-ups: smart tutorials and powerful design templates

Also worth a look, especially for all those who want to start or optimize their own business: Our courses and assets related to marketing. For example, learn how to improve your company's visibility on Google. Or use our templates for business cards and stationery to make your day-to-day work easier . So you can concentrate on the really important things.