Tutorial: Using Excel to Prepare Financial Statements

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 ม.ค. 2025

ความคิดเห็น • 61

  • @oladean6375
    @oladean6375 3 หลายเดือนก่อน +1

    Prof. I like your style of teaching, since I`m from the old school, I followed your style and now able upgrade my accounting skills.

  • @SoSopeea
    @SoSopeea ปีที่แล้ว +3

    Thank you for this excellent video. I was able to keep up with you and comprehend what you were teaching- Which is a great compliment. Also, I absolutely loved the soft low music in the background! It wasn't over powering or distracting, it was just right.
    Thank you so much.

  • @amospan14
    @amospan14 ปีที่แล้ว +2

    Excellent tutorial teaching us how to use Excel for preparing financial statements and accounting. Thank you very much! =)

  • @johnkodhek
    @johnkodhek 3 ปีที่แล้ว +6

    The importance of referencing was just driven through superbly with the last adjustment made in the problem file! It was like watching magic right before my eyes! Thankyou sir from 🇰🇪

  • @emmanouilkalafatis7255
    @emmanouilkalafatis7255 ปีที่แล้ว

    This is a great tutorial. I have an Associates Degree in Business Administration and am enrolled, but not taking classes at MDC for a BS in supervision and management with an accounting concentration. I love watching these things and especially love it when someone puts up useful material. Even with my own contracting business it helps me manage my money but keeps everything I learned fresh in my mind. Thanks for taking the time to put stuff like this up

  • @L5biszz
    @L5biszz 2 ปีที่แล้ว

    So boring yet so useful. The delivery was great. The topic is obviously not space science. Thank you.

  • @abrahamhaile4969
    @abrahamhaile4969 ปีที่แล้ว

    Thank you very much. I completed my Business Plan thanx to your tutorial.

  • @AsimKhan-qq3bl
    @AsimKhan-qq3bl 4 ปีที่แล้ว +7

    very comprehensive 'start to finish' example , hopefully more videos on similar topics will keep coming , Thanks.

  • @blesswilliams64
    @blesswilliams64 ปีที่แล้ว

    I find this tutorial extremely useful and it has really helped me... Key thing when using MS Excel is to do the referencing.,, otherwise it's gonna be a very big hustle to start over again if you screw up

  • @erinj2484
    @erinj2484 3 ปีที่แล้ว +3

    Thanks Prof. That was worth every minute. I have been struggling with this recently. So glad I found you.

  • @stevedebree
    @stevedebree 2 ปีที่แล้ว

    What an excellent video.....learned so many tips for a newer excel user....I can't estimate how many hours you've saved me....thanks.

  • @lelavatommyfuifui1330
    @lelavatommyfuifui1330 ปีที่แล้ว

    Absolutely perfect way of learning and utilize all the functions of Excell..

  • @franciscopintoleite3582
    @franciscopintoleite3582 4 ปีที่แล้ว +1

    EXCELLENT. I downloaded the file and went through it all... Simply amazing work, thank you so much

  • @chuksinnocent2150
    @chuksinnocent2150 2 ปีที่แล้ว

    Thanks a lot Dr. Chris. You did justice to the lecture.

  • @malikumar2204
    @malikumar2204 2 ปีที่แล้ว

    Its a lot for me seriously. And I subscribed your channel just for your way to teach and explain the things.💝

  • @sarwary246
    @sarwary246 2 ปีที่แล้ว

    thank you very much for such wonderful presentation, it really help everyone to review and learn the financial reporting system.

  • @johnnissimuli788
    @johnnissimuli788 3 ปีที่แล้ว +4

    Prof superb stuff and well articulated step my step process. Found it really helpful.
    Hope you post more videos particularly capturing ,Tax or VAT treatmment plus inventory/supplies accounting using FIFO method and countra accounts.
    👍🙏🙏

  • @KainRedan-p7c
    @KainRedan-p7c 4 หลายเดือนก่อน +1

    Thanks it's awesome at least now I can do an income statement on excel.

  • @adanali4331
    @adanali4331 2 ปีที่แล้ว

    Thank you prof.This video of yours has really helped me.

  • @shezramohammed3606
    @shezramohammed3606 2 ปีที่แล้ว

    This was so helpful sir, thank you for this and making it easy

  • @lisathokozani
    @lisathokozani 2 ปีที่แล้ว

    Wow this made things so much easier. Thank you 🙏🏽

  • @serignebabou4306
    @serignebabou4306 2 ปีที่แล้ว

    Wonderful tutorial on both sides (Accounting and Excel)

  • @AhmedHassan-xp1bc
    @AhmedHassan-xp1bc 2 ปีที่แล้ว

    The best at all♥️♥️🌹

  • @avigdoratlas
    @avigdoratlas ปีที่แล้ว

    Excellent tutorial. Thank you!

  • @Mad1080
    @Mad1080 11 หลายเดือนก่อน

    Thanks for the wonderful video... means a lot!!
    Kindly request you provide files, prepare three financial statements, and create a dashboard... in a continuing process... preparation of statements, creating and presenting in dashboard

  • @edwinomondi2039
    @edwinomondi2039 2 ปีที่แล้ว

    Excellently explained. Thank you

  • @otienolennox1507
    @otienolennox1507 ปีที่แล้ว

    so informative. it indeed made my day...

  • @yaileensuarez8907
    @yaileensuarez8907 2 ปีที่แล้ว

    Thanks so much for saving my life.

  • @prudencekaruma
    @prudencekaruma ปีที่แล้ว

    Thumbs up.That video is very informative and helpful

  • @hannaokopna344
    @hannaokopna344 7 หลายเดือนก่อน +1

    wow so easy and useful, thank you.

  • @Brownsugar5329
    @Brownsugar5329 4 ปีที่แล้ว +1

    Thank you so very much! You just saved me! This was so awesome!

  • @helo11228
    @helo11228 4 ปีที่แล้ว

    Sir i am from Pakistan and i have watch this video first time and understood each and every thing Thanks but one thing i have to learn all excel formulas.

  • @George-cc8ws
    @George-cc8ws 2 ปีที่แล้ว

    Thank you professor very helpful...

  • @AC-op4ut
    @AC-op4ut 3 ปีที่แล้ว

    Perfect explanations. Thank you

  • @solomonmepukori6569
    @solomonmepukori6569 2 ปีที่แล้ว

    very good and educative , thank you

  • @Gambit889
    @Gambit889 4 ปีที่แล้ว

    Say for your expenses in IS, I want to make an hide/unhide option for the sub expenses. How to do that?

  • @Wavyprodigy
    @Wavyprodigy 2 ปีที่แล้ว

    Great video, very helpful.

  • @Samtravelandtourmaldives
    @Samtravelandtourmaldives 2 ปีที่แล้ว

    How can I find this file?

  • @JasonD201
    @JasonD201 3 ปีที่แล้ว

    When I download the file it is only reflecting the first page, not the full document.

    • @snails6997
      @snails6997 2 ปีที่แล้ว

      Yeah, so you could try them yourself.
      Because it will be different with other case you currently have.

  • @kwentoleric
    @kwentoleric 3 ปีที่แล้ว

    Thank you for this tutorial.

  • @ikechichikaprecious6650
    @ikechichikaprecious6650 3 ปีที่แล้ว

    Wow awesome thanks prof.

  • @monirajv
    @monirajv 2 ปีที่แล้ว

    Very Good Tutorial

  • @franciskoroma8486
    @franciskoroma8486 ปีที่แล้ว

    I like the information

  • @genxiao8737
    @genxiao8737 3 ปีที่แล้ว

    Omg! Thank you Prof!!!

  • @Ayuk1
    @Ayuk1 3 ปีที่แล้ว

    Great video. Thanks

  • @shamimfarooq6870
    @shamimfarooq6870 ปีที่แล้ว

    Thank you Sir...

  • @ashairzeeshan9721
    @ashairzeeshan9721 4 ปีที่แล้ว

    Dear sir would you please share the excel sheat as well.

  • @ATInstitute
    @ATInstitute 3 ปีที่แล้ว

    this was superb

  • @tatendaishenyamutumbu2666
    @tatendaishenyamutumbu2666 3 ปีที่แล้ว +1

    Thank you so much

  • @issahadil8006
    @issahadil8006 4 ปีที่แล้ว +1

    The video is great

  • @rey250887
    @rey250887 3 ปีที่แล้ว

    Thankyou Sir 🙏

  • @andrewstran
    @andrewstran 3 ปีที่แล้ว

    I would help if your mouse was visible, good video

  • @Sumbula89
    @Sumbula89 3 ปีที่แล้ว

    Good work Prof, really learnt heaps today, just a bit confused with the entry supplies purchased on account, won't you credit Accounts Payable instead of cash?

    • @TheAccountingProf
      @TheAccountingProf  3 ปีที่แล้ว +1

      Yes, thanks for asking. I made a mistake when first entering this journal entry, which I then catch and fix later in the video. But you are correct, it should be a credit to A/P!

  • @hadekhae.f.5847
    @hadekhae.f.5847 4 ปีที่แล้ว

    Thanks prof

  • @techcorner2025
    @techcorner2025 4 ปีที่แล้ว

    Finally found this

  • @tewodrosteklewold7804
    @tewodrosteklewold7804 2 ปีที่แล้ว

    Thanyou so much

  • @farooqtahir538
    @farooqtahir538 ปีที่แล้ว

    Useless!!That how you made financial statements practically?like transferring each entry manually to the ledger?

    • @TheAccountingProf
      @TheAccountingProf  ปีที่แล้ว

      No, not practically. This is a learning tool for introductory accounting students and those trying to understand the basics behind financial statement preparation. In practice, most businesses will use accounting software to automate much of this procedure.

  • @garybrown504
    @garybrown504 10 หลายเดือนก่อน

    this might be a decent tutorial on how to keep some books but its basically copying what was done on paper in 1970. Its certainly using excel properly or efficiently so i wouldn't recommend following this at all. bizarre.