Google Sheets tutorial: Create tables, formulas and charts

Welcome to the Google Sheets tutorial!

What to expect in the course!

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

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

A comparison between Google Spreadsheets and Microsoft Excel.

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

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

This course unit is about cell alignment in Google Spreadsheets.

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

We now continue with the filtering of our data.

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

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

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

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

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

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

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

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.

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

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

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.

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

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

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

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

This course unit is about conditional formatting of cells.

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

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

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

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

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

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

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

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

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

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

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

Next, we will look at column and bar charts.

The next form of visualization are line and area diagrams.

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

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

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

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

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

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

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

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

This lesson is about creating our first pivot table.

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

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

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

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

Next, let's talk about the IMPORTHTML function.

Next, let's talk about the IMPORTXML function.

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

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

We can use macros to automate iterative processes in particular.

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

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

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

Leaf protection allows us to protect selected cell areas.