Excel Balance Sheet from Trial Balance with Power Query and Power Pivot

Поделиться
HTML-код
  • Опубликовано: 4 окт 2024

Комментарии • 18

  • @CharlieEllsworth-y4n
    @CharlieEllsworth-y4n 6 месяцев назад

    I'm a little late to the party, but your video and concepts are incredibly helpful! Thank you.

  • @v2pumo817
    @v2pumo817 7 месяцев назад

    Very clear introduction to cube function .

  • @alexrosen8762
    @alexrosen8762 Год назад +2

    Excellent tutorial. Very useful 🙏

  • @GestordeTrafego-zl9qs
    @GestordeTrafego-zl9qs Год назад +1

    This video helped me. Thank you for sharing your knowledge.

    • @ExcelU
      @ExcelU  Год назад

      Thank you ... I'm glad it helped :)

  • @JuanLopez-nh5gf
    @JuanLopez-nh5gf 4 месяца назад

    Nice Sr!

  • @Bhavik_Khatri
    @Bhavik_Khatri Год назад

    Very nicely done. Could you please share excel files too?

  • @jamilhfl
    @jamilhfl 8 месяцев назад

    supper excellent

    • @ExcelU
      @ExcelU  8 месяцев назад

      Thank you very much

  • @rebesteves
    @rebesteves 4 месяца назад

    This is really cool but the example is too simple to use Power query or power Pivot. Do you have more complex example - multiple entities and reporting periods? My power pivot has a entity ID listed horizontally, plus a reporting period as the pivot drop-down.

  • @josealvesferreira1683
    @josealvesferreira1683 Год назад

    congratulations

  • @alexisbermisa9708
    @alexisbermisa9708 Год назад

    Can you do balance sheet and income statement from cash beginning trial balance, disbursement and sales book?

  • @MarioArevilca
    @MarioArevilca 6 месяцев назад

    Hi, could this work with governmental financial statements that have have different gov't funds?

  • @JayByrne-wh3lf
    @JayByrne-wh3lf Год назад

    What is the formula for restating a date in a separate cell from mm/dd/yyyy to yyyy-mm?

    • @mardyzhou1831
      @mardyzhou1831 Год назад

      Hi Jay, For me, I usually use Text.Middle(Text.From(datedata),6,4)&"-"& Text.Middle(Text.From(datedata),3,2). Hop this will help

  • @dougmphilly
    @dougmphilly Год назад

    i still prefer using calculated items

  • @jerrydellasala7643
    @jerrydellasala7643 Год назад

    Too bad the download has nothing to do with the Video....

    • @harumih.3727
      @harumih.3727 7 месяцев назад +1

      You must have downloaded the wrong file.