Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart (Programming Language) Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel Charts

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
Rating: 4.4 out of 54.4 (46 ratings)
1,092 students
Created by Infinite Skills
Last updated 1/2017
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

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

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

Course content

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

  • Preview00:01
  • Preview05:51
  • Preview01:52

  • Preview04: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

  • 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

  • 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

  • 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

  • 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

  • 0701 How To Print Charts
    03:36
  • 0702 Chart Templates
    03:33
  • 0703 Copying And Linking Charts To Other Office Applications
    06:57

  • 0801 Charts In Summary
    03:57

Instructor

Infinite Skills
High Quality Training
Infinite Skills
  • 4.3 Instructor Rating
  • 118,462 Reviews
  • 1,239,886 Students
  • 327 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.