Skip to main content

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

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.

Back to the full Excel roadmap