Diagrams in Excel

Language: German

Create Excel charts and visualize data - the complete course

What was that again about creating pivot charts? How do box plots actually work? Which charts are also recommended to visualize your data more clearly? Excel expert Fabio Basler will introduce you to all the important charts in this complete 5-hour course. So if you want to present a funnel or sunburst chart, you will now know how to create them in just a few minutes.

Excel complete course: Create charts and visualize data
All important diagrams and visualizations explained step by step
From the basics to simple bar charts and advanced Gantt charts
Over 5 hours of training with practical tips and tricks from Excel expert Fabio Basler

Create charts in Excel - get an overview of the possibilities or use the training as a reference work. This is how you present your data clearly!

Details

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

Introduction

free of charge

Creating charts in Excel: 1.1 | Introduction and lecturer presentation

Introduction and lecturer presentation

Fundamentals of data visualization

Create charts in Excel: 2.1 | Create visualizations

In this first course lesson, we will talk about how you can create visualizations in Excel. We will focus in particular on the visualization of data series in Excel and general possibilities.

download project file

Create charts in Excel: 2.2 | Manage charts

In this video you will learn how to manage charts in Excel.

download project file

Creating charts in Excel: 2.3 | Linking charts

In this video unit, you will learn how to dynamically link diagrams with PowerPoint and Word, for example.

download project file

Simple charts in Excel

Creating charts in Excel: 3.1 | Column and bar charts

In this lesson, we come to the simplest form of visualization in Excel: column and bar charts.

download project file

Creating charts in Excel: 3.2 | Pie charts and ring charts

In this lesson, we will look at another simple form of visualization in Excel: pie charts and ring charts.

download project file

Creating charts in Excel: 3.3 | Line charts and trend lines

You will learn how to create line charts and trend lines in Excel.

download project file

Create charts in Excel: 3.4 | Area charts

In this learning unit, you will see how you can visualize area graphs as well as line graphs.

download project file

Creating charts in Excel: 3.5 | Histogram and Pareto chart

In this lesson, we will talk about histograms and Pareto charts in Excel.

download project file

Advanced visualizations in Excel

Creating charts in Excel: 4.1 | Composite charts

In this video you will learn how to create compound charts in Excel.

download project file

Creating charts in Excel: 4.2 | Stacked column charts

In addition to simple bar charts, Excel can also be used to create stacked bar charts. In this lesson, you will learn how to do this.

download project file

Create charts in Excel: 4.3 | Panel charts

In this learning unit, you will learn what panel charts are and how to create them.

download project file

Creating charts in Excel: 4.4 | Pivot charts

In addition to simple charts based on data series, visualizations in Excel can also be created based on pivot tables.

download project file

Create charts in Excel: 4.5 | Treemap

You will learn what treemaps are and how you can visualize them.

download project file

Creating charts in Excel: 4.6 | Funnel charts (pyramid)

You will learn what funnel charts are and how you can visualize them.

download project file

Creating diagrams in Excel: 4.7 | SmartArt models in Excel

You will learn what SmartArt graphics are and how you can visualize them.

download project file

Create charts in Excel: 4.8 | Sparklines

You will learn what sparkline graphics are and how you can create them.

download project file

Create charts in Excel: 4.9 | Tornado chart

In this learning unit, you will learn all about tornado graphics in Excel.

download project file

Creating diagrams in Excel: 4.10 | HeatMap visualization

In this video, you will learn how to create heat maps with conditional formatting in Excel.

download project file

Create charts in Excel: 4.11 | Dynamic progress bar

In this learning unit, you will learn all about the dynamic progress bar in Excel.

download project file

Create charts in Excel: 4.12 | Dynamic status display

In this learning unit, you will learn all about the dynamic status display in Excel.

download project file

Create charts in Excel: 4.13 | Sunburst charts

You will learn what sunburst graphics are and how you can visualize them.

download project file

Creating diagrams in Excel: 4.14 | Point XY diagrams and network diagrams

You will learn what dot XY graphics are and how you can visualize them.

download project file

Create charts in Excel: 4.15 | Boxplots

You will learn what box plots are and how you can visualize them.

download project file

Special diagrams

Create charts in Excel: 5.1 | Thermometer chart

You will learn what thermometer diagrams are and how you can visualize them.

download project file

Create charts in Excel: 5.2 | Speedometer chart

You will learn what speedometer diagrams are and how you can visualize them.

download project file

Creating charts in Excel: 5.3 | Waterfall charts 1

You will learn what waterfall diagrams are and how you can visualize them. We come to the first exercise example.

download project file

Creating charts in Excel: 5.4 | Waterfall charts 2

In this lesson, we come to the second exercise on waterfall charts in Excel.

download project file

Create charts in Excel: 5.5 | Dynamic planning steps 1

In this video unit, you will learn how to create dynamic diagrams based on formulas in the name manager. We come to the first exercise example.

download project file

Create charts in Excel: 5.6 | Dynamic planning steps 2

In this lesson, we come to the second exercise on dynamic planning steps in Excel.

download project file

Creating charts in Excel: 5.7 | Bubble charts as a portfolio matrix

In this video unit, you will learn how to create bubble charts in Excel. Particularly suitable for portfolio analysis in companies.

download project file

Create charts in Excel: 5.8 | Gantt chart (bar chart)

In this learning unit, you will learn all about Gantt charts in Excel.

download project file

Create charts in Excel: 5.9 | 2D map of Germany

In this learning unit, you will learn all about 2D charts relating to Germany in Excel.

download project file

Create charts in Excel: 5.10 | 2D Map World

In this learning unit, you will learn all about 2D charts relating to a world map in Excel.

download project file

Create charts in Excel: 5.11 | Dynamic world map

You will learn how to create a dynamic world map in Excel.

download project file

Create charts in Excel: 5.12 | Bing Maps

In addition to 2D graphics, you will also learn how to create 3D graphics in this lesson.

download project file

Create charts in Excel: 5.13 | 3D Map (Power Map)

In addition to 2D graphics, you will also learn how to create 3D graphics in this lesson.

download project file

Secret professional visualizations.

Creating charts in Excel: 6.1 | Sales trend and target corridor chart

You will learn how to create a company's sales trend as a target corridor.

download project file

Create charts in Excel: 6.2 | Analyze deviation of number series

You will learn how to analyze deviations from number series.

download project file

Create charts in Excel: 6.3 | PowerView dashboard

In this last video, you will learn how to create professional dashboards using the PowerView function.

download project file

Details of the content

Create charts in Excel: Which ones there are, how you use them
The same applies to data: you eat with your eyes. What's more, specific forms of visualization are suitable for every data set, analysis and presentation. So create a better overview, more clarity and greater understanding by preparing your data with the right chart. Find out which Excel charts are available and how to use them in 40 lessons lasting over 5 hours from Excel trainer Fabio Basler.

The complete diagram course for beginners AND Excel users

Whether you are new to Excel or you work with the program regularly, this complete course is suitable for beginners as well as for getting to know other chart representations:

As a beginner, you can expect basic explanations first. Learn how to create and manage charts in Excel and how to link them to Word, for example . You will also learn how to create simple and frequently used charts such as bar and column charts.

Advanced users will enjoy a compact and targeted explanation of all the important Excel charts . Whether heat maps, box plots, bubble charts or treemaps - with your trainer's tips, you will be able to use Excel even more effectively for data visualization and, with the help of Gantt charts and dynamic progress indicators, perhaps even for your project management.

All important visualizations: Explained step by step and in a practical way

Separate video lessons are available for all important Excel charts. On the one hand, you can watch the training as a whole to get an overview of the available visualization options . This way, you will know which chart variant is recommended for visualizing your next data series.

And on the other hand, if you want to use a specific chart type later and want to quickly check how to proceed beforehand, simply jump to the relevant lesson.

The following diagrams and visualizations are discussed in the course:

Simple diagrams: Column, bar, pie, ring and line charts, area charts, trend lines, histogram, Pareto charts
Advanced diagrams: Composite charts, stacked column charts, panel and pivot charts, treemap, funnel, sunburst, dot XY and network charts, SmartArt, sparklines, tornado chart, HeatMap, dynamic progress and status display, boxplots
Special visualizations: Thermometer, speedometer chart, waterfall chart, dynamic planning steps, bubble chart as portfolio matrix, Gantt chart (bar chart), maps
Professional visualizations: Sales progression and target corridor chart, analyze deviation of number series, PowerView dashboard