Easy Data Visualiation data with Microsoft Excel

Advance your career by creating attention-grabbing charts and graphics; Obtain deep insights by visualizing data.
0.0 (0 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.
9 students enrolled
$20
Take This Course
  • Lectures 12
  • Contents Video: 41 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course 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!


What are the requirements?

  • You should be comfortable with organizing data using Microsoft Excel
  • You need to have either PC or Mac version of Microsoft Excel

What am I going to get from this course?

  • 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

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction
Preview
05:20
Section 2: What is your goal in visualization?
Visualize Stock Market Movement with VLOOKUP
Preview
02:51
Section 3: Use Colors to Visualize Data
(For Mac) Visualize Stock Market Movement with Conditional Formatting
Preview
03:37
(For PC) Visualize Stock Market Movement with Conditional Formatting
04:27
Section 4: Scattered Plots, Line Chart, and Bar Chart
Relationship between two stocks: Scattered Plot
02:31
Bar Chart vs. Line Chart
01:22
Radar Chart
02:49
Section 5: Visualize Statistical Distributions (such as the Bell Curve)
Use Histogram Tool to Visualize Stock Market Changes
03:45
Stock Market Changes: Use PivotChart to Draw Distribution Chart
03:16
Section 6: 3-D Chart and heat map are two tools to Visualize 3-way Interaction
Mortgage payment for different down payments and interest rates: 3-way Analysis
05:27
Use heat map to illustrate 3-way interaction
01:40
Section 7: Project Management with Gantt Chart
Draw a Gantt chart in managing projects
04:00

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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.

Ready to start learning?
Take This Course