Excel basics - introduction for beginners

Welcome to the course and an overview of the individual topics. Find out what else awaits you in this course and what you need to be prepared for.

Here I will give you an overview of what is possible with Excel and what it is usually used for.

Now we will get to know the Excel interface so that we are prepared for the later lessons.

Let's learn how to save and open Excel files and how important it is to back up your files regularly.

A brief explanation of how zoom mode works! Now you no longer need to strain your eyes!

A4:B4, C3, AZ64? Don't understand a thing? Not with me, I'll show you what it's all about!

Cells are not just for numbers! Now let's experiment a little - let's combine texts with numbers!

Here you will learn what cells are all about, which ones display "######" and how cells can be connected to each other.

Copy and paste is a thing of the past! Now we let our cells fill in automatically!

Do you often have to write the same group or list over and over again? Don't stress yourself out and use your own fill-in lists in Excel! I'll show you how to do it!

"01.01.2016", "01 January 16" or "2016/01/01"? Excel offers great options for displaying the time and date as you wish.

In Excel, almost everything revolves around references - references here, references there - but what are references? Let's get into the mindset of Excel and learn to think like a computer!

Don't have a calculator? Never mind, Excel will do it for you!

Excel has its own way of thinking. Here we take the first steps on "How does Excel think?" and "Why does Excel do it this way?"

Calculating percentages with Excel? No problem! But watch out - there are a few pitfalls!

We switch our Excel sheet to the formula view. This allows us to find errors more quickly!

In addition to the relative cell references, there are also absolute cell references. I will show you the differences here very simply.

Let's play a little with relative and absolute cell references! We now need both mixed in a single Excel sheet! Unbelievable, but true!

We have now got to know normal covers. Now it's time to move into the third dimension with 3D covers. Learn how to link references across other sheets.

Another way to get data into Excel is to import it from other Excel files. Here I show you how to work with several Excel files.

New rows or columns can also be inserted in the middle. True to the motto "in the middle instead of just there".

Is the column in the wrong place? Or the row is too high up? No problem! Here I'll show you how to move and copy columns and rows.

Too confusing? Then simply hide rows or columns that you don't need! I'll show you why you should do this and how to do it here.

To get a better overview in Excel, there are the group and outline functions in Excel. After all, you don't always need everything you see in a file, but perhaps you want a clearer overview.

Now let's take a look at how we can make the content of the cells more attractive. We use different fonts and different text sizes in different cells.

To make our Excel document a little clearer, we will put a cell frame around some of the cells.

Cells don't have to be monotonous! We give our cells a beautiful, colorful coat of paint!

Each cell has its own formatting. Let's go through some formatting together and marvel at the differences.

You can do lots of great things with conditional formatting! Here you will learn how to use it and what you can do with it.

You can use SVERWEIS to search through tables and output specific values. Learn how to filter out specific invoice numbers from a long posting list, for example.

In this example, we follow the previous lesson, with the difference that we can create a dynamic VLOOKUP thanks to the COMPARE function.

Let's put our Excel spreadsheet on paper! There are still a few things to consider here! Before we get started, I'll show you the tricks you need!