Excel: Charts and Graphs In Depth

Focused View

Jordan Goldmeier

2:11:07

9 View

01 - Introduction

01 - Getting more from your data with charts.mp4

00:39

02 - 1. Chart Basics What You Need to Know

01 - An overview of chart types.mp4

03:24

02 - Getting started Laying out the data.mp4

03:53

03 - Creating and editing your chart.mp4

03:44

04 - The elements of an Excel chart.mp4

05:13

05 - Quirks of Excel charts.mp4

03:37

06 - Essential chart hacks to make your life easier.mp4

06:29

03 - 2. Zen and the Art of Chart Maintenance

01 - Why chart maintenance is important.mp4

03:11

02 - Effective chart titles and legends.mp4

03:20

03 - Managing your source data.mp4

05:41

04 - Template options and color choices.mp4

00:57

04 - 3. Modify Chart Elements and Details

01 - Set chart axes++.mp4

02:01

02 - Chart and axes titles.mp4

01:35

03 - Add and edit data labels.mp4

03:09

04 - Add basic interactivity.mp4

02:45

05 - Adjusting gridlines.mp4

02:10

06 - Trendlines.mp4

03:53

05 - 4. The Excel Chart Library

01 - Column and bar charts.mp4

01:42

02 - Pie charts and doughnut charts.mp4

02:53

03 - Line and area charts.mp4

03:54

04 - Scatter plots.mp4

02:05

05 - Bubble charts.mp4

02:59

06 - Radar charts.mp4

01:44

07 - Stock charts.mp4

04:38

08 - Sunburst charts and treemap charts.mp4

03:01

09 - Histogram chart.mp4

02:46

10 - Box and whisker chart.mp4

01:12

11 - Pareto chart.mp4

01:58

12 - Waterfall and funnel charts.mp4

02:33

13 - Map charts based on geographic data.mp4

03:35

06 - 5. Advanced Chart Techniques

01 - Pivot charts.mp4

03:11

02 - Slicers and Timelines.mp4

03:54

03 - Cross filtering with the Excel Data Model.mp4

03:58

04 - Conditional formatting in charts.mp4

06:41

05 - Using linked pictures.mp4

01:46

06 - Aligning chart elements.mp4

04:14

07 - Sparklines and heat maps.mp4

04:34

08 - Font charts.mp4

02:14

07 - 6. Data Visualization Rules

01 - Do more with less.mp4

01:15

02 - Format for clarity.mp4

00:54

03 - Using color to make a point.mp4

02:15

04 - Use data visualization principles.mp4

03:39

05 - Consider the audience.mp4

01:28

08 - Conclusion

01 - Where to learn more about Excel charts and graphs.mp4

00:23

Description

Excel charts allow you to communicate information with much more impact than raw numbers and are surprisingly easy to generate. In this course, Microsoft MVP Jordan Goldmeier shows you how to create different kinds of Excel charts, from familiar column, bar, line, and pie charts to more recently introduced types like Treemap, Funnel, and Pareto. He explains what types of data work best with each, so you can decide which type to choose for your specific information. Plus, Jordan goes over how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Jordan Goldmeier

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.