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: 866
Price: 29.95 EUR
Availability: InStock

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

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 Videos · 6 minutes

01 Open free of charge

Creating charts in Excel: 1.1 | Introduction and lecturer presentation

Introduction and lecturer presentation

34 MB

Creating charts in Excel: 1.1 | Introduction and lecturer presentation

6 min Open

34 MB

Basics Data Visualization

3 Videos · 21 minutes

02 Open

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.

27 MB

03 Open

Create charts in Excel: 2.2 | Manage charts

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

24 MB

04 Open

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.

15 MB

Create charts in Excel: 2.1 | Create visualizations

10 min Open

27 MB

Create charts in Excel: 2.2 | Manage charts

7 min Open

24 MB

Creating charts in Excel: 2.3 | Linking charts

4 min Open

15 MB

Simple diagrams in Excel

5 Videos · 41 minutes

05 Open

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.

34 MB

06 Open

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.

30 MB

07 Open

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

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

22 MB

08 Open

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.

22 MB

6 min Open

22 MB

Advanced visualizations in Excel

15 Videos · 126 minutes

10 Open

Creating charts in Excel: 4.1 | Composite charts

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

15 MB

11 Open

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.

52 MB

12 Open

Create charts in Excel: 4.3 | Panel charts

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

18 MB

13 Open

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.

73 MB

14 Open

Create charts in Excel: 4.5 | Treemap

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

18 MB

15 Open

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

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

16 MB

16 Open

Creating diagrams in Excel: 4.7 | SmartArt models in Excel

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

13 MB

17 Open

Create charts in Excel: 4.8 | Sparklines

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

20 MB

18 Open

Create charts in Excel: 4.9 | Tornado chart

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

16 MB

19 Open

Creating diagrams in Excel: 4.10 | HeatMap visualization

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

9 MB

20 Open

Create charts in Excel: 4.11 | Dynamic progress bar

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

34 MB

21 Open

Create charts in Excel: 4.12 | Dynamic status display

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

28 MB

22 Open

Create charts in Excel: 4.13 | Sunburst charts

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

16 MB

23 Open

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.

37 MB

12 min Open

37 MB

Create charts in Excel: 4.15 | Boxplots

14 min Open

43 MB

Special diagrams

13 Videos · 111 minutes

25 Open

Create charts in Excel: 5.1 | Thermometer chart

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

40 MB

26 Open

Create charts in Excel: 5.2 | Speedometer chart

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

37 MB

27 Open

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.

42 MB

28 Open

Creating charts in Excel: 5.4 | Waterfall charts 2

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

27 MB

29 Open

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.

28 MB

30 Open

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.

18 MB

31 Open

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.

39 MB

32 Open

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

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

27 MB

33 Open

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.

11 MB

34 Open

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.

7 MB

35 Open

Create charts in Excel: 5.11 | Dynamic world map

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

10 MB

36 Open

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.

20 MB

37 Open

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.

39 MB

Create charts in Excel: 5.1 | Thermometer chart

15 min Open

40 MB

Create charts in Excel: 5.2 | Speedometer chart

12 min Open

37 MB

Creating charts in Excel: 5.3 | Waterfall charts 1

14 min Open

42 MB

Creating charts in Excel: 5.4 | Waterfall charts 2

8 min Open

27 MB

Create charts in Excel: 5.5 | Dynamic planning steps 1

10 min Open

28 MB

Create charts in Excel: 5.6 | Dynamic planning steps 2

9 min Open

18 MB

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

13 min Open

39 MB

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

9 min Open

27 MB

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

3 min Open

11 MB

Create charts in Excel: 5.10 | 2D Map World

2 min Open

7 MB

Create charts in Excel: 5.11 | Dynamic world map

3 min Open

10 MB

Create charts in Excel: 5.12 | Bing Maps

6 min Open

20 MB

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

7 min Open

39 MB

Secret professional visualizations

3 Videos · 14 minutes

38 Open

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.

17 MB

39 Open

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

You will learn how to analyze deviations from number series.

18 MB

40 Open

Create charts in Excel: 6.3 | PowerView dashboard

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

14 MB

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

5 min Open

17 MB

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

5 min Open

18 MB

Create charts in Excel: 6.3 | PowerView dashboard

4 min Open

14 MB

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