Key Concepts

Review core concepts you need to learn to master this subject

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
  1. 1
    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 ski…
  2. 2
    Many 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…
  3. 3
    After 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,…
  4. 4
    Before 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…
  5. 5
    Because 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…
  6. 6
    Okay, 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…
  7. 7
    Congratulations! 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

Pro Logo

How you'll master it

Stress-test your knowledge with quizzes that help commit syntax to memory

Pro Logo