Making Profit & Loss Statements in Excel using Pivot tables

Поділитися
Вставка
  • Опубліковано 19 жов 2024

КОМЕНТАРІ • 33

  • @MuhammadShoaib-eq6wd
    @MuhammadShoaib-eq6wd 5 років тому +2

    nice .... i learned a lot of things....it was very helpful to me

    • @rayjonas9355
      @rayjonas9355 3 роки тому

      you prolly dont care at all but does anybody know a trick to get back into an instagram account?
      I was dumb forgot my account password. I would appreciate any assistance you can offer me.

  • @daniyalmehmood1672
    @daniyalmehmood1672 2 роки тому +1

    Jazakallah i learned a lot of things....it was very helpful to me

  • @rayasvoicepudding2257
    @rayasvoicepudding2257 4 роки тому +1

    This was surprisingly easy to follow and understand! It was very straightforward and concise.

  • @shefeekbasheer7514
    @shefeekbasheer7514 3 роки тому +1

    Clear explanation✌️

  • @kidsplayingkitchen9961
    @kidsplayingkitchen9961 5 років тому +1

    I saw many videos on pivot table but you are No 1.
    I never saw they how easy explained

  • @samakikubwa7842
    @samakikubwa7842 2 роки тому +1

    Good stuff

  • @arturschutte7956
    @arturschutte7956 3 роки тому +1

    Thank you very much. Is there a way to calculate the profit margin (% of profit/sales) within the pivot table?

  • @pthdxe
    @pthdxe 3 роки тому

    Your video is great but why I cannot download the exercise workbook through your link provided? Can you share out for practice?

  • @kidsplayingkitchen9961
    @kidsplayingkitchen9961 5 років тому +1

    Wonderful good work
    How easy and completely explained in very easy way
    Thanks

  • @ziaman422
    @ziaman422 6 років тому +1

    TOP WORK. EXERCISE WORKBOOK PAGE IS NOT OPENING KINDLY TELL OTHER WAY TO DOWNLOAD

  • @alexandrkravchuk3902
    @alexandrkravchuk3902 6 років тому +1

    Thank you! You helped me a lot

  • @ricardomantovaniassis
    @ricardomantovaniassis Рік тому

    Thank you so much. But the download link is not working.

  • @qasimjan5258
    @qasimjan5258 6 років тому +1

    I always wonder if there is any use of pivot table for accountant or not and you turn it into yes. Thank you so much and please keep it up Sir.

  • @yaghoubnasirzadeh2651
    @yaghoubnasirzadeh2651 4 роки тому

    It is awesome!
    Thank you so much

  • @salmanabdulwahid1409
    @salmanabdulwahid1409 3 роки тому

    In other words, starting from General Entery to Trial Balance to Complete FS, how to make it possible through pivot tables??

  • @grendbelema
    @grendbelema 4 роки тому

    nice

  • @anissadebeche6522
    @anissadebeche6522 3 роки тому

    Hello, how could I add a column on the right with percent or relative values ?

    • @HasaanFazal
      @HasaanFazal  3 роки тому

      Percentage of what amount do you wish to calculate? Adding a column is not difficult. Simply put a heading to the right most available column and paste the formula.
      If you need help regarding formula, then let me know for which amount you wish to find the percentage

  • @kidsplayingkitchen9961
    @kidsplayingkitchen9961 5 років тому +2

    Make a video on general ledgers and trail balance how we can make very easy and quickly in pivot
    Thanks

  • @lloydamos6895
    @lloydamos6895 4 роки тому

    Im a small business and am.wanting to produce a profit and loss statement from Jan to March 2020,,,is that possible,,,,

    • @HasaanFazal
      @HasaanFazal  4 роки тому

      İn this video we learn one of the several ways to make profit and loss. You can make reports of a quarter as well using this method. So yes it's possible.

  • @sachinkishore4115
    @sachinkishore4115 5 років тому

    thank you bro

  • @salmanabdulwahid1409
    @salmanabdulwahid1409 3 роки тому

    I want to start a business with 100000, how to make CF, Pnl and BS with just one Detailed Table of Working???

  • @xeeclassic
    @xeeclassic 6 років тому

    no analyze option in my EXCEL..WHAT SHOULD I DO???

    • @mazamk
      @mazamk 6 років тому

      in the ribbon, click on options under pivot table tools, then click on fields, items and sets button. you'll find calculated field there.

  • @xeeclassic
    @xeeclassic 6 років тому

    HOW CAN I ADD ''GROSS PROFIT' FEILD WITHOUT ANALYZE OPTION???

    • @HasaanFazal
      @HasaanFazal  6 років тому

      amina akram what version of Excel are you using? I believe naming of trans is same in versions prior to 2016 as well.
      Try to find calculated fields option in menu or ribbon we are basically after that to insert custom calculated fields

    • @Softwaretrain
      @Softwaretrain 4 роки тому

      Thanks, but link of download file doesn't work.

  • @tamendreemunsamy9736
    @tamendreemunsamy9736 4 роки тому

    *,***_);(*,***)
    Does not give me the required result. My result is (
    ))))))) for a negative field. Please assist.

    • @HasaanFazal
      @HasaanFazal  4 роки тому

      What is the requirement? The asterisk will repeat the character that follows it to fill the column width.