How to create an excel checkbook register

Ryan Hafey at CheapChucky.com.
Email: Ryan.Hafey@cheapchucky.com

This video will show you how to put together an electronic checkbook register using Microsoft Excel. The instructions in this video will also apply to OpenOffice.org Spreadsheet users.

You can download the template for this spreadsheet at the following web address:

http://www.cheapchucky.com/2010/05/31/organize-your-finances/

If you have any questions or to learn about other money-saving tips, head on over to CheapChucky.com.

Category:

People & Blogs

Tags:

• How
• to
• create
• an
• excel
• register
• educational
• cheapchucky.com
• ryan
• hafey
• money
• save
• finance
• openoffice
• spreadsheet

[ryanatcheapchucky]

I wasn't aware until recently that OpenOffice formulas use semi-colons where Excel uses commas (or such was the case in this formula). In other words, if you're using OpenOffice, replace the commas with semi-colons and it should work just fine.

[joe42968]

Do you still plan on putting the formula in the description?

[ryanatcheapchucky]

@joe42968 I apologize for the delayed response. Apparently, YouTube does not let you use ">" in the video description so I added the formula into the video as a speech bubble. You can find that at 3:30.

[SPoil3dMilk]

Thank you so much!! This video is perfect, I'm all set up and this has really made my life easier. I really appreciate this tutorial!

[stasisnu18]

Thanks so much!!! VERY good video!!! Though i thought you had a formula in your description , but then i downloaded your template and just use that, thank you very much

[AndreaMaranoMakeup]

IT ALL WORKS EXCEPT IT WON'T SUBTRACT. i CHECKED THE FORMULA FOR OPEN OFFICE FIVE TIMES :(

[epiclovemuscle]

if your using excel 2010 use =IF(D3>0.01,F2-D3+E3,IF(E3>0.0­1,F2-D3+E3,))

[likinghills]

this works like a charm! Thank you so much!



[rcfreak363]

thank you very much, i just got a job, and this is a great way to start!

[claresa14]

Thanks so much for this video!