Welcome to Week Two
This week we’re going to focus on preparing our data set for analysis by understanding it, ordering, cleaning, and transforming it into the format we need.
We’re going to cover the fundamentals of working efficiently with spreadsheets. We’ll also start processing our data so that we can remove errors, focus on accurate outcomes, and start looking for some answers. Specifically, we’ll cover:
- Working with spreadsheets, saving, backing up, design principles
- Handling data: sorting and filtering
- Cleaning data: using Excel functions and formulae to transform our data set
In the next step, we’re going to delve into how we can think about our data and then clean it up. Ready?
Reach your personal and professional goals
Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.
Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.
