Mastering Microsoft Excel - Charts In Detail
4.3 (25 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,027 students enrolled
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.3 (25 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,027 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn How to Create Interactive Charts & Graphs From Your Data
View Curriculum
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 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
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
+
The Design Tab
7 Lectures 40:14
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
+
The Format Tab
6 Lectures 41:46
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
+
Special Chart Types
6 Lectures 40:03
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
+
Chart Data
3 Lectures 17:26
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
+
Printing And Sharing Charts
3 Lectures 14:06
0701 How To Print Charts
03:36

0702 Chart Templates
03:33

0703 Copying And Linking Charts To Other Office Applications
06:57
+
The End
1 Lecture 03:57
0801 Charts In Summary
03:57
About the Instructor
Infinite Skills
4.4 Average rating
37,992 Reviews
688,555 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.