Better in Excel: become a spreadsheet hero

Language: German

Excel basics - introduction for beginners

Excel instead of chaos and confusion! In this three-hour introduction, you will learn the basics of Excel. Perfect for beginners - add much sought-after software skills to your CV. Use cells, tables, references and formatting to tame your flood of numbers and information.

32 lessons in a three-hour introduction to using Microsoft Excel
All the important Excel basics: lists, references, formatting, formulas, calculations
Use the program's shortcuts to work efficiently and save time right from the start
A practical course, perfect for beginners: collecting, analyzing and visualizing data
From IT professional René Fürst, who turns mere information into informative aha moments

Whether it's a simple inventory list or a complex world of numbers - with Excel you can find your way out of any data labyrinth! Get the formula for your personal success and enter numbers and texts to gain clarity!

Details

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

Examples of use

Open gallery

Learn the basics of Excel in a comprehensive introduction.

Course introduction

free of charge

Excel Basics - Introduction for Beginners: 01 Welcome

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.

download project file

Excel basics - introduction for beginners: 02 What can Excel do?

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

Basics

Excel basics - Introduction for beginners: 03 The user interface

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

Excel basics - introduction for beginners: 04 Files: Create, save and auto-recover

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

Excel basics - Introduction for beginners: 05 Customize zoom mode

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

Excel basics - Introduction for beginners: 06 Cell determination

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

Excel basics - Introduction for beginners: 07 Cell entries

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

Excel basics - Introduction for beginners: 08 Customizing and connecting cells

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

Excel basics - introduction for beginners: 09 Automatic fill-in

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

Excel basics - introduction for beginners: 10 Create your own fill-in lists

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!

Excel basics - introduction for beginners: 11 The date and time trick

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

Calculating with Excel

Excel basics - Introduction for beginners: 12 What are references? (relative cell references)

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!

Excel Basics - Introduction for Beginners: 13 Calculators

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

Excel basics - Introduction for beginners: 14 How does Excel think about references? Copy formula by dragging!

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?"

Excel basics - Introduction for beginners: 15 Percentage calculation

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

Excel basics - introduction for beginners: 16 formulas to look at

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

Excel basics - introduction for beginners: 17 Absolute cell references

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

Excel basics - introduction for beginners: 18 Working with relative and absolute cell references

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

Excel basics - introduction for beginners: 19 Working with 3D references in multiple sheets

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.

Excel basics - introduction for beginners: 20 linking references from other Excel files

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.

Formatting: Lines and columns

Excel basics - introduction for beginners: 21 Inserting and deleting rows and columns

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

Excel basics - introduction for beginners: 22 Moving and copying rows and columns

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.

Excel basics - introduction for beginners: 23 Showing and hiding rows and columns

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.

Excel basics - introduction for beginners: 24 Grouping and structuring with partial results

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.

Formatting: Cells and Appearance

Excel basics - Introduction for beginners: 25 Formatting cells: Fonts and font sizes

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.

Excel basics - Introduction for beginners: 26 Formatting cells: Borders

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

Excel basics - introduction for beginners: 27 Formatting cells: filling in and highlighting in color

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

Excel basics - introduction for beginners: 28 Text, number and date formatting

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

Excel basics - introduction for beginners: 29 Conditional formatting: green, red, checkmark

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.

VLOOKUP: Search and Retrieve

Excel Basics - Introduction for Beginners: 30 SVERWEIS: Basics

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.

Excel basics - introduction for beginners: 31 SEQUENCE with COMPARE, the dynamic search

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

Bonus

Excel Basics - Introduction for Beginners: 32 Printing with Excel: Tips & Tricks

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!

Details of the content

All the important Excel basics in one introduction

The Excel office program offers almost endless functions for presenting data clearly and graphically. A structure that not only keeps things tidy in your private life, but also at work. So it's no wonder that many companies rely on the popular Microsoft software. Anyone who masters spreadsheets delivers excellent performance in the Office! This introduction will take you straight from beginner to user !

Excel basics plus tips and tricks for beginners

Despite its scope, Excel is easy to learn and use! Once you have understood how the program "thinks", the rest is effortless. With this introduction to Excel , René Fürst opens the door to cells, rows and columns so that you can learn all the important basics in a short space of time. The whole thing is garnished with tips and tricks from an experienced Excel user so that you can use the software efficiently! Incidentally, the introduction is also ideal for preparing for the ECDL exam. Become a spreadsheet and formula pro!

With this introduction, you'll have your data under control!

A step-by-step introduction for beginners by IT professional René Fürst: At the end of the training, you will be able to navigate confidently through the tables, create lists, maintain databases, work with formulas and cell references and be able to use formatting to highlight the relevant from the less important.

Learn how Excel thinks and how to think like Excel by understanding the concept of cells and formulas and linking them together with relative, absolute and conditional references! Speed up your work with automatic functions and find exactly the information you are looking for quickly and easily, even in thousands of entries and tables! Finally, you can mark your results with font, color and borders to make them even clearer.

An important aspect of basic training

Use the shortcuts and tricks in Excel to save time right from the start! Did you know, for example, that you can show and hide, copy or move entire rows and columns with just a few clicks? That you don't necessarily have to store data in a single file, but can also create three-dimensional links across files? Or that you can easily use Excel as a calculator? In the introduction, you will learn how all the formulas and tables work!

What's next for you

Your journey doesn't end after the basics. Become even more adept at working with Excel and improve your efficiency with these advanced training courses, for example:

What you will learn in the Excel introduction

In the introduction, you will learn the basics of Excel, numerous professional tips and tricks and how to use the program efficiently right from the start. This will give you skills that you can use in both your private and professional life. Excel skills for your CV!