Excel Data Visualization
3.5 (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.
8 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Data Visualization to your Wishlist.

Add to Wishlist

Excel Data Visualization

Learn how to visualize data in Excel
3.5 (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.
8 students enrolled
Created by Sean J. Thompson
Last updated 11/2015
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn to create well-designed graphs in Excel
  • Learn how to format graphs beyond the default settings in Excel
  • Learn how to create "graph-worthy" data
  • Use vlookups and Pivot Tables to summarize data prior to graphing
  • Design graphs in Excel similar to the ones in today's most respected publications
View Curriculum
Requirements
  • Need basic to intermediate Excel skills
  • Understand Excel formulas
  • Know how to make a basic graph/chart in Excel
Description

Welcome and thanks for your interest in my course!

Learn and master the art of creating a well-designed data visualizations and basic data analysis in Excel in this wide-ranging course. Forget the same old default Excel graphs that are boring and without personality - you can do better than that! This course will help your to go beyond the basics of graphing and teach you how to design graphs with your intended audience in mind. Not only will you learn how to create great graphs in Excel, but you will also learn how to organize your data before graphing to make the process easier and more productive.

A few of the topics we will cover in this course include:

  • How to determine if your data is graph-worthy
  • How to organize your data prior to visualization
  • Using vlookups to enhance your datasets
  • Designing your graphs for your audience
  • Using your visualizations outside of Excel
  • and a few other surprises....

This course is mostly video based, but does include all of the Excel spreadsheets used throughout the course. Use these spreadsheets and documents as a resource after you complete the course. They are yours to keep and use as a reference in the future.

This course will allow you to use the Excel skills you already have and take them to the next level. This course was designed with you - the student in mind. My goal is for you to be able to implement the skills your learn in this course immediately once you have completed it.

I hope you enjoy the course and that your use the skills learned to enhance your skillset and wow your boss and coworkers!

- Sean

Who is the target audience?
  • This is a relatively fast paced course geared ot those that have some experience in Excel
  • Knowing how to work with Pivot Tables and basic Excel formulas will help
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
01:09:22
+
Intro
1 Lecture 02:19
+
Preparation
2 Lectures 11:15

Prepare you data from graphing by making it graph-worthy.

Preview 04:08

Learn how to use the power of Vlookups and Pivot Tables to clean up and organizae your data prior to graphing.

Cleaning and organizing data with Vlookups
07:07
+
Graphing your Data
6 Lectures 19:52

Before you start graphing in Excel, lets learn how to choose the right graph for your data type and visualization expectations.

Choosing the right graph
8 pages

We are ready to graph!

Let's graph
07:16

Learn the basics of good design and formatting.

Formatting your graphs
03:09

Learn how to change a bar graph to a line graph.

From a bar to a line graph
03:10

Let's change things up a bit and bring in some new color schemes for our graphs.

Changing a graphs color scheme
03:38

Learn how to paste your data into programs outside of Excel such as PowerPiont.

Pasting your graphs into PowerPoint
02:39
+
Special Styles
2 Lectures 27:15

This video will teach you how to make a graph in Excel in the Economist style. The Economist is a very well respected weekly newspaper know for their journalism focused on finance and world politics. The Economist is also one of the best data visualizers out there.

Preview 15:29

Learn how to create an Excel graph in the style of the ever popular data analysis and vizualization website FiveThirtyEight.

Preview 11:46
+
Wrapup
1 Lecture 00:41

Let's wrap this course up with a few takeaways.

Course Takeaways
00:41
About the Instructor
Sean J. Thompson
3.5 Average rating
2 Reviews
8 Students
1 Course
Analyst

With 10+ years of reporting, analytics and Excel experience I enjoy taking abstract or complicated topics and simplifying them in order to make them useful. Teaching others and helping them achieve their goals is a passion of mine.