Formulas, filtering, and sorting are powerful tools! But combining them to answer complex data questions can be tricky. Excel solves this problem for many common data questions through the PivotTable tool.

In this lesson you’ll learn how to take a question about data and

  • Determine if a pivot table is appropriate
  • Translate the question into pivot table settings
  • Create the pivot table in Excel
  • Update the pivot table with new data


Ready to pivot to learning about pivot tables? Click 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?