Introduction to Excel for Data Visualization

Quick and easy tutorials on Excel's most useful features for data visualization
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 21
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English, captions
  • 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 1/2016 English Closed captions available

Course Description

Excel offers a valuable set of features that can be utilized to meet a wide range of data analysis and visualization needs, and we created an interactive and compelling course to help you rapidly develop these skills.

By the end of this course, you will be able to make beautiful reports and interactive dashboards that best convey your data!

**We also have two MAJOR BONUSES for students who complete this course!**

1. BONUS CONTENT: Students who complete this course will be automatically enrolled in our COMPLETE Excel for Data Visualization course on the TechChange platform, at no extra cost. You'll get an extra hour of course material and learn the following:

  • Learn data visualization principles that are critical to making charts with a clear purpose and clean data.
  • Apply these principles to three example graphs with detailed step-by-step explanations.
  • Explore real-world case studies from the global health and political sectors that employ these techniques.
  • Put your Excel skills to the test with scenario exercises

2. A FULL REFUND: Students who complete the course and leave a course evaluation on Udemy will receive a full refund from TechChange. This offer is only for a limited time, so sign-up today before it's gone!

What are the requirements?

  • Excel 2010 or 2013 for PC or Mac. This course was recorded using Excel 2013 for PC but all concepts taught are compatible with Excel 2010 as well. Please note that PivotCharts and Slicers are not available in Excel for Mac at this time.
  • Desire to learn and explore all that Excel offers!

What am I going to get from this course?

  • Apply time-saving Excel functions and techniques to format columns, tables, and cells (i.e. highlight all blank cells in red)
  • Create beautiful reports with pie charts, dot plots, bar, and line graphs
  • Modify your charts for clarity and alignment with your brand
  • Learn basic VBA, the programming language used in Excel, to write code that will automate repetitive tasks (i.e. abbreviate long country names automatically)
  • Use INDEX MATCH and VLOOKUP to find corresponding data entries and locate information quickly
  • Use COUNTIF to tally up the number of cells that meet desired criterion (i.e. number of countries with zero viruses)
  • See trends in your data with Sparklines
  • Learn what a PivotTable is, and why it is a popular choice for displaying more than two fields of data at a time
  • Create PivotCharts to quickly analyze data
  • Learn about Slicers, which allow you to filter data for multiple charts or tables
  • Make dashboards containing tables and graphs that adjust at the click of a button!

What is the target audience?

  • Beginning Excel users
  • Anyone who wants to touch up on critical Excel functions
  • Anyone who wants to build engaging data visualizations

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: Data Cleaning
Introduction to Data Cleaning
Preview
01:15
Column Formatting
Preview
02:21
Table Formatting
Preview
02:12
Macros
Preview
03:37
Conditional Formatting
04:08
Section 2: Creating a Static Report
Basic Functions
04:54
INDEX MATCH
02:45
VLOOKUP
02:43
COUNTIF
01:33
Sparklines
02:39
Line, Bar, Pie Charts
04:26
Dot Plot
04:22
Section 3: Making an Interactive Dashboard
Introduction to Making a Dashboard
01:20
PivotTables
03:16
Basic Formatting
02:54
PivotCharts
Preview
01:01
Slicers
01:09
Formatting Charts
04:18
Formatting Slicers
02:59
Section 4: Wrapping Up
Course Summary
01:01
Thank You and Next Steps!
01:04

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

TechChange The Institute for Technology and Social Change, Learn new skills, build your network and grow your career

TechChange provides online professional development at the intersection of technology and social good. We connect those who wish to make a social impact with relevant content, experts, and certification using our proprietary learning platform. Our global network includes leading governmental, private sector and non-governmental institutions and 10,000+ individual students from 198 countries.

Ready to start learning?
Take This Course