Easy Data Visualiation data with Microsoft Excel
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.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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:
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!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
|Section 2: What is your goal in visualization?|
Visualize Stock Market Movement with VLOOKUPPreview
|Section 3: Use Colors to Visualize Data|
(For Mac) Visualize Stock Market Movement with Conditional FormattingPreview
(For PC) Visualize Stock Market Movement with Conditional Formatting
|Section 4: Scattered Plots, Line Chart, and Bar Chart|
Relationship between two stocks: Scattered Plot
Bar Chart vs. Line Chart
|Section 5: Visualize Statistical Distributions (such as the Bell Curve)|
Use Histogram Tool to Visualize Stock Market Changes
Stock Market Changes: Use PivotChart to Draw Distribution Chart
|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
Use heat map to illustrate 3-way interaction
|Section 7: Project Management with Gantt Chart|
Draw a Gantt chart in managing projects
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.