|Excel extras: PowerPivot finance reports for P&L|
|Written by David Churchward|
|Thursday, 08 March 2012 21:28|
It's not unusual to see 'manual' versions of P&L reports, so I've been on a constant lookout for a reporting mechanism that can manage the complexity of the P&L report while maintaining the flexibility to adapt to required changes in the business.
My quest reached a successful conclusion when I encountered PowerPivot. This month's article is dedicated to showing the program's capability to produce a P&L report, and some tips of how to get started.
- Excel extras - PowerPivot: comparison against average
- Excel extras - PowerPivot CALCULATE() with disconnected slicers
- Gantt Reworked with ADDCOLUMNS, FILTER, GENERATE and SUMMARIZE
- CRM Pipeline Funnel Chart (and something on Themes)
- Gantt Chart with Resource Loading
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?