Language: German

Create Excel charts and visualize data - the complete course

Name: Create Excel charts and visualize data - the complete course
Brand: TutKit.com
SKU: package_866
Price: 29.95 EUR
Availability: InStock

Office, Business, Marketing & Sales · 40 Videos · 5.3 h Video training · German

by Fabio Basler

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!

content

40 Videos, 321 minutes

Introduction

1 Video · 6 minutes

01 Open free of charge

Creating charts in Excel: 1.1 | Introduction and lecturer presentation

6 min

Introduction and lecturer presentation

34 MB To the text tutorial: Create diagrams in Excel

Basics Data Visualization

3 Videos · 21 minutes

02 Open

Create charts in Excel: 2.1 | Create visualizations

10 min

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.

27 MB To the text tutorial: Create successful charts in Excel

03 Open

Create charts in Excel: 2.2 | Manage charts

7 min

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

24 MB To the text tutorial: Manage diagrams effectively in Excel

04 Open

Creating charts in Excel: 2.3 | Linking charts

4 min

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

15 MB To the text tutorial: This is how you dynamically link Excel charts to PowerPoint and Word

Simple diagrams in Excel

5 Videos · 41 minutes

05 Open

Creating charts in Excel: 3.1 | Column and bar charts

11 min

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

34 MB To the text tutorial: Visual data analysis - creating bar and column charts in Excel

06 Open

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

10 min

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

30 MB To the text tutorial: Effectively visualize pie and ring charts in Excel

07 Open

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

7 min

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

22 MB To the text tutorial: Create line charts and trendlines effectively in Excel

08 Open

Create charts in Excel: 3.4 | Area charts

7 min

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

22 MB To the text tutorial: Create pie charts in Excel easily

09 Open

Creating charts in Excel: 3.5 | Histogram and Pareto chart

6 min

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

22 MB To the text tutorial: Create and analyze histograms in Excel

Advanced visualizations in Excel

15 Videos · 126 minutes

10 Open

Creating charts in Excel: 4.1 | Composite charts

5 min

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

15 MB To the text tutorial: Create network diagrams in Excel efficiently

11 Open

Creating charts in Excel: 4.2 | Stacked column charts

13 min

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.

52 MB To the text tutorial: Create stacked column charts in Excel

12 Open

Create charts in Excel: 4.3 | Panel charts

5 min

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

18 MB To the text tutorial: Create panel charts effectively in Excel

13 Open

Creating charts in Excel: 4.4 | Pivot charts

20 min

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

73 MB To the text tutorial: Create dynamic pivot charts in Excel for data visualization

14 Open

Create charts in Excel: 4.5 | Treemap

6 min

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

18 MB To the text tutorial: Create a treemap in Excel and visualize data

15 Open

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

5 min

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

16 MB To the text tutorial: Create funnel chart in Excel

16 Open

Creating diagrams in Excel: 4.7 | SmartArt models in Excel

5 min

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

13 MB To the text tutorial: SmartArt in Excel - Effective guide to visualization

17 Open

Create charts in Excel: 4.8 | Sparklines

6 min

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

20 MB To the text tutorial: Sparklines in Excel - Presenting data visually

18 Open

Create charts in Excel: 4.9 | Tornado chart

6 min

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

16 MB To the text tutorial: Create tornado diagrams in Excel

19 Open

Creating diagrams in Excel: 4.10 | HeatMap visualization

3 min

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

9 MB To the text tutorial: Create a heatmap in Excel - Classic data visualization

20 Open

Create charts in Excel: 4.11 | Dynamic progress bar

11 min

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

34 MB To the text tutorial: Create a dynamic progress indicator in Excel

21 Open

Create charts in Excel: 4.12 | Dynamic status display

9 min

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

28 MB To the text tutorial: Create dynamic status display in Excel

22 Open

Create charts in Excel: 4.13 | Sunburst charts

6 min

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

16 MB To the text tutorial: Visualizing hierarchical data with sunburst charts

23 Open

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

12 min

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

37 MB To the text tutorial: Charts in Excel: Scatter plots and network diagrams

24 Open

Create charts in Excel: 4.15 | Boxplots

14 min

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

43 MB To the text tutorial: Creating boxplots in Excel: Guide to the perfect chart

Special diagrams

13 Videos · 111 minutes

25 Open

Create charts in Excel: 5.1 | Thermometer chart

15 min

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

40 MB To the text tutorial: Create a thermometer chart in Excel

26 Open

Create charts in Excel: 5.2 | Speedometer chart

12 min

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

37 MB To the text tutorial: Speedometer chart in Excel: How to create it quickly

27 Open

Creating charts in Excel: 5.3 | Waterfall charts 1

14 min

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

42 MB To the text tutorial: Create waterfall charts in Excel easily

28 Open

Creating charts in Excel: 5.4 | Waterfall charts 2

8 min

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

27 MB To the text tutorial: Create waterfall diagrams in Excel

29 Open

Create charts in Excel: 5.5 | Dynamic planning steps 1

10 min

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.

28 MB To the text tutorial: Create dynamic charts in Excel

30 Open

Create charts in Excel: 5.6 | Dynamic planning steps 2

9 min

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

18 MB To the text tutorial: Create interactive charts in Excel with dynamic planning steps

31 Open

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

13 min

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

39 MB To the text tutorial: Pie charts in Excel for BCG matrix

32 Open

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

9 min

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

27 MB To the text tutorial: Create a Gantt chart in Excel

33 Open

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

3 min

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

11 MB To the text tutorial: Create a chart diagram in Excel - This is how it works

34 Open

Create charts in Excel: 5.10 | 2D Map World

2 min

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

7 MB To the text tutorial: Create a 2D map chart in Excel - visualize global population numbers

35 Open

Create charts in Excel: 5.11 | Dynamic world map

3 min

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

10 MB To the text tutorial: Create a dynamic world map in Excel

36 Open

Create charts in Excel: 5.12 | Bing Maps

6 min

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

20 MB To the text tutorial: Create data visualization with 3D graphics in Excel

37 Open

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

7 min

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

39 MB To the text tutorial: Effectively use 3D charts in Excel

Secret professional visualizations

3 Videos · 14 minutes

38 Open

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

5 min

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

17 MB To the text tutorial: Sales development and target range chart in Excel

39 Open

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

5 min

You will learn how to analyze deviations from number series.

18 MB To the text tutorial: Analysis of deviations in Excel charts

40 Open

Create charts in Excel: 6.3 | PowerView dashboard

4 min

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

14 MB To the text tutorial: Create professional dashboards with PowerView in Excel

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

Note

Usable with: Microsoft Excel
Licence: private and commercial Rights of use

Created with love by

Fabio Basler

My name is Fabio Basler and I have been working with Microsoft Excel for years. Thanks to the daily use in my job as a business unit controller, I now know almost all the functions and shortcuts in Excel. In addition, I ran a tutorial for three semesters in which I taught 30 to 40 students statistics. Thanks to my intensive involvement with the subject, I now know all the tricks of the trade! I have already helped countless students to successfully complete the exam and prepared them for their day-to-day work with MS Excel. My goal on TutKit.com is to share all my knowledge in data analysis, Excel and statistics, with targeted case studies that include real-life examples.

Products