Handling Data
Get a handle on handling data in Excel!
Start
Key Concepts
Review core concepts you need to learn to master this subject
Importing data into Excel
CSV Delimiters
Formatting in Excel
Trimming Whitespace in Excel
Truncating Text in Excel
Converting to Lowercase in Excel
Protecting sheets in Excel
Security in Excel
Importing data into Excel
Importing data into Excel
CSV files must be imported into Excel for all Excel features to function, whereas Excel documents can be opened directly.
Handling Data
Lesson 1 of 1
- 1Even 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 ski…
- 2Many datasets are stored in formats other than Excel’s XLSX format. One of the most common storage formats used across the data science world is the CSV or comma-separated values format…
- 3After importing a data file, we’re often eager to get started with exploratory data analysis. Unfortunately, raw data is often messy data. If we don’t take some time to inspect and clean a dataset,…
- 4Before moving on to analysis, we also need to inspect and validate numeric data. There’s no one rule for what valid numeric data looks like, since the definition of “invalid” data depends on what w…
- 5Because Excel is used to visually explore datasets and present those datasets for others, we often want to change the way tables are displayed to improve human readability. We’ve loaded a table of…
- 6Okay, so we’ve explored a dataset and have some preliminary results to share with a team member. But our team member doesn’t use Excel much, and we don’t want them to accidentally overwrite a cruci…
- 7Congratulations! You’re now ready to analyze data from start to finish in Excel. You’ve learned how to prepare for analysis by: * importing raw data into Excel from CSVs * cleaning inconsistent te…
What you'll create
Portfolio projects that showcase your new skills
How you'll master it
Stress-test your knowledge with quizzes that help commit syntax to memory