Excel Graphs, Infographics & Data Visualization

Focused View

Andreas Exadaktylos

6:37:12

13 View

01 Introduction.mp4

02:06

02 Why Do We Visualize Data.mp4

02:28

03 How Do We Visualize Data.mp4

04:42

04 Making the Right Chart.mp4

07:37

05 Introducing Excel Charts.mp4

13:22

06 Advanced Charting Techniques.mp4

06:17

07 Advanced Chart Formatting Options.mp4

12:12

08 Camera Tool.mp4

03:48

09 Charts with Tables.mp4

06:47

10 Intro for basic charts.mp4

00:57

11 Line Chart Multiple Lines.mp4

03:53

12 Bar Chart with Upper and Lower Limits.mp4

03:28

13 Emphasizing and Mark Significant Events.mp4

08:11

14 TreeMap Chart.mp4

03:58

15 Sunburst Chart.mp4

03:00

16 Funnel Chart.mp4

14:19

17 Sparklines and Win Loss Charts.mp4

08:25

18 Mini In-Cell Charts (using REPT Function).mp4

02:32

19 Small Multiples.mp4

04:19

20 Introdunction (Conditional Formatting).mp4

03:12

21 Visualizing with Custom Number Formatting.mp4

07:05

22 Representing trends with Icon Sets, Data Bars and Symbols.mp4

07:12

23 Pictograph.mp4

05:07

24 Comparisons and Data Bars (with Conditional Formatting).mp4

05:08

25 Heat Map with Color Scales.mp4

03:06

26 Chart Up and Down Arrow Symbols.mp4

05:47

27 Introduction (Infographics).mp4

04:29

28 People Graph.mp4

07:03

29 Progress Doughnut Chart.mp4

13:17

30 Tube Chart.mp4

11:41

31 3D Donut Chart.mp4

06:50

32 Dynamic Overlay Custom Image Chart.mp4

06:29

33 Waffle Charts for KPIs (Better than Pie Charts).mp4

09:48

34 Introduction (Advanced Charts).mp4

01:13

35 Dynamic Line Chart with MAX and MIN Dots.mp4

08:52

36 Speedometer-Gauge Chart.mp4

09:26

37 Bullet Graph.mp4

05:47

38 TOP and BOTTOM Ranking Chart.mp4

10:37

39 Dynamic Chart with Drop Down Lists and Filters.mp4

09:39

40 Creating side by side time comparisons panel chart.mp4

08:47

41 Dot Plot Chart and Dumbbell Chart.mp4

10:34

42 Timeline Milestone Chart.mp4

08:50

43 Actual vs Target Chart.mp4

05:12

44 Gantt Chart.mp4

05:34

45 Burn Down Chart.mp4

05:30

46 Tornado Chart.mp4

03:27

47 Frequency Distribution Chart (Histogram).mp4

07:41

48 Animated Chart using VBA Code.mp4

08:18

49 Rollover Dynamic On-Demand Chart.mp4

21:29

50 Introduction (Form Controls).mp4

01:51

51 Combo Box.mp4

05:29

52 Option Buttons.mp4

06:51

53 Check Box.mp4

05:27

54 List Box.mp4

06:50

55 Scroll Bar.mp4

07:03

56 Traffic Lights Dashboard Part 1.mp4

07:34

57 Traffic Lights Dashboard Part 2.mp4

05:24

58 Traffic Lights Dashboard Part 3.mp4

07:29

59 Traffic Lights Dashboard Part 4.mp4

03:43

GanttChart START.xlsx.xlsx

Description

This Class will guide you through Excel's data visualization features from shapes to conditional formatting to charts.

I include several realistic case studies so you can see how a business question can turn into a chart or dashboard.

We’ll start by why and how we visualize data.

Then I’ll walk you through the charting techniques to create and modify a chart quickly and easily.

After that, we will chop up the defaults of Excel charts with some ninja skills to use what Excel does have and create powerhouse visualizations.

Once we’ve mastered the basics, I’ll walk you through all the tools to improve your graphs with conditional formatting, custom number formatting, and shapes.

The next section is about info-graphics with excel. Info-graphics are stunning graphic visual representations of information, which are intended to present data quickly and clearly. You will be shocked at how easy you can add great-looking info-graphics to an Excel worksheet.

Then we’ll dive into the real meat of the course, the section with custom build advanced charts. In this section, I’ll make you a data visualization expert!

Finally, I’ll walk you through the next-level dynamic interactive charts with the help of form controls and formulas, and a ton of real-life examples.

The class is entirely project based and it’s full of examples which are fully explained and easy to understand. It has been recorder with the brand new Excel 2019 in full HD 1080p.

By the end of this Class, you’ll master any Advanced Chart and you'll become a Data Visualization Expert

So let's get started!

What You'll Learn?

Business
Infographics
Data Visualization
Microsoft Excel
Data Analysis
Interactive Charts
Dashboards

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Andreas Exadaktylos

Instructor's Courses

LinkedIn: https://www.linkedin.com/in/andreasexadaktylos

Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever i can.

I have over 16 years of experience in teaching as an instructor. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.

I have a Masters Degree in Computer Science and a Degree in Electronic Engineering.

I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well.

I have a passion for software products that make people's lives easier. I love to create websites and optimizing them with Search Engine optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife.

I live in Rodos, a beautiful Greek island. When i am not working, i love being with my family and my two kids. Travel, forex trading and reading books are my favorite hobbies

SkillShare

View courses SkillShare

Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.