Working with spreadsheets

Categories: Data Science
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Participants will learn how to use spreadsheet software to organize, clean, and summarize datasets. The module covers essential spreadsheet functions, sorting and filtering, data validation, and creating visual summaries using charts. By the end, learners will be able to prepare a clean, structured dataset ready for statistical analysis or visualization.

What Will You Learn?

  • Learn how to take advantage of the superpowers of Excel and Google Sheets for data cleaning and analysis. Participants will:
  • · Spreadsheet basics
  • · Data cleaning
  • · Formulas: SUM, AVERAGE, IF, COUNTIF, VLOOKUP
  • · Sorting & filtering
  • · Chart creation

Course Content

Microsoft Excel Fundamentals for DataScience
Examples.

Spreadsheet basics

Sorting & filtering

Formulas: SUM, AVERAGE, IF, COUNTIF, VLOOKUP

Data cleaning

Chart creation

Student Ratings & Reviews

No Review Yet
No Review Yet