Excel Tutorial: Data presentation

Language: German

Excel tutorial: Pivot, charts and table design for clear data presentation

Turn Excel tables into clear visualizations. The result: Your analyses are easier to handle because you can read relevant information more easily. Third parties will also find their way around more quickly thanks to your skillful presentation using clear chart and table designs. René Fürst shows you how to use conditional formatting or pivot tables, for example, in this three-hour tutorial on Excel.

Over 3-hour Excel tutorial for the clear and informative preparation of data
Pivot table in Excel: How to keep an overview at all times, even with large amounts of data
Table design: Use functions such as conditional formatting for a better overview
Excel presentation: Create, for example, a traffic light that switches at different values
Excel charts: How to set up an informative speedometer chart, among other things
Many more tips and tricks for working efficiently with Microsoft Excel

All your data can be so beautifully presented and therefore even more informative! Give your tables a design boost with this Excel tutorial - for a better overview and clarity.

Details

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

Intro

free of charge

Excel tutorial: Pivot, charts and table design for clear data presentation - 1 intro

Welcome to the Excel tutorial! Find out briefly and concisely what you can expect here.

download project file

Analysis and data overview

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.1 Times with the numeric keypad

How you can still enter times in the numeric keypad, despite the missing colon.

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.2 Evaluating specific cells

Totalize every second or any other line

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.3 Copying formulas automatically

Copying and using a formula

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.4 Mixing text, data and formulas in a cell

Combining different formatting in one cell

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.5 Displaying formulas

Identify cells where there are no fixed values but formulas

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.6 Worksheet in a new Excel file

Copying and moving worksheets to another Excel file

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.7 Day of the week in conditional formatting

Division of a schedule using weekdays with conditional formatting

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.8 Managing conditional formatting

Get an overview of the different conditional formatting of a worksheet

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.9 Highlighting filled cells

We use conditional formatting to select all cells that contain values.

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.10 Fractions in Excel

Calculate and correctly display fractions in Excel

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.11 Swapping columns and rows

Get to know the "Transpose" insertion option.

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.12 Database mask in Excel

Entering data in tables using the mask

Excel tutorial: Pivot, charts and table design for clear data presentation - 2.13 Help for formulas

How to enter formulas using the help function

Presentation and printing

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.1 Coloring every second row

How to highlight every second row in Excel in color

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.2 Create slanted headings

How to create a heading in an Excel spreadsheet and format it

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.3 Sparklines in Excel

Use sparklines for the graphical evaluation of data.

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.4 Tachograph chart in Excel

Display numbers in a special form with the tachodiagram

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.5 Customizing Excel tables visually

Use an Excel spreadsheet design to create the presentation.

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.6 Create traffic light function

Let's create a simple traffic light that we can light up differently using numbers.

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.7 Print settings on all worksheets

Apply the print settings to other worksheets as well.

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.8 Printing multiple worksheets on one page

Save paper by putting several worksheets on one page.

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.9 Manual page break when printing

Add page breaks manually.

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.10 Excel table on a single page

Put your tables on a single page.

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.11 Hide error messages when printing

Errors that are actually suggestions can be easily hidden in Excel.

Excel tutorial: Pivot, charts and table design for clear data presentation - 3.12 Format codes in headers and footers

Insert header and footer elements such as file name, date or page number

Pivot 1x1

Excel tutorial: Pivot, charts and table design for clear data presentation - 4.1 Pivot: basics

Pivot tables can be created very quickly in Excel. In this step-by-step guide, you will learn how to do this.

Excel tutorial: Pivot, charts and table design for clear data presentation - 4.2 Pivot: calculations/field settings

Calculating fields in pivot tables is one of the most powerful features. Here you will learn how we can summarize sales and compare them as a percentage.

Excel tutorial: Pivot, charts and table design for clear data presentation - 4.3 Pivot: Timelines and data slicing

Calculate sales based on time data and only select sales at certain times.

Excel tutorial: Pivot, charts and table design for clear data presentation - 4.4 Pivot: Filtering

Filtering specific data records in pivot tables

Excel tutorial: Pivot, charts and table design for clear data presentation - 4.5 Pivot: Charts

Get to know the pivot charts. Create charts from the pivot template.

Excel tutorial: Pivot, charts and table design for clear data presentation - 4.6 Pivot: Layout

Adjustments to the design and layout of a pivot table

Excel tutorial: Pivot, charts and table design for clear data presentation - 4.7 Pivot: Options

Overview of the options of a pivot table

Tips & tricks for faster work

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.1 Secret selection

Suggestions as soon as you enter the first letter

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.2 New text lines within a cell

Create line breaks within a cell.

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.3 Lines in cells

Cells can be formatted with different lines.

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.4 Changing the capitalization of text in Excel

Use a function to display all values of a cell in upper or lower case.

Excel tutorial: Pivot, charts and table design for clear data presentation - Convert 5.5 hours into minutes

Simple trick to display hours in minutes.

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.6 Automatically generate ranked lists

Depending on your requirements, you can now number the placement according to the largest or smallest value without changing the original arrangement of the cells.

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.7 Calculating with the status bar

Results appear in the status bar

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.8 Totaling by cell range criteria

Totaling a cell range according to criteria

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.9 Counting by cell range criteria

ZÄHLENWENNS applies criteria to cells in several areas and counts how often all criteria apply.

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.10 Calculate mean value

Use a function to calculate the number in the middle of a number line.

Excel tutorial: Pivot, charts and table design for clear data presentation - 5.11 Important Excel macros for everyday use

Master the most common tasks in Excel with clever macros

Details of the content

Table design, data presentation & clear Excel charts
Have you ever tried in vain to read an Excel table you hastily created last year? Do others not want to make sense of your charts at all or only after a detailed explanation? Or are you wondering how you can prepare vast amounts of data in such an elegant way that the essentials catch the eye? In all these cases, the solution is Reduction and design. In this Excel tutorial , your trainer René Fürst has put together some effective methods for doing just that.

The contents of the Excel tutorial: pivot, charts, visualization and presentation

The Excel tutorial, which lasts over three hours , is divided into 44 lessons. Go step by step through the chapters "Evaluations and data overview", "Presentation and printing", "Pivot 1×1" and "Tips and tricks to work faster" to get to know Microsoft Excel even better. The following topics will be covered, among others:

Pivot table basics: How to analyze large amounts of data
Pivot tables in practice: creating timelines, using filters, charts and options
Using sparklines - small, fine charts in an Excel cell
Creating a speedometer chart - your data causes the speedometer needle to deflect
Create traffic light function - the traffic light changes from red to orange or green depending on the value
Printing Excel tables: manual pagination, tables on one page and more
Tips and tricks: converting hours to minutes, using macros, generating ranked lists ...
Exchanging columns and rows, displaying formulas, handling fractions in Excel
Mixing texts, data and formulas in a cell, database mask in Excel
Manage conditional formatting, use for weekdays

Understand data faster and better with the right table design

With the Excel tutorial, you will leave the traditional gray in gray far behind. You will learn methods and techniques that will help you analyze your data faster and present it more clearly. To understand the contents of the tutorial, you should already know the basics of Excel. The explanations are particularly suitable if you regularly work with Excel in your job, for example as a controller or in sales, manage large amounts of data and want to present it clearly for others, but also for yourself.