Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Mastering Microsoft Excel - Charts In Detail to your Wishlist.

Add to Wishlist

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 (23 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.
1,020 students enrolled
Last updated 1/2017
$10 $50 80% off
2 days left at this price!
30-Day Money-Back Guarantee
  • 3.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Learn How to Create Interactive Charts & Graphs From Your Data
View Curriculum
  • PC, Microsoft Excel 2010, 2013 or Later

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 is the target audience?
  • Users with a basic knowledge of Microsoft Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 36 Lectures Collapse All 36 Lectures 03:21:39
Chart Basics
7 Lectures 36:23

0202 Creating Charts Quickly

0203 Use Sparklines To Create Inline Charts

0204 Chart Areas Plot Chart Legends

0205 Filtering An Existing Chart

0206 The Right Chart Type Matters

0207 The Chart Sub Ribbons And Properties Box
The Design Tab
7 Lectures 40:14
0301 Moving Charts And Switching Rows And Columns

0302 Changing The Default Chart Type

0303 Chart Layouts Styles And Colors

0304 Adding And Removing Chart Elements

0305 Dealing With Hidden Or Empty Cells

0306 Dynamic Titles

0307 Trend Lines Used To Help Analyze Data
The Format Tab
6 Lectures 41:46
0401 Adding And Manipulating Shapes

0402 Add WordArt And Use Of WordArt Styles

0403 Adding Static And Dynamic Text Boxes

0404 Using Pictures Or Textures As Chart Element Backgrounds

0405 Altering Axis Formatting And Plotting

0406 Managing Data Labels
Special Chart Types
6 Lectures 40:03
0501 Multiple Chart Types In The Same Chart

0502 Multiple Pie Charts In The Same Sheet

0503 Pie Of A Pie

0504 Charting Stock Movements

0505 Radar Charts In Action

0506 Scatter Charts Explained
Chart Data
3 Lectures 17:26
0601 Changing A Charts Date Source

0602 Creating Charts From Multiple Data Sources

0603 What Happens When I Copy Sheets With Charts?
Printing And Sharing Charts
3 Lectures 14:06
0701 How To Print Charts

0702 Chart Templates

0703 Copying And Linking Charts To Other Office Applications
The End
1 Lecture 03:57
0801 Charts In Summary
About the Instructor
4.4 Average rating
33,909 Reviews
665,999 Students
331 Courses
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.

Report Abuse