Spreadsheet with Google Sheets

Language: German

Google Sheets tutorial: Create tables, formulas and charts

Web-based, free and editable by multiple users simultaneously in real time - this is how spreadsheets work with Google Sheets. In this tutorial, you will learn all about the application, from the basics to the use of formulas and the creation of pivot tables and advanced charts. Over 4.5 hours of training from spreadsheet and cell juggler Fabio Basler - perfect for your professional skills!

The great master course on Google Sheets: from 0 to user knowledge in 61 lessons!
Introduction: Quickly find your way around the interface and functions.
Formulas, conditions and references: Master every calculation with flying colors.
Diagrams and visualizations: This is how captivating data storytelling works.
Google Sheets-specific features: Learn what other spreadsheet programs can't do.
Over 4.5 hours by Fabio Basler, with helpful fact sheets

Basics for getting started. Tricks for in-depth work. Practical tips for effective work. If you want to get to know Google Sheets in depth: Take this shortcut to your learning success!

Details

Usable with:
content: 5 h Video training
Licence: private and commercial Rights of use
Bonus: including working material

Examples of use

Open gallery

Google Sheets, from the basics to proficient use: This is your tutorial agenda.

Introduction

free of charge

Google Sheets tutorial: 1.1 Intro to the course

Welcome to the Google Sheets tutorial!

free of charge

Google Sheets tutorial: 1.2 What to expect in the course!

What to expect in the course!

Introduction to Google Sheets.

Google Sheets tutorial: 2.1 Why Google Sheets?

In this lesson, you will learn the most important reasons for using Google Sheets.

download project file

Google Sheets tutorial: 2.2 How to use Google Sheets!

In this lesson, we will open a Google account together to use Google Sheets.

Google Sheets tutorial: 2.3 The user interface in Google Sheets

We will now get to know the user interface and functionalities of the application together.

download project file

Google Sheets tutorial: 2.4 Google Sheets vs. Microsoft Excel

A comparison between Google Spreadsheets and Microsoft Excel.

The basics with Google Sheets

Google Sheets tutorial: 3.1 Save and edit file

This course unit deals with the storage and management of files.

download project file

Google Sheets tutorial: 3.2 Entering text, numbers and dates

We will now look at how we can insert data such as text, numbers or dates into cells.

download project file

Google Sheets tutorial: 3.3 Cell alignment

This course unit is about cell alignment in Google Spreadsheets.

download project file

Google Sheets tutorial: 3.4 Formatting

Furthermore, it is now about the formatting of cells. Here I will show you the most important options.

download project file

Google Sheets tutorial: 3.5 Filtering and sorting data

We now continue with the filtering of our data.

download project file

Google Sheets tutorial: 3.6 Sharing with colleagues

In this lesson, we will learn how to share our final spreadsheets with our colleagues.

download project file

Google Sheets tutorial: 3.7 Setting the language

In this unit, we will learn how to set the language of our worksheet.

download project file

Google Sheets tutorial: 3.8 Show history

Next, let's take a look at the version history of Google Sheets and learn why this is particularly helpful.

download project file

Formula calculations with Google Sheets

Google Sheets tutorial: 4.1 Data entry

In this lesson, we will learn about the most important data types in Google Spreadsheets, such as numbers, texts, strings and dates.

download project file

Google Sheets tutorial: 4.2 Your first formula!

We now come to the first formula calculation and talk about structure and syntax.

download project file

Google Sheets tutorial: 4.3 Understanding cell references

This course unit deals with absolute and relative cell references in formulas using F4.

download project file

Google Sheets tutorial: 4.4 Calculating aggregation functions

Next, we will get to know the most important aggregation functions such as mean values, sums or the range.

download project file

Google Sheets tutorial: 4.5 Functions and shortcuts

We can use special key combinations and shortcuts to speed up the use of Google Spreadsheets enormously. This will be the subject of the current lesson.

download project file

Google Sheets tutorial: 4.6 Text functions 1

Next, we will learn about important text functions such as =LEFT, =RIGHT, =PART and other important text functions.

download project file

Google Sheets tutorial: 4.7 Text functions 2

There are also other helpful text functions that we will look at in this course unit.

download project file

Google Sheets tutorial: 4.8 Reference functions

The S-reference is probably the most widely used reference function in Google Sheets. In this lesson, we will learn everything you need to know about this function.

download project file

Google Sheets tutorial: 4.9 Conditional functions

Next, we will look at simple conditional functions such as the if function and nested conditional functions.

download project file

Google Sheets tutorial: 4.10 Statistical functions

We also look at statistical functions such as mean values or scatter figures.

download project file

Best Practices

Google Sheets tutorial: 5.1 Editing rows and columns

We will now continue with the formatting of columns and rows.

download project file

Google Sheets Tutorial: 5.2 View & Layout

In this course unit, we will learn how to optimize the view and layout in our spreadsheets.

download project file

Google Sheets tutorial: 5.3 Conditional formatting of cells

This course unit is about conditional formatting of cells.

download project file

Google Sheets tutorial: 5.4 Sample templates

Next, let's take a look at ready-made sample Google Sheets.

download project file

Google Sheets tutorial: 5.5 Data validation & dropdowns

Data validation allows us to create dynamic drop-down lists in Google Sheets. Find out more in this lesson!

download project file

Google Sheets Tutorial: 5.6 Import & Export

We also look at import/export options for .xlsx files from Google Sheets to Microsoft Excel.

download project file

Data cleaning

Google Sheets tutorial: 6.1 Remove duplicates

We often have redundant data structures. We can simply remove these using the remove duplicates function.

download project file

Google Sheets tutorial: 6.2 Delete empty lines

We can remove empty rows using filter options. This is the learning objective of the lesson!

download project file

Google Sheets tutorial: 6.3 Search and replace

In this lesson, we will get to know the search-and-replace function in more detail.

download project file

Google Sheets tutorial: 6.4 Partial result filter

We also look at the =DIVIDE RESULT function and the individual key figures such as 1 for mean values or 9 for totals.

download project file

Google Sheets tutorial: 6.5 Printing workbooks

After we have created our final spreadsheets, this unit is about printing workbooks. Have fun!

download project file

Google Sheets tutorial: 6.6 Working with colleagues

We can work with our colleagues in the same document at the same time.

download project file

Google Sheets tutorial: 6.7 Google Sheets app

The Google Sheets app can also be used in the smartphone version.

Visualizations

Google Sheets tutorial: 7.1 Create visualizations

In this lesson, we will learn how to create visualizations.

download project file

Google Sheets tutorial: 7.2 Column & bar charts

Next, we will look at column and bar charts.

download project file

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

The next form of visualization are line and area diagrams.

download project file

Google Sheets tutorial: 7.4 Circle and ring charts in Excel

We are now also getting to know pie charts and ring charts for visualizing proportions and percentages.

download project file

Google Sheets tutorial: 7.5 Composite charts

Combi diagrams or compound diagrams allow us to combine two different types of visualization.

download project file

Google Sheets tutorial: 7.6 Create scatter charts

We also take a look at the so-called scatter plot or dot chart for the removal of variables within a graph.

download project file

Google Sheets tutorial: 7.7 Suitable diagram

Now that we have become familiar with many different visualizations, the next question is which type of visualization we can use and when.

download project file

Google Sheets tutorial: 7.8 Sparklines

The sparkline function allows us to display graphics within a cell.

download project file

Google Sheets tutorial: 7.9 Data slices filter

Next, we'll talk about interactive visualizations using data slices in conjunction with our charts.

download project file

Pivot analyses

Google Sheets tutorial: 8.1 Introduction to pivot tables

We will now learn why pivot tables are particularly helpful for multidimensional data analysis.

download project file

Google Sheets tutorial: 8.2 Data basis for creating pivot tables

In this course unit, we will talk about the data basis for creating our first pivot analysis.

download project file

Google Sheets tutorial: 8.3 Your first pivot table!

This lesson is about creating our first pivot table.

download project file

Google Sheets tutorial: 8.4 Visualizations with pivot tables

In this unit we will learn how to create graphics based on pivot tables.

download project file

Google Sheets tutorial: 8.5 Calculated fields

This lesson deals with the calculation of fields and formulas within pivot analyses.

download project file

Google functions

Google Sheets tutorial: 9.1 Google Finance

Google-specific functions provide us with additional functionalities that are not available in other calculation programs. This unit is about the Google Finance formula.

download project file

Google Sheets tutorial: 9.2 Image function

The image function allows us to integrate URLs and QR codes in our spreadsheets.

download project file

Google Sheets tutorial: 9.3 IMPORTHTML

Next, let's talk about the IMPORTHTML function.

download project file

Google Sheets tutorial: 9.4 IMPORTXML

Next, let's talk about the IMPORTXML function.

download project file

Advanced options

Google Sheets tutorial: 10.1 Add-on options

We have the option of integrating additional features from third-party providers via add-ons.

download project file

Google Sheets tutorial: 10.2 Shortcuts in Google Sheets

Let's take a look at the keyboard shortcuts in Google Sheets that can speed up your work with the application enormously.

download project file

Google Sheets tutorial: 10.3 Macros

We can use macros to automate iterative processes in particular.

download project file

Google Sheets tutorial: 10.4 Index comparison

This lesson is about another reference function: the index comparison.

download project file

Google Sheets tutorial: 10.5 Date functions

In this course unit we will talk about selected date functions.

download project file

Google Sheets Tutorial: 10.6 Custom Scripts

Custom Scripts is a code option for programming macros in Google Sheets.

download project file

Google Sheets tutorial: 10.7 Sheet protection

Leaf protection allows us to protect selected cell areas.

download project file

Details of the content

Edit tables, integrate formulas, create charts - your tutorial!

Get an overview with this 4.5-hour Google Sheets tutorial and then dive into topics such as pivot tables, data transformation and reference functions.

The right formula for professional data handling

From zero to user knowledge: Once you have familiarized yourself with the interface and basic functions of Google Sheets , you will gallantly glide through formatting, formulas, conditional and reference functions as well as data transformations in your tables .

In terms of visualization, you will get to know the simple charts of Google Sheets as well as the special ones. In this way, you can skillfully transform your flood of data into visualizations worth seeing. Finally, you will learn everything you need to know about special Google Sheets functions and increase the efficiency of your work with the help of shortcuts and macros.

Google Sheets: How spreadsheets work today (and tomorrow, by the way)

There are now web-based alternatives to more and more desktop applications that you can easily use via your browser. This saves storage space and computing power. This allows you to access your documents from anywhere. And above all, it makes team collaboration easier.

This also applies to the web alternative to Microsoft Excel - Google Sheets: While you are still checking and adjusting the latest figures, a colleague is already preparing the visualizations for them in the middle of the same spreadsheet. You work on exactly one version and say goodbye to a jumble of different file copies.

Such striking advantages of web applications have long since heralded an immense change in the world of work. So it's a good thing that you're adapting to them right now in order to stay fit in your job with online working skills.