Sunday, March 7, 2010

Pivot Tables : P&L reporting for Multi Location Organisation

I have recently started a series via guest posts on pointy haired dilbert famous excel blog also known as PHD or Chandoo.org. This blog is run by Chandoo a excel blogger and Microsoft excel MVP. Most of you must be knowing chandoo, those who do not know about him can know more about chandoo.

In this series we are covering on how to manage Profit and Loss (P&L) account reporting for Multi Location organization.
P&L Report using Pivot Table

During this series our aim is to learn how we can do our P&L reporting on various dimensions with few clicks.

We are using Pivot Tables for our reporting purpose and will setup P&L report of a Retails chain with multiple locations divided into various regions.

Topics coverted in this series are :

1. Data sheet structure for Preparing P&L using Pivot Tables
2. Preparing P&L Pivot Table using Data sheet
3. Adding Calculated Fields to Pivot Table P&L
4. Exploring Pivot Table P&L Reports
5. Preparing Quarterly and Half yearly P&L using grouping option
6. Budget V/s Actual report using Pivot

Do not think that series is only about the Profit and Loss Account. This series is also about PivotTables. We will cover many of PivotTable tricks during our series. I hope you will be able to use those tricks elsewhere also.

Follow this series on PHD, I am sure that at the end of this series you will be able to do your P&L reporting on various dimentions with just few clicks.

14 comments:

  1. Excel offers some incredible capabilities that make data administration and analysis a breeze. My present job requires a professional level of Excel and other writing tools because I am an academic writer and usually offers dissertation proposal help UK, & I have to do research, calculations and so on. So that I can devote my leisure time to learning Excel.

    ReplyDelete
  2. I will surely check your accounting blog because I am doing Master's in accounting and finance so it might be possible that I can find stuff for my assignments and quiz. I was assigned with profit and loss accounting report, I think now can I complete it without the assistance of accounting dissertation writers.
    Accounting Dissertation Writing Services

    ReplyDelete
  3. Fantastic service by Michael! You can't beat actually speaking to someone and getting them to work it all out for you, myprotein discount code Will be recommending your services thankyou.

    ReplyDelete
  4. Is there any formula on excel that act as a GPA Calculator because I am not able calculate it on my own. Kindly refer me something so that I can know my GPA and could be able to add to my resume. No one is even accepting my resume without having a GPA into it.

    ReplyDelete
  5. Very fascinating story, it is difficult to find interesting and relevant content among blogs now. That is why I will definitely share your blog with my friends. I wish you success!
    Site: Marlboro jacket

    ReplyDelete
  6. This is the first time that I visit here. I found so many exciting matters in this particular blog,
    Site : Yellowstone John Dutton Black Vest

    ReplyDelete
  7. Because I am an essay writer who normally provides cheap Finance essay help UK, and I have to do research, calculations, and so on, my current job needs a professional level of Excel and other writing tools. So that I can spend my free time learning Excel.

    ReplyDelete
  8. I really liked the content delivery style of this article. All appreciations for the writers. The professional assignment writers uk also are experts and specialists in producing the unique and competitive content for the assignments and other academic documents.

    ReplyDelete

  9. Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog
    weight loss with extra informatiy helpful for me.

    ReplyDelete
  10. Well, I was looking for an online class taking service whom I can Pay To Take My Online Class, and I do not know why I have landed on your site because here I am not able to find anything regarding online class taking service. So, will you please confirm it? I need it on an urgent basis.

    ReplyDelete
  11. This Inventory Tracking System was purchased, and I must say, it is fantastic! It's simple to use and understand, so everyone on our team can utilize it. It also maintains track of everything that comes in and out of our two warehouses, as well as our Goods Inwards and Sales mobile app development services . Thank you very much, Jason. My life has become a lot simpler.

    ReplyDelete
  12. It was a piece befuddling at first in view of a terrible login however vat calculator. I reached out to them and they were exceptionally useful.

    ReplyDelete
  13. The table reporting of do my essay for me in UK is playing amazing multiproposal manner

    ReplyDelete
  14. The do my essay service is very well established to retain the multiple reporting in a single manner

    ReplyDelete

Learn how to create Excel dashboards.
Yogesh Gupta's Excel Tips