You've already seen the way Microsoft® Excel® functions and features can help you drill down into your data to get answers to very specific questions. Although using sorting and filtering is often a good option for attaining specific answers, these aren't necessarily the best options if you need to frequently change the questions you're asking of your data. To change the question you're asking when using functions, sorting, and filtering, you often need to rewrite functions, adjust criteria, or re-filter your data; sometimes, you need to use several of these methods at the same time. If you work in a high-paced, data-intensive environment, you simply may not have the time needed to recalculate every time a supervisor asks you a different question. You need something a little more dynamic. Excel includes a powerful feature that enables you to ask any number of questions of your data; get detailed, specific answers; and do it all over again in just a matter of moments. By using PivotTables to analyze your data, you can get critical, time-sensitive organizational intelligence to the people who need it quickly, easily, and with a high level of flexibility.

You'll wrap things up and then validate what you've learned in this course by taking an assessment.