Manipulating data in Excel – review

Citizen Data Scientist 201 Day 1


Review slides 1 – 43 for the following topics:

Importing data
Formatting spreadsheets
Aggregating data & table lookups

Complete the following exercises:

Exercise 1 – Data import

Exercise 2a – Aggregating data

Exercise 2b – Merging and sorting data tables

Complete Concept Review 1: manipulating data in Excel in the Assessment tab to complete this lesson

Please note that this concept review goes over topics from Citizen Data Scientist 101 as a refresher for Citizen Data Scientist 201.


Course Forum

Front Page Forums Search


  • You do not have permission to view this forum.