Exploratory Data Analysis in Spreadsheets

WebinarSeptember 2023

Spreadsheets are a great tool for quickly exploring data, and this training covers techniques for rapidly extracting insights from a new dataset. You'll explore Fortune 500 data, creating summary statistics, pivot tables, and visualizations to identify patterns and trends in the world’s largest businesses.

Key Takeaways:

Learn to implement exploratory data analysis techniques in Google Sheets.
Learn to write spreadsheet formulas for data analysis. We will in particular learn these: XLOOKUP, FILTER, SUMIF, COUNTIF as well as Pivot Tables and Charts.
Learn how to organize your spreadsheets to communicate your results.

Code-along with us!

Solution Sheet

Dataset

[SKILL TRACK] Spreadsheet Fundamentals

[SKILL TRACK] Finance Fundamentals in Spreadsheets

[SKILL TRACK] Excel Fundamentals

[CHEAT SHEET] Data Manipulation in Excel

[CHEAT SHEET] Excel Formulas

[INFOGRAPHIC] Data Science Learning Checklist

[TUTORIAL] Visualizing Data in Excel

[TUTORIAL] How to Create a Dashboard in Excel in 3 Easy Steps

[TUTORIAL] The 15 Basic Excel Formulas Everyone Needs to Know