Excel Charts and Visualization

72 casts | 4:08:49 for the total course

Data Visualization Excel

Description

Learn how to visualize your data for presentations, meetings and your next raise in this Excel master course. You’ll learn how to build charts from scratch in Excel.

Learn the basics of charts and how to make an impact with visualization. Learn to communicate with your end user and make data understandable.

Learn how to choose the right chart for your dataset and the story you want to tell.

Learn how to master Excel chart tools, including templates, axes and different chart formats.

Build many different projects, including pie charts, line charts and bar charts. And much more. Learn how to build a huge range of charts to make an impressive portfolio.

Learn advanced visualization with pivot charts and slicers. Build a break even chart to get you hired.

Track rating stars and risk scores as you build dynamic chart projects.

This course is project-based so you will not be learning a bunch of useless coding practices. At the end of this course you will have real world apps to use in your portfolio. We feel that project based training content is the best way to get from A to B. Taking this course means that you learn practical, employable skills immediately.

You can use the projects you build in this course to add to your LinkedIn profile. Give your portfolio fuel to take your career to the next level.

Learning how to code is a great way to jump in a new career or enhance your current career. Coding is the new math and learning how to code will propel you forward for any situation. Learn it today and get a head start for tomorrow. People who can master technology will rule the future.

  • 1. Intro to the Course
    • Excel | Introduction to the Course | 1.1

      4:46

    • Excel | Why Should You Learn About Charts And Data Visualization? | 1.2

      4:31

    • Excel | Introduction Of The Instructors | 1.3

      2:08

    • Excel | Course Requirements (what software, experience) Excel | 1.4

      2:36

  • 2. Charts and Basics
    • Excel | What Will We Learn In This Section | 2.1

      1:21

    • Excel | Main Principles And Chart Visualization Impact | 2.2

      2:39

    • Excel | Choosing The Correct Chart | 2.3

      1:57

    • Excel | Communicate With The End User | 2.4

      2:18

    • Excel | Section Summary | 2.5

      2:59

    • Excel | Challenge | 2.6

      2:12

  • 3. Excel Chart Tools
    • Excel | What Will We Learn In This Section | 3.1

      1:36

    • Excel | Chart Design | 3.2

      6:39

    • Excel | Working With Chart Formats | 3.3

      4:35

    • Excel | Chart Types | 3.4

      2:09

    • Excel | Primary & Secondary Axis | 3.5

      4:21

    • Excel | Chart Templates | 3.6

      3:25

    • Excel | Section Summary | 3.7

      2:50

    • Excel | Challenge | 3.8

      1:23

  • 4. Working with Basic Excel Charts & Graphs
    • Excel | What Will We Learn In This Section | 4.1

      1:21

    • Excel | Excel Column Charts | 4.2

      4:13

    • Excel | Column Charts Challenge | 4.3

      1:08

    • Excel | Excel Bar Charts 1 | 4.4

      3:13

    • Excel | Excel Bar Charts 2 | 4.4

      3:13

    • Excel | Bar harts Challenge | 4.5

      0:48

    • Excel | Excel Line Charts | 4.6

      3:52

    • Excel | Line Charts Challenge | 4.7

      0:49

    • Excel | Excel Pie Charts | 4.8

      5:01

    • Excel | Pie Charts Challenge | 4.9

      0:58

    • Excel | Excel Area Charts | 4.10

      2:27

    • Excel | Area Charts Challenge | 4.11

      0:49

    • Excel | Excel Scatter Charts | 4.12

      4:00

    • Excel | Scatter Charts Challenge | 4.13

      0:42

    • Excel | Excel Bubble Charts | 4.14

      5:13

    • Excel | Bubble Charts Challenge | 4.15

      0:55

    • Excel | Excel Stock Charts | 4.16

      3:08

    • Excel | Stock Charts Challenge | 4.17

      0:56

    • Excel | Excel Surface Charts | 4.18

      4:42

    • Excel | Surface Charts Challenge | 4.19

      0:44

    • Excel | Excel Radar Charts | 4.20

      2:58

    • Excel | Radar Charts Challenge | 4.21

      0:39

    • Excel | Excel Treemap Charts | 4.22

      2:31

    • Excel | Treemap Charts Challenge | 4.23

      1:04

    • Excel | Excel Sunburst Charts | 4.24

      2:36

    • Excel | Sunburst Charts Challenge | 4.25

      0:59

    • Excel | Excel Histogram & Pareto Charts | 4.26

      4:03

    • Excel | Histogram & Pareto Charts Challenge | 4.27

      1:04

    • Excel | Excel Waterfall Charts | 4.28

      5:26

    • Excel | Waterfall Charts Challenge | 4.29

      0:47

    • Excel | Excel Box&whisker Charts

      3:24

    • Excel | Box&whisker Charts Challenge | 4.31

      1:04

    • Excel | Excel Sparklines | 4.32

      3:45

    • Excel | Sparklines Challenge | 4.33

      0:54

    • Excel | Excel Color Scales | 4.34

      3:43

    • Excel | Color Scales Challenge | 4.35

      0:49

    • Excel | Excel 3D Map | 4.36

      4:36

    • Excel | 3D Map Challenge | 4.37

      1:45

    • Excel | Section Summary | 4.38

      10:14

  • 5. Excel Advanced Data Visualization
    • Excel | What We Will Learn In This Section | 5.1

      2:23

    • Excel | Data Visualization With Pivot Chart And Slicers | 5.2

      7:05

    • Excel | Challenge Data Visualization With Pivot Chart And Slicers | 5.3

      1:35

    • Excel | Create Break Even Chart | 5.4

      9:25

    • Excel | Challenge Break Even Chart | 5.5

      1:12

    • Excel | Rating Star Chart | 5.6

      7:10

    • Excel | Challenge Star Rating | 5.7

      1:28

    • Excel | Drop Down Menu For Chart | 5.8

      16:31

    • Excel | Challenge Drop Down Menu Chart | 5.9

      1:21

    • Excel | Risk Score Chart | 5.10

      11:03

    • Excel | Challenge Risk Score Chart | 5.11

      1:23

    • Excel | Dynamic Chart Update | 5.12

      8:10

    • Excel | Challenge Dynamic Chart Update | 5.13

      1:47

    • Excel | Section Summary | 5.14

      6:48

    • Excel | Course Summary And Next Steps | 6.1

      16:30

Created By

Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more. Over 11 years, Mammoth Interactive has built a global student community with 3.3 million

US$19.98

  US$199.00

Buy Now (US$19.98) ➔

Lifetime Access
30-Day Money-Back Guarantee.

Reviews
No reviews yet