Excel basics - introduction for beginners
- 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!
32 Videos, 193 minutes
Course introduction
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.
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.
Excel basics - introduction for beginners: 04 Files: Create, save and auto-recover
6 min OpenCalculating 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.
Excel basics - Introduction for beginners: 12 What are references? (relative cell references)
7 min OpenExcel basics - Introduction for beginners: 14 How does Excel think about references? Copy formula by dragging!
7 min OpenExcel basics - introduction for beginners: 18 Working with relative and absolute cell references
8 min OpenExcel basics - introduction for beginners: 19 Working with 3D references in multiple sheets
5 min OpenExcel basics - introduction for beginners: 20 linking references from other Excel files
8 min OpenFormatting: Rows 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.
Excel basics - introduction for beginners: 21 Inserting and deleting rows and columns
7 min OpenExcel basics - introduction for beginners: 22 Moving and copying rows and columns
6 min OpenExcel basics - introduction for beginners: 23 Showing and hiding rows and columns
3 min OpenExcel basics - introduction for beginners: 24 Grouping and structuring with partial results
7 min OpenFormatting: 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.
Excel basics - Introduction for beginners: 25 Formatting cells: Fonts and font sizes
4 min OpenExcel basics - introduction for beginners: 27 Formatting cells: filling in and highlighting in color
6 min OpenExcel basics - introduction for beginners: 29 Conditional formatting: green, red, checkmark
9 min OpenVLOOKUP: Search and Output
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!
Excel Basics - Introduction for Beginners: 32 Printing with Excel: Tips & Tricks
8 min OpenExamples of use
-
Learn the basics of Excel in a comprehensive introduction.
You might also like
This saves you time and effort!
Create, set up & optimize online advertising
Faster results in your tables
With flyer, business card & Co.
Comment now „Excel basics - introduction for beginners“