Microsoft Excel – Basic Data Visualization in Excel

Microsoft Excel – Basic Data Visualization in Excel, available at Free, has an average rating of 4.52, with 12 lectures, based on 2100 reviews, and has 32807 subscribers.

You will learn about Learn to create well-designed graphs in Excel Learn how to format graphs beyond the default settings in Excel Clean your data in Excel to make it "graph-worthy" Use vlookups and Pivot Tables to summarize data Design graphs in Excel similar to the ones in today's most respected publications This course is ideal for individuals who are Anyone who wants to learn how to visualize data in Excel or Anyone who wants to become better at Excel or Knowing how to work with Pivot Tables and basic Excel formulas will help It is particularly useful for Anyone who wants to learn how to visualize data in Excel or Anyone who wants to become better at Excel or Knowing how to work with Pivot Tables and basic Excel formulas will help.

Enroll now: Microsoft Excel – Basic Data Visualization in Excel

Summary

Title: Microsoft Excel – Basic Data Visualization in Excel

Price: Free

Average Rating: 4.52

Number of Lectures: 12

Number of Published Lectures: 12

Number of Curriculum Items: 12

Number of Published Curriculum Objects: 12

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Learn to create well-designed graphs in Excel
Learn how to format graphs beyond the default settings in Excel
Clean your data in Excel to make it "graph-worthy"
Use vlookups and Pivot Tables to summarize data
Design graphs in Excel similar to the ones in today's most respected publications

Who Should Attend

Anyone who wants to learn how to visualize data in Excel
Anyone who wants to become better at Excel
Knowing how to work with Pivot Tables and basic Excel formulas will help

Target Audiences

Anyone who wants to learn how to visualize data in Excel
Anyone who wants to become better at Excel
Knowing how to work with Pivot Tables and basic Excel formulas will help

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

Course Curriculum

Chapter 1: Intro

Lecture 1: Introduction

Chapter 2: Preparation

Lecture 1: Prepping your data

Lecture 2: Cleaning and organizing data with Vlookups

Chapter 3: Graphing your Data

Lecture 1: Choosing the right graph

Lecture 2: Let's graph

Lecture 3: Formatting your graphs

Lecture 4: Changing graph styles

Lecture 5: Changing a graphs colors

Lecture 6: Using your graphs outside of Excel

Chapter 4: Special Styles

Lecture 1: Create a graph in "The Economist" style

Lecture 2: Create a graph in "Five Thirty Eight" style

Chapter 5: Wrapup

Lecture 1: Course Takeaways

Instructors

Sean John Thompson
Excel Mastery: Unlock Powerful Analytical Skills Fast!

Rating Distribution

1 stars: 25 votes
2 stars: 69 votes
3 stars: 370 votes
4 stars: 841 votes
5 stars: 795 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu