Skip to main content

edX: Intro Course: Spreadsheets and Statistics

Bridge the gap between what you know and the skills you need to ensure your success and efficiency in an office setting. This course is ideal for learners who are just starting out in their professional careers, those looking to add some hard skills to their soft skills, or those looking to make the leap from contractor to full-time employee.

Intro Course: Spreadsheets and Statistics
4 weeks
20–40 hours per week
Self-paced
Progress at your own speed
Free
Optional upgrade available

There is one session available:

After a course session ends, it will be archivedOpens in a new tab.
Starts Mar 28

About this course

Skip About this course

Spreadsheet proficiency is a superpower. Learn how to use the various functionalities of Google Sheets to manipulate, inspect, and interpret data, separating the noise from what’s actually happening in your data set.

This course is ideal for anyone interested in building their professional toolkit and growing their career with hard skills such as:

  • Understanding the anatomy of a spreadsheet
  • Using formulas to automate manual processes
  • The ability to work with data sets in Google Sheets
  • Knowing which data matters when answering a business question
  • Identifying the level of importance to assign to your results

At a glance

  • Language: English
  • Video Transcripts: اَلْعَرَبِيَّةُ, Deutsch, English, Español, Français, हिन्दी, Bahasa Indonesia, Português, Kiswahili, తెలుగు, Türkçe, 中文
  • Associated skills:Anatomy, Google Sheets, Spreadsheets

What you'll learn

Skip What you'll learn
  • Master the basics of data analysis in Google Sheets with formatting, formulas, calculations, and charts.
  • Prepare data by importing from disparate sources and reducing noise with data cleaning tactics.
  • Evaluate the quality of your data and how to best use it.
  • Utilize out-of-box statistical visualizations to aid in your exploratory data analysis.

Introduction to Spreadsheets

  • The anatomy of a spreadsheet
  • Applying basic formatting to data to improve readability
  • Manipulating data using rows, columns, and ranges
  • Using Formulas and calculations
  • Creating charts in Google Sheets and using spreadsheets to communicate insights.

Data Preparation

  • The importance of data preparation for effective data analysis
  • Importing data from different sources
  • Working with datasets in Google Sheets
  • Raw data characteristics and common issuesData cleaning
  • Using pivot tables to summarize data
  • Creating dashboards in Google Sheets

Statistics Fundamentals

  • Mean, median, and mode definitions and finding them in Google Sheets
  • Visualizing the mean in a chart
  • Identifying min, max, and range of a data set
  • Methods for inspecting data
  • Using and interpreting bar charts, line charts, and histograms

Exploratory Data Analysis

  • Identifying patterns of data distribution
  • Skew, distribution, and percentilesCalculating variance
  • Calculating standard deviation
  • Calculating z-score and interpreting it visually
  • Creating and interpreting scatterplots

Interested in this course for your business or team?

Train your employees in the most in-demand topics, with edX For Business.