★ Must-know
🔄 Create a PivotTable by following these steps:
The four PivotTable areas are:
Further detail
1. You need to build a PivotTable from a new dataset and place it on a separate sheet. Which setup sequence should you use?
2. You want a PivotTable to show one row per region, one column per product, and total sales for each combination. Where should each field go?
3. A PivotTable lists many regions, and you need to display just the five regions with the largest sales totals. Which action should you take?
How do you open the PivotTable creation dialog after converting source data to an Excel Table?
Choose Insert > PivotTable > From Table/Range > New Worksheet.
What does a PivotTable field placed in Rows display?
One row per item.
What does a PivotTable field placed in Columns display?
One column per item.
What can the Values area do with numbers?
Sum, count, or average them.
What does the Filters area let you display?
Selected data.
Which value-sorting order can PivotTable analysis apply?
Largest to smallest.
It covers the core concepts of Excel Optimization and Data Analysis, organized by topic with the key definitions, explanations and takeaways, so it's easier to learn and remember.
Read the full study guide →The practice quiz has 17 multiple-choice questions, each with an explanation. Use it to check what you know and find your gaps.
Take the quiz (17 questions) →There are 45 flashcards on Excel Optimization and Data Analysis, with a question on the front and the answer on the back. Try to recall each answer before you flip, and let spaced repetition bring back the ones you miss.
See all 45 flashcards →Upload a PDF or paste your notes. Revizly writes a study guide, a practice quiz and flashcards in about a minute.