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.

[LF_dataworld]

Course Forum