skinny.

Latest / ModeLoop: Financial Modelling in Excel

P2E14: PivotTables in Excel for Financial Analysis - Summarise 40,000 Rows in Seconds

PivotTables in Excel for financial analysis turn a 40,000-row ledger or generation export into a clear summary in seconds, with the ability to drill back to any transaction behind a number.

In this episode:

Getting the data into shape: one record per row and an Excel Table (Ctrl+T) so refresh picks up new rows

Building the pivot: Rows, Columns, Values and Filters, Sum not Count, field number formats and Tabular layout

Grouping dates into quarters, Show Values As for variance analysis, slicers and double-click drill-down

Where PivotTables fit: due diligence, reconciliations, operational data…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.