How To Use a Simple Excel Bookkeeping Workbook

This short video shows how to use an Excel bookkeeping workbook that I created for my introductory financial accounting course to teach my students the impact on balance sheet equation caused by debits and credits. I used some Excel macros, vlookup and data validation drop down lists to create this workbook. Just copy and paste the following link into your browser to find the Excel workbook described in this video. https://docs.google.com/leaf?id=0B021wp9h1I7GZDY2ZjhlNWYtMmZkYi00NTk1LTllODMt...

I have my advanced accounting students create a similar file to help them learn Excel a little better.

Category:

Education

Tags:

• How
• To
• Use
• simple
• Bookkeeping
• Workbook

[99wLola]

THEY WORK!!!

Thank you so much - you're students are very lucky to have such a good teacher.

[Mr20uploader10]

@99wLola

IS = 3b5b3b7b1b7b3

EARNINGS = 3b5b3b7b1b7b3

BS = 3b5b3b7b1b7b3

LET ME KNOW IF THEY WORK ;)

[99wLola]

...thanks for the workbook - it's really great! The password worked for the TB worksheet but not for the others :( Can I have the password(s) for the IS, BS and Earnings please?.... or am I doing something wrong? THANKS!!!!!!!!!!

[Mr20uploader10]

PASSWORD : 3b5b3b1b7b5b3

THANKS KEVIN ;)

[BlopartDallas]

Hello Kevin! Would be possible to have the password for the same objective expressed below, to see the formulas in the cells? Many thanks in advance and also for sharing the video. Regards from the Caribbean.....Pablo

[1592jessamae]

..can i have the password for me to be able to see the formula in the cell?..please, i badly need it..;p