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.
THEY WORK!!!
Thank you so much - you're students are very lucky to have such a good teacher.
99wLola 6 days ago
@99wLola
IS = 3b5b3b7b1b7b3
EARNINGS = 3b5b3b7b1b7b3
BS = 3b5b3b7b1b7b3
LET ME KNOW IF THEY WORK ;)
Mr20uploader10 1 week ago
...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!!!!!!!!!!
99wLola 1 week ago
PASSWORD : 3b5b3b1b7b5b3
THANKS KEVIN ;)
Mr20uploader10 4 weeks ago
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
BlopartDallas 1 month ago
..can i have the password for me to be able to see the formula in the cell?..please, i badly need it..;p
1592jessamae 1 month ago