Introduction to Excel 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.
7 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

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.
7 students enrolled
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 21 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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!
View Curriculum
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!
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!

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 21 Lectures Collapse All 21 Lectures 55:57
+
Data Cleaning
5 Lectures 13:33
+
Creating a Static Report
7 Lectures 23:22
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
+
Making an Interactive Dashboard
7 Lectures 16:57
Introduction to Making a Dashboard
01:20

PivotTables
03:16

Basic Formatting
02:54


Slicers
01:09

Formatting Charts
04:18

Formatting Slicers
02:59
+
Wrapping Up
2 Lectures 02:05
Course Summary
01:01

Thank You and Next Steps!
01:04
About the Instructor
TechChange The Institute for Technology and Social Change
0.0 Average rating
0 Reviews
7 Students
1 Course
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.