Analysis for Excels
Excel analysis is summarising and presenting data. A PivotTable groups and totals rows by fields you drag into rows, columns, values and filters, without writing formulas. Charts such as column, line and pie then turn those summaries into visuals, and slicers add interactive filtering.
Stage: Reporting · Part of the Excel roadmap · Last reviewed 19 November 2026
What to learn in Analysis
- Create a PivotTable that totals sales by region and month
- Group dates into months and quarters and show values as a percentage of total
- Refresh a PivotTable after the source data changes
- Choose a column, line, bar or pie chart suited to the question
- Add slicers and a PivotChart to build a simple interactive summary
Analysis interview questions
Why does a PivotTable not update when I change the source data?
PivotTables keep a cached copy of the data and refresh only on request. Right-click and choose Refresh, or set refresh on open. If you added rows outside the original range, change the data source or base it on an Excel Table.
When should you use a line chart instead of a column chart?
Use a line chart for continuous change over time, such as monthly trends, where the slope matters. Use a column chart to compare discrete categories or a few time periods. Pie charts suit only a few parts of a single whole.
Where Analysis fits in the Excel roadmap
Analysis belongs to the Reporting stage (beginner level). Show insights.
Other units in this stage
Back to the full Excel roadmap