Easy Data Visualiation data with Microsoft Excel
2.0 (2 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.
12 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Easy Data Visualiation data with Microsoft Excel to your Wishlist.

Add to Wishlist

Easy Data Visualiation data with Microsoft Excel

Advance your career by creating attention-grabbing charts and graphics; Obtain deep insights by visualizing data.
2.0 (2 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.
12 students enrolled
Created by Justin Ren
Last updated 5/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 41 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Have a clear strategy in visualizing data
  • Identify the best type of graph that deliver the insights in your data
  • Master the tools in visualizing data using Microsoft Excel
View Curriculum
Requirements
  • You should be comfortable with organizing data using Microsoft Excel
  • You need to have either PC or Mac version of Microsoft Excel
Description

A picture is worth 1,000 words.

The same is true in business communication.

In the age of "big data", communicating through good charts and graphs is essential.

On the other hand, Microsoft Excel is the "gold standard" in data analysis. This course is about how to make GREAT Excel charts and graphs for better communication.

In this course we will cover a variety of visualization techniques and types of graphs:

  • Conditional formatting
  • Bar charts
  • Line plots
  • Scattered plots
  • 3-D graphs
  • Radar charts
  • Gantt charts
  • Heat maps
  • ...

The key question we ask in this course is this:

What is the best graph to draw that will tell - loudly and clearly - what I want to tell about this data?

After taking this course, you will be be able to identify the best way to convey your thoughts and your analytics insights - visually.

Your business presentation will be so much more effective with great charts that your communication will be much more impactful.

Sign up NOW and start make an impact in your work TODAY!


Who is the target audience?
  • If you are interested in making better graphs in Microsoft Excel, this course is for you.
  • If you are interested in learning the various data visualization techniques in Excel, this course is for you.
  • If you are interested in how to analyze data better by visualization, this course is for you.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Introduction
1 Lecture 05:20
+
What is your goal in visualization?
1 Lecture 02:51
+
Use Colors to Visualize Data
2 Lectures 08:04

(For PC) Visualize Stock Market Movement with Conditional Formatting
04:27
+
Scattered Plots, Line Chart, and Bar Chart
3 Lectures 06:42
Relationship between two stocks: Scattered Plot
02:31

Bar Chart vs. Line Chart
01:22

Radar Chart
02:49
+
Visualize Statistical Distributions (such as the Bell Curve)
2 Lectures 07:01
Use Histogram Tool to Visualize Stock Market Changes
03:45

Stock Market Changes: Use PivotChart to Draw Distribution Chart
03:16
+
3-D Chart and heat map are two tools to Visualize 3-way Interaction
2 Lectures 07:07
Mortgage payment for different down payments and interest rates: 3-way Analysis
05:27

Use heat map to illustrate 3-way interaction
01:40
+
Project Management with Gantt Chart
1 Lecture 04:00
Draw a Gantt chart in managing projects
04:00
About the Instructor
Justin Ren
3.4 Average rating
146 Reviews
2,177 Students
6 Courses
Professor

Dr. Justin Ren is an Associate Professor of Business Administration in the Operations and Technology Management Department, Dean's Research Fellow, and Senior Fellow of Health Policy Institute at Boston University School of Management. He was also a Visiting Scholar and Research Affiliate at Massachusetts Institute of Technology (MIT) Sloan School of Management from 2009-2013.

For almost ten years, Professor Ren has been teaching analytics courses which focuses on tools and frameworks that help managers gain market intelligence and make strategic decisions. He also teaches in executive education in financial risk management. He is a certified teacher by the Harvard Business School Case Method Discussion Leadership Program.

Professor Ren has consulted for Fortune 500 companies as well as start-ups. His work has been mentioned in Sloan Management Review, China Daily, and the World Financial Review. He has been invited to give lectures and presentations around the world at institutions such as Harvard University, MIT, Duke, Dartmouth, Georgetown, Emory, INSEAD (France), Hong Kong University of Science and Technology, Peking University (China), and Tsinghua University (China).

Professor Ren received his M.S. in Operations Research and Ph.D. in Operations and Information Management from The Wharton School at the University of Pennsylvania.