Mastering Microsoft Excel - Charts In Detail

Learn how to create dynamic and interactive charts in Excel. Turn your data into professional looking charts and graphs

Created byInfinite Skills

Last updated 1/2017

English

What you'll learn

Learn How to Create Interactive Charts & Graphs From Your Data

Course content

8 sections • 36 lectures • 3h 21m total length

Important - Download These First - Working Files0:01
0101 A Chart Can Explain Things Better Than Numbers5:51
0103 The Included Working Files1:52
Use the working files organized by lesson chapters, with end-of-lesson copies like stock_resolved to reproduce steps in Excel 2013, and note some chapters include PowerPoint, Word, or image files.

0201 Deciding On The Data To Be Used In A Chart4:38
0202 Creating Charts Quickly5:54
Identify the right data and create charts quickly using quick analysis, the F11 shortcut, or the insert ribbon to choose recommended charts, then customize chart types and colors in Excel.
0203 Use Sparklines To Create Inline Charts4:57
Learn to create inline sparklines in Excel, choosing line, column, or win/loss styles, customize markers, highs and lows, and quickly update or delete them with the quick analysis tools.
0204 Chart Areas Plot Chart Legends6:59
0205 Filtering An Existing Chart3:48
Learn to filter an existing chart in Excel after creation using the filter icon, exclude categories, and see updated percentages for pie, line, and bar charts.
0206 The Right Chart Type Matters4:42
0207 The Chart Sub Ribbons And Properties Box5:25

0301 Moving Charts And Switching Rows And Columns7:06
Move charts between sheet objects and their own sheets, resize and reposition them, and switch rows and columns to better map data; compare chart types and preserve data linkage.
0302 Changing The Default Chart Type3:09
0303 Chart Layouts Styles And Colors5:59
0304 Adding And Removing Chart Elements6:27
0305 Dealing With Hidden Or Empty Cells5:14
Learn to manage hidden and empty cells in Excel charts by using select data to show gaps or connect data points and include hidden rows and columns.
0306 Dynamic Titles4:14
Link chart titles and axis labels to worksheet cells to create dynamic charts, using the formula bar and equals to pull values from the data sheet as data changes.
0307 Trend Lines Used To Help Analyze Data8:05

0401 Adding And Manipulating Shapes6:39
0402 Add WordArt And Use Of WordArt Styles7:06
Apply WordArt to Excel charts to create dynamic, styled chart titles and text objects using 3D effects, shadows, glows, and rotations, with options to affect single objects or entire charts.
0403 Adding Static And Dynamic Text Boxes7:02
0404 Using Pictures Or Textures As Chart Element Backgrounds6:13
0405 Altering Axis Formatting And Plotting8:12
Explore how to customize Excel chart axes, including grid lines, tick marks, and date or time scales, using the format axes dialog to set min, max, and intervals.
0406 Managing Data Labels6:34

Requirements

PC, Microsoft Excel 2010, 2013 or Later

Description

This Microsoft Excel – Charts in Detail training course from Infinite Skills takes you beyond the basics of Excel, diving into detail about creating and using charts within this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel.

You will start by learning the basics of Excel charts, such as how to create them quickly and why the right chart type matters. From there, you will learn about the tools within the design and format tabs, including the different chart layout styles and colors, adding and manipulating shapes, and managing data labels. Guy will show you special chart types and properly explain scatter charts. This training video will teach you about chart data and how to create charts from multiple data sources. Finally, Guy will teach you how to print your chart and copy and link it to other Office applications.

By the completion of this video based training course, you will be fully versed in creating and using Excel charts. Working files are included, allowing you to follow along with the author throughout the lessons.

Who this course is for:

Users with a basic knowledge of Microsoft Excel

Mastering Microsoft Excel - Charts In Detail

What you'll learn

Explore related topics

Course content

Welcome3 lectures • 8min

Chart Basics7 lectures • 36min

The Design Tab7 lectures • 40min

The Format Tab6 lectures • 42min

Special Chart Types6 lectures • 40min

Chart Data3 lectures • 17min

Printing And Sharing Charts3 lectures • 14min

The End1 lecture • 4min

Requirements

Description

Who this course is for: