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
4.6 (19 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
996 students enrolled
$50
Take This Course
  • Lectures 36
  • Contents Video: 3.5 hours
    Other: 1 min
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2013 English

Course 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.

What are the requirements?

  • PC, Microsoft Excel 2010, 2013 or Later

What am I going to get from this course?

  • Learn How to Create Interactive Charts & Graphs From Your Data

What is the target audience?

  • Users with a basic knowledge of Microsoft Excel

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome
Important - Download These First - Working Files
Preview
Article
0101 A Chart Can Explain Things Better Than Numbers
Preview
05:51
0103 The Included Working Files
Preview
01:52
Section 2: Chart Basics
0201 Deciding On The Data To Be Used In A Chart
04:38
0202 Creating Charts Quickly
05:54
0203 Use Sparklines To Create Inline Charts
04:57
0204 Chart Areas Plot Chart Legends
06:59
0205 Filtering An Existing Chart
03:48
0206 The Right Chart Type Matters
04:42
0207 The Chart Sub Ribbons And Properties Box
05:25
Section 3: The Design Tab
0301 Moving Charts And Switching Rows And Columns
07:06
0302 Changing The Default Chart Type
03:09
0303 Chart Layouts Styles And Colors
05:59
0304 Adding And Removing Chart Elements
06:27
0305 Dealing With Hidden Or Empty Cells
05:14
0306 Dynamic Titles
04:14
0307 Trend Lines Used To Help Analyze Data
08:05
Section 4: The Format Tab
0401 Adding And Manipulating Shapes
06:39
0402 Add WordArt And Use Of WordArt Styles
07:06
0403 Adding Static And Dynamic Text Boxes
07:02
0404 Using Pictures Or Textures As Chart Element Backgrounds
06:13
0405 Altering Axis Formatting And Plotting
08:12
0406 Managing Data Labels
06:34
Section 5: Special Chart Types
0501 Multiple Chart Types In The Same Chart
06:06
0502 Multiple Pie Charts In The Same Sheet
06:21
0503 Pie Of A Pie
05:59
0504 Charting Stock Movements
07:26
0505 Radar Charts In Action
07:17
0506 Scatter Charts Explained
06:54
Section 6: Chart Data
0601 Changing A Charts Date Source
05:05
0602 Creating Charts From Multiple Data Sources
07:06
0603 What Happens When I Copy Sheets With Charts?
05:15
Section 7: Printing And Sharing Charts
0701 How To Print Charts
03:36
0702 Chart Templates
03:33
0703 Copying And Linking Charts To Other Office Applications
06:57
Section 8: The End
0801 Charts In Summary
03:57

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course