Tutorial: Using Excel to Prepare Financial Statements

This video walks through the process of leveraging Microsoft Excel to create journal entries, post to the ledger, prepare a trial balance, make adjustments, and prepare an income statement, retained earnings statement, balance sheet, and statement of cash flows from a set of economic transactions.

[SoSopeea]

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.

[johnkodhek]

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 🇰🇪

[emmanouilkalafatis]

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

[AsimKhan-qqbl]

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

[abrahamhaile]

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

[Lbiszz]

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

[amospan]

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

[blesswilliams]

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

[lelavatommyfuifui]

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

[stevedebree]

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

[erinj]

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

[KenMwaura]

Thanks Prof, this lecture was wholesome.

[johnnissimuli]

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.
👍🙏🙏

[franciscopintoleite]

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

[chuksinnocent]

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

[sarwary]

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

[serignebabou]

Wonderful tutorial on both sides (Accounting and Excel)

[malikumar]

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

[adanali]

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

[helo]

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.