In this lesson, you’ve learned how to explore datasets in Excel using three key methods:

  • formulas to summarize and transform data
  • sorting to organize data for visual inspection
  • filtering to zoom in on data points with specified features

Specifically, you’ve learned how to

  • use built-in Excel functions to find out the average, maximum, and sum of a set of numbers
  • use draggable cell references and formulas to determine percents and baseline comparisons from raw data
  • use sorting on multiple columns to gain insight into trends over time
  • use filtering to answer questions about datapoints matching specific criteria

These are the essential skills you need to explore data in Excel and prepare for formal analysis. Congratulations on completing the lesson!


When you’re ready to take your Excel skills to the next level, select Up Next!

Take this course for free

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?