All articles in 'Pivot Tables & Charts' Category
Adding Calculated Fields to Pivot Table P&L [part 3 of 6]
![Adding Calculated Fields to Pivot Table P&L [part 3 of 6]](https://chandoo.org/img/ea/profit-loss-report-with-calculated-fields.png)
This is part 3 of 6 on Profit & Loss Reporting using Excel series, written by Yogesh Data sheet structure for Preparing P&L using Pivot Tables Preparing Pivot Table P&L using Data sheet Adding Calculated Fields to Pivot Table P&L Exploring Pivot Table P&L Reports Quarterly and Half yearly Profit Loss Reports in Excel Budget […]
Continue »Preparing Profit / Loss Pivot Reports [Part 2 of 6]
![Preparing Profit / Loss Pivot Reports [Part 2 of 6]](https://chandoo.org/img/ea/profit-loss-reports-2.png)
This is part 2 of 6 on Profit & Loss Reporting using Excel, written by Yogesh Data sheet structure for Preparing P&L using Pivot Tables Preparing Pivot Table P&L using Data sheet Adding Calculated Fields to Pivot Table P&L Exploring Pivot Table P&L Reports Quarterly and Half yearly Profit Loss Reports in Excel Budget V/s […]
Continue »P&L Reporting using Excel [Part 1 of 6 on Excel & Accounting]
![P&L Reporting using Excel [Part 1 of 6 on Excel & Accounting]](https://chandoo.org/img/ea/excel-accounting-pl-reports-1.png)
With this post we are starting a new series on how to do basic accounting in Microsoft Excel. In this and next 5 posts, we will aim to setup Profit & Loss account reporting for multi-location retail company.
During this series we will learn how to make P&L reports on various criteria with just few clicks.
Many users find it difficult to manage their P&L reporting for Multi Location organization.
We will be using Pivot Tables for our reporting purpose and will take example of a Retails chain with multiple locations divided into various regions.
Continue »Grouping Dates in Pivot Tables
![Grouping Dates in Pivot Tables](https://chandoo.org/img/p/group-dates-in-pivot-tables.png)
Do you know you can group dates in pivot tables to show the report by week, month or quarter? I have learned this trick while doing analysis on a pivot table today. In this online lesson on pivot tables, I will teach you how to group dates in pivot tables to analyze the data by month, week, quarter or hour of day.
Continue »