Skip to main content

Exploratory Data Analysis in Spreadsheets


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.
Martina Chiari Headshot
Martina Chiari

Senior Manager, Finance and Strategy

View More Webinars

Hands-on learning experience

Companies using DataCamp achieve course completion rates 6X higher than traditional online course providers

Learn More

Upskill your teams in data science and analytics

Learn More

Join 2,500+ companies and 80% of the Fortune 1000 who use DataCamp to upskill their teams.

Don’t just take our word for it.