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!

Google Sheets Tutorial: 5.2 View & Layout

Google Sheets tutorial: Create tables, formulas and charts

Razor-sharp Acrobat recipes: 1.28 | Create endless loop slideshow as PDF

Razor-sharp Acrobat recipes: masterfully editing PDF files

The print production tools in Acrobat

Acrobat Training - Basics & Tricks

Excel tips: 29 | Quickly format a table in a modern way

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

Google Sheets tutorial: 5.3 Conditional formatting of cells

Google Sheets tutorial: Create tables, formulas and charts

Razor-sharp Acrobat recipes: 1.29 | Quick tips for visual aids

Razor-sharp Acrobat recipes: masterfully editing PDF files

Preflight profiles in Acrobat - Overview

Acrobat Training - Basics & Tricks

Excel tips: 30 | Use calendar for date entry

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

Google Sheets tutorial: 5.4 Sample templates

Google Sheets tutorial: Create tables, formulas and charts

Define your own preflight profiles in Acrobat

Acrobat Training - Basics & Tricks

Excel tips: 31 | Quickly split a column into 4 columns using line breaks

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

Google Sheets tutorial: 5.5 Data validation & dropdowns

Google Sheets tutorial: Create tables, formulas and charts

Define user-defined checking and correction rules in Acrobat

Acrobat Training - Basics & Tricks

Excel tips: 32 | Summing values with unit of measurement

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

Google Slides tutorial: 10.1 | Create tables

Google Slides tutorial: Create and edit presentations online

Google Sheets Tutorial: 5.6 Import & Export

Google Sheets tutorial: Create tables, formulas and charts

Fixing common problems with PDF files with Acrobat

Acrobat Training - Basics & Tricks

Excel tips: 33 | Get ranking for e.g. a competition

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

Google Slides tutorial: 10.2 | Formatting tables

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 6.1 Remove duplicates

Google Sheets tutorial: Create tables, formulas and charts

Excel tips: 34 | Swap rows and columns with one click

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

Google Slides tutorial: 10.3 | Insert diagrams from Google Sheets

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 6.2 Delete empty lines

Google Sheets tutorial: Create tables, formulas and charts

Excel tips: 35 | Output random number

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

Google Slides tutorial: 10.4 | Insert schemes

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 6.3 Search and replace

Google Sheets tutorial: Create tables, formulas and charts

Excel tips: 36 | Create selection box for easier data entry

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

Google Slides tutorial: 10.5 | WordArt

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 6.4 Partial result filter

Google Sheets tutorial: Create tables, formulas and charts

Excel tips: 37 | Filtering data made easy

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

Google Slides tutorial: 11.1 | Explore to work faster

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 6.5 Printing workbooks

Google Sheets tutorial: Create tables, formulas and charts

Excel tips: 38 | Move table or individual columns quickly

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

Google Slides tutorial: 11.2 | Advanced settings

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 6.6 Working with colleagues

Google Sheets tutorial: Create tables, formulas and charts

Excel tips: 39 | Use Excel, Word, PowerPoint etc. completely free of charge

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

Google Slides tutorial: 12.1 | Preparing screen presentations

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 6.7 Google Sheets app

Google Sheets tutorial: Create tables, formulas and charts

Excel tips: 40 | Get table contents from the Internet

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

Google Slides tutorial: 12.2 | Making screen presentations

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 7.1 Create visualizations

Google Sheets tutorial: Create tables, formulas and charts

Google Slides tutorial: 13.1 | The help bar

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 7.2 Column & bar charts

Google Sheets tutorial: Create tables, formulas and charts

Google Slides tutorial: 13.2 | Keyboard shortcuts

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 7.3 Line charts and trend lines in Excel

Google Sheets tutorial: Create tables, formulas and charts

Google Slides tutorial: 14.1 | The Google Slides smartphone app

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 7.4 Circle and ring charts in Excel

Google Sheets tutorial: Create tables, formulas and charts

Google Slides tutorial: 14.2 | The Google add-ons

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 7.5 Composite charts

Google Sheets tutorial: Create tables, formulas and charts

Google Slides tutorial: 15 | Thank you for your trust

Google Slides tutorial: Create and edit presentations online

Google Sheets tutorial: 7.6 Create scatter charts

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 7.7 Suitable diagram

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 7.8 Sparklines

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 7.9 Data slices filter

Google Sheets tutorial: Create tables, formulas and charts

Google Docs tutorial: 13.1 | The Google Docs smartphone app

Google Docs tutorial: Edit documents online

Google Sheets tutorial: 8.1 Introduction to pivot tables

Google Sheets tutorial: Create tables, formulas and charts

Google Docs tutorial: 13.2 | Google add-ons

Google Docs tutorial: Edit documents online

Google Sheets tutorial: 8.2 Data basis for creating pivot tables

Google Sheets tutorial: Create tables, formulas and charts

Google Docs tutorial: 14 | Thank you for your trust

Google Docs tutorial: Edit documents online

Google Sheets tutorial: 8.3 Your first pivot table!

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 8.4 Visualizations with pivot tables

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 8.5 Calculated fields

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 9.1 Google Finance

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 9.2 Image function

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 9.3 IMPORTHTML

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 9.4 IMPORTXML

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 10.1 Add-on options

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 10.2 Shortcuts in Google Sheets

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 10.3 Macros

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 10.4 Index comparison

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 10.5 Date functions

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets Tutorial: 10.6 Custom Scripts

Google Sheets tutorial: Create tables, formulas and charts

Google Sheets tutorial: 10.7 Sheet protection

Google Sheets tutorial: Create tables, formulas and charts

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.