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 Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Python
Google Flutter Android Development iOS Development Swift React Native 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
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing 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

This course includes:

  • 3 hours on-demand video
  • 1 article
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Business Business Analytics & Intelligence Excel Charts

Excel Charts - Excel Charts and Graphs Basic Training

Learn how to use Excel 2013 to create impressive data visualizations - ExcelChart and Graphs Basic Training
Rating: 4.3 out of 54.3 (376 ratings)
3,947 students
Created by R-Tutorials Training
Last updated 6/2016
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • create the most common type of charts in Excel
  • know which chart to use for a given dataset
  • perform standard format changes in charts
  • use Excel 2013 confidently for charts and graphs
Curated for the Udemy for Business collection

Requirements

  • Excel 2013 is required - but the previous Excel version has similar features so you might also use your knowledge with the 2010 version
  • interest in data visualization
  • a basic understanding of charts and graphs

Description

Do you work with charts but struggle to identify which chart to use?

Are you new to data analysis?

Do you want to learn about the charting options Excel 2013/2010 offers?

Are you looking for a structured way to learn about the Excel charting tools?

If your answer was YES to some of the questions, this course might be of interest to you.

When I created this course I put full emphasis on a structured and didactically sound way to gently show you how data visualization in Excel 2013 works. This course is especially suited towards a beginners audience to data visualization with Excel.

Most of the concepts of this course also apply to Excel 2010, so you might also consider this course if you are on 2010.

Beginners to data analysis often need a clear understanding of which chart type is suitable for a given dataset. I will give you this important knowledge right at the beginning so that you know from the start what you are dealing with and how you can utilize that knowledge.

I will also show you step by step all you need to know about the basic chart formatting tools. You will learn how to add elements, format axes, change colors and so on.

There is also a section about the frequently used types of charts and how you can easily create them in Excel.

At the end of this beginners course you should be confident in using Excel for standard charts. You will be also able to format already existing charts and tailor them in accordance with your needs.

I highly recommend to take a close look at the introductory videos on which type of chart to use for a given circumstance. Only if you know which chart type is suitable for a dataset will you be able to make full use of the many options Excel has to offer.

Who this course is for:

  • Everybody interested in data visualization
  • Everybody willing to try out the material at home and solve the exercises
  • Everybody starting out to work with Excel
  • Everybody needing charts for work or study purposes

Course content

4 sections • 30 lectures • 2h 50m total length

  • Preview02:39
  • Preview14:52
  • Chart Types - Which chart should I use?
    11:11
  • Chart Types
    4 questions
  • Course Datasets
    00:15

  • Excel Basic Tools - Insert Tab
    05:42
  • Our First Chart - Pie Charts
    08:17
  • Excel Basic Tools - Design Tab
    06:00
  • Excel Basic Tools - Chart Buttons
    03:13
  • Chart Axes
    10:17
  • Exercise - Editing Tools
    07:52

  • Pie of a Pie Chart
    09:29
  • Doughnut Charts
    07:49
  • Scatterplots
    03:57
  • Bubble Charts
    05:05
  • Line Charts
    04:07
  • Area Charts
    03:26
  • Exercise - Lynx Trappings
    04:51
  • Column or Bar Charts - Paired Data
    02:57
  • Dynamic Charts with Tables
    02:11

  • Introduction to New Charts
    01:23
  • Statistical Charts 1: Histogram
    05:05
  • Histogram - alternative method
    07:20
  • Statistical Charts 2: Pareto Chart
    04:16
  • Pareto Chart - alternative method
    06:22
  • Statistical Charts 3: Box and Whisker Plot
    05:21
  • Hierarchical Charts 1: Treemap
    04:19
  • Hierarchical Charts 2: Sunburst
    02:37
  • Which one should I choose? Treemap vs. Sunburst
    02:03
  • Finance: Waterfall Chart
    06:46
  • Waterfall Chart - alternative method
    10:42

Instructor

R-Tutorials Training
Data Science Education
R-Tutorials Training
  • 4.4 Instructor Rating
  • 26,535 Reviews
  • 216,767 Students
  • 23 Courses

  R-Tutorials is your provider of choice when it comes to analytics training courses! Try it out – our 100,000+ students love it. 

        We focus on Data Science tutorials. Offering several R courses for every skill level, we are among Udemy's top R training provider. On top of that courses on Tableau, Excel and a Data Science career guide are available.

        All of our courses contain exercises to give you the opportunity to try out the material on your own. You will also get downloadable script pdfs to recap the lessons. 

        The courses are taught by our main instructor Martin – trained biostatistician and enthusiastic data scientist / R user. 

        Should you have any questions, you are invited to check out our website, you can open a discussion in the course or you can simply drop us a pm. 

        We are here to help you boost your career with analytics training – Just learn and enjoy. 

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