Even the most advanced analytics techniques are only as good as the data being used and the clarity with which results are presented. So handling your data properly is one of the most important skills you can learn in data analysis.
In this lesson, you’ll learn how to prepare for analysis by
- importing external datasets from CSV files
- cleaning and validating data prior to analysis
You’ll also learn how to present your analysis by
- formatting tables for human readability
- protecting data when sharing spreadsheets with others
Ready to get a handle on handling data in Excel? Select