Data visualization and analysis in Excel

Learn how to create well-design visuals and conduct basic data analysis in Excel
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.
4 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 12
  • Length 1 hour
  • 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 10/2015 English

Course 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 lean how to create great graphs in Excel, you will 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

What are the requirements?

  • Need intermediate Excel skills
  • Understand Excel formulas
  • Know how to make a basic graph/chart in Excel

What am I going to get from this course?

  • 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

What 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

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: Intro
Introduction
Preview
02:19
Section 2: Preparation
04:08

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

07:07

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

Section 3: Graphing your Data
8 pages

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

07:16

We are ready to graph!

03:09

Learn the basics of good design and formatting.

03:10

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

03:38

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

02:39

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

Section 4: Special Styles
15:29

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.

11:46

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

Section 5: Wrapup
00:41

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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

Ready to start learning?
Take This Course