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 CompTIA Security+ 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 Mindfulness Personal Transformation 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 Online Business 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
Business Business Analytics & Intelligence Excel Charts

Data Visualization in Excel: All Excel Charts and Graphs

25+ Excel charts and graphs - Data Visualization in Microsoft Excel - visualizing data with Excel 2007- Excel 2019
Rating: 4.4 out of 54.4 (1,240 ratings)
110,563 students
Created by Start-Tech Academy
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn the techniques to communicate clear and concise message through your charts
  • Learn how to create 25+ chart types in Excel
  • Learn by Doing. Course comes with numerous exerises sheets to practice learnt concepts
  • Master the art of creating impactful Excel charts
  • Get familiar with all the elements of charts in Excel
  • Become proficient in using powerful tools such as pivot tables and pivot charts
  • Master newly introduced chart types such as sunburst, treemap and waterfall chart
  • Learn how to create cool infographics to represent data

Requirements

  • You will need a PC with any version of Excel installed in it
  • Basic understanding of Excel operations like opening, closing and saving a file

Description

What are the chart types I will learn in this course?

Excel offers the following major chart types. All of these are covered in this course

  •     Column Chart

  •     Line Chart

  •     Pie Chart

  •     Doughnut Chart

  •     Bar Chart

  •     Area Chart

  •     XY (Scatter) Chart

  •     Bubble Chart

  •     Stock Chart

  •     Surface Chart

  •     Radar Chart

  •     Combo Chart

  •     Pivot Chart

  •     Sparklines

And many other creative ones :)


How are charts useful in Excel?

A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier.


What are the benefits of using charts in Excel?

Excel charts allow spreadsheet administrators to create visualizations of data sets. By highlighting a set of data within an Excel spreadsheet and feeding it into the charting tool, users can easily create various types of charts in which the data is displayed in a graphical way.


This course will answer all the questions that would pop up while you set to visualize your data using Excel charts such as:

How do you make Excel charts look better?

How do you format a chart in Excel?

What are the different elements of charts?

How do I make those awesome infographics that I see in fancy magazines and TV reports?

How do I create a comparison chart in Excel?

What is the best chart to use for comparison?

And many more...


How is this course different from other resources available online?

Most courses cover only teach how to draw different types of charts in Excel. The main point is missed. The main point of creating a chart is that you want to convey a message or tell a story using the chart. In this course, once you have learnt all the charting tools, you will also learn how you should create a chart. How you can highlight your message and avoid clutter in the chart, so that when your audience looks at the chart, the message is clearly conveyed to them.


Who this course is for:

  • Anyone curious to master charts in excel from beginner to advanced in short span of time

Course content

8 sections • 46 lectures • 4h 33m total length

  • Preview02:53
  • Why are charts used?
    02:11
  • Course Resources
    00:08
  • This is a milestone!
    03:31
  • Categories of messages that can be conveyed
    04:34
  • Quiz
    1 question
  • Preview05:32
  • The Easy way of creating charts
    03:17
  • Quiz
    2 questions

  • Preview12:38
  • Formating charts
    15:13
  • Exercise 1: Bar and Column Charts
    00:12
  • Best Practices: Bar Chart
    10:07
  • Line Charts
    09:04
  • Quiz
    1 question
  • Avoiding the Spaghetti plot
    05:27
  • Exercise 2: Line Charts
    00:11
  • Area Charts
    06:04
  • Pie and Doughnut Charts
    13:04
  • Why we should avoid Pie charts!
    04:05
  • Exercise 3: Pie Charts
    00:13
  • Quiz
    1 question
  • Scatter plot or XY chart
    16:17
  • Exercise 4: Scatter plot
    00:09
  • Frequency Distribution and Histograms
    13:03
  • Exercise 5: Histogram
    00:09
  • Waterfall chart
    12:00
  • Exercise 6: Waterfall chart
    00:12
  • Hierarchy Charts: Sunburst and Treemap
    07:57
  • Exercise 7: Hierarchy charts
    00:09
  • Combination charts
    07:32
  • Exercise 8: Combination Charts
    00:08
  • Quiz
    1 question
  • Highlighting chart message
    03:25
  • Eliminating Distractions from the Graph
    06:54
  • Avoiding clutter
    05:35
  • [Optional] Test for your general excel knowledge
    18 questions

  • Pivot Charts
    07:48
  • Pivot Table Basics
    08:25
  • Exercise 9: Pivot charts
    00:09
  • Quiz
    2 questions

  • Stock charts
    11:28
  • Radar charts
    04:51
  • Surface charts
    05:14
  • Heatmaps
    04:55
  • Quiz
    1 question

  • Mini charts: Sparklines
    05:43
  • Exercise 10: Sparklines
    00:11
  • Practice Test 1
    10 questions

  • Creative Infographic 1
    14:12
  • Creative Infographic 2
    06:51

  • How to solve transportation problem using Excel Goal-Seek
    12:17
  • Income Tax calculation - Slabs based tax
    17:24

  • The final milestone!
    01:33
  • Congratulations & About your certificate
    00:39

Instructor

Start-Tech Academy
1,700,000+ Enrollments | 4+ Rated | 160+ Countries
Start-Tech Academy
  • 4.4 Instructor Rating
  • 38,264 Reviews
  • 1,003,352 Students
  • 39 Courses

Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners. 
Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey. 

Founded by Abhishek Bansal and Pukhraj Parikh.

Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in  MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.

Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.


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