Adopting Microsoft Excel for home budgeting - Frugal Village Forums
Frugal Village Forums  
RSS twitter facebook linked in

Home Reviews Help
Go Back   Frugal Village Forums > Home and Family > Household notebooks and home manuals

Household notebooks and home manuals Talk about the various ways you organize your home with manuals, journals, lists, calendars, day planners, binders, index cards and notebooks.

Reply
 
Share LinkBack Thread Tools Display Modes
Old 12-28-2008, 01:24 AM   #1 (permalink)
MomToTwoBoys is happy to be me.
Registered User
Points: 35,291, Level: 45
Points: 35,291, Level: 45 Points: 35,291, Level: 45 Points: 35,291, Level: 45
Level up: 90%, 159 Points needed
Level up: 90% Level up: 90% Level up: 90%
Activity: 30%
Activity: 30% Activity: 30% Activity: 30%
 
MomToTwoBoys's Avatar
 
Join Date: May 2008
Location: Calgary, AB Canada
Age: 32
Posts: 2,715   (View Stats)
JuJu: 102,919
iTrader: (0)
Blog Entries: 23
My Mood:
Thanks: 1,283
Thanked 959 Times in 662 Posts
Recipes: 33
hugs: 157
hugged at 338 Times in 101 Posts
Rep Power: 14
MomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud of
Garden Club: Garden Club - Issue reason:  Cooking: Cooking - Issue reason:  1000 Posts: 1000 Posts - Issue reason:  Participation 1: Participation - Issue reason:  
Total Awards: 4 (more» ...)
Not Ranked  0 score     
Default Adopting Microsoft Excel for home budgeting

DH bought me Microsoft Office and Student 2007 for my budgeting and book writing. I'm stoked!

We installed it today and while I was editing Chapter One, he was playing around with Excel on his PC. Now I've been really resistant to using any computer program for my finances, but this is really neat. They have an actual personal budget template that is modifiable to put in your own income and expense names, etc.

The one thing I was really interested in was the Calendar option. You can use the calendar part for making notes and keeping track of bill due dates and amounts.

Anyone else use Excel that's not totally put off by it?
__________________
Wife to DH since 10/31/2002!
Mom to DS #1 08/13/98 Mom to DS #2 09/11/03

MomToTwoBoys is online now  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookSpurl this Post!Reddit! Wong this Post!
Reply With Quote Share with Facebook
Old 12-28-2008, 02:05 AM   #2 (permalink)
madhen is an irresistable force
Registered User
Points: 109,945, Level: 80
Points: 109,945, Level: 80 Points: 109,945, Level: 80 Points: 109,945, Level: 80
Level up: 74%, 705 Points needed
Level up: 74% Level up: 74% Level up: 74%
Activity: 50%
Activity: 50% Activity: 50% Activity: 50%
 
madhen's Avatar
 
Join Date: Feb 2006
Location: California
Posts: 10,282   (View Stats)
JuJu: 239,193
iTrader: (0)
Blog Entries: 345
My Mood:
Thanks: 3,154
Thanked 3,926 Times in 2,647 Posts
Recipes: 43
hugs: 404
hugged at 1,343 Times in 798 Posts
Rep Power: 55
madhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond repute
Friendship-Kindness: Friendship-Kindness - Issue reason: from NikoSan999 Friendship-Kindness: Friendship-Kindness - Issue reason: from Dean 1000 Posts: 1000 Posts - Issue reason:  FV Blogger: Blogger - Issue reason:  Participation 2: Participation - Issue reason:  Thank You: Appreciation Thank You - Issue reason:  Book Club: Book Club - Issue reason:  Baking Club: Baking Club - Issue reason:  Needlework Club: Needlework Club - Issue reason:  Sewing Club: Sewing Club - Issue reason:  Homesteading: Homesteading Club - Issue reason:  Goalgetters: Goalgetters Club - Issue reason:  
Total Awards: 12 (more» ...)
Not Ranked  0 score     
Default

I love Excel and use it for all sorts of purposes. I even use it when Access would work better, because I like Excel so much more.
__________________
DH aka Mad Hen

EF fund: $0/$2,500.00

March grocery: $0/355 March no-spend: 9/15 2010 Lose-A-Pound-A-Week: 8/12 (146.8 - 138.8)

2010 Reading Challenge: 8/100 2010 Recipe-a-Month: 1/12 2010 Veggie Recipe-a-Month: 2/12
Run/walk challenge: 26/520 miles

2010 Skill-a-Month: 1/12 2010 Project-a-Month: 1/12 Fling 2010 in 2010: 415/2010

Total debt (with mortgage, HELOC, and 2 cc's): Nov 2009: $302886.42
madhen is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookSpurl this Post!Reddit! Wong this Post!
Reply With Quote Share with Facebook
Old 12-28-2008, 09:21 AM   #3 (permalink)
sueh is A mom,taxi driver,nurse,referee,therapist to 2 active kids
Registered User
Points: 3,902, Level: 14
Points: 3,902, Level: 14 Points: 3,902, Level: 14 Points: 3,902, Level: 14
Level up: 71%, 148 Points needed
Level up: 71% Level up: 71% Level up: 71%
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
sueh's Avatar
 
Join Date: Sep 2006
Location: South of the city
Age: 39
Posts: 254   (View Stats)
JuJu: 0
iTrader: (0)
My Mood:
Thanks: 15
Thanked 53 Times in 50 Posts
hugs: 0
hugged at 8 Times in 3 Posts
Rep Power: 4
sueh will become famous soon enough
Not Ranked  0 score     
Default

I use Excel to track my finances.

I have been using it for years. I think it has helped very much because I am a visual person.
__________________
Sue
Single Mom to



CC: $6625/$25,500


"A friend is like a good bra, close to your heart, hard to find and supportive."
sueh is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookSpurl this Post!Reddit! Wong this Post!
Reply With Quote Share with Facebook
Old 12-28-2008, 01:19 PM   #4 (permalink)
MomToTwoBoys is happy to be me.
Registered User
Points: 35,291, Level: 45
Points: 35,291, Level: 45 Points: 35,291, Level: 45 Points: 35,291, Level: 45
Level up: 90%, 159 Points needed
Level up: 90% Level up: 90% Level up: 90%
Activity: 30%
Activity: 30% Activity: 30% Activity: 30%
 
MomToTwoBoys's Avatar
 
Join Date: May 2008
Location: Calgary, AB Canada
Age: 32
Posts: 2,715   (View Stats)
JuJu: 102,919
iTrader: (0)
Blog Entries: 23
My Mood:
Thanks: 1,283
Thanked 959 Times in 662 Posts
Recipes: 33
hugs: 157
hugged at 338 Times in 101 Posts
Rep Power: 14
MomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud of
Garden Club: Garden Club - Issue reason:  Cooking: Cooking - Issue reason:  1000 Posts: 1000 Posts - Issue reason:  Participation 1: Participation - Issue reason:  
Total Awards: 4 (more» ...)
Not Ranked  0 score     
Default

I'm a big notebook type of person, though, which is why Excel sort of feels weird to me. I told DH that what happened if I lost the file and he goes, "Well, what happens when you lose your notebook?" and "How many times have you had a hard drive crash on you?" I sort of saw his point after that since I've lost my notebook a ton and haven't had a hard drive crash on me yet (and I've had two).
__________________
Wife to DH since 10/31/2002!
Mom to DS #1 08/13/98 Mom to DS #2 09/11/03

MomToTwoBoys is online now  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookSpurl this Post!Reddit! Wong this Post!
Reply With Quote Share with Facebook
Old 12-28-2008, 02:09 PM   #5 (permalink)
madhen is an irresistable force
Registered User
Points: 109,945, Level: 80
Points: 109,945, Level: 80 Points: 109,945, Level: 80 Points: 109,945, Level: 80
Level up: 74%, 705 Points needed
Level up: 74% Level up: 74% Level up: 74%
Activity: 50%
Activity: 50% Activity: 50% Activity: 50%
 
madhen's Avatar
 
Join Date: Feb 2006
Location: California
Posts: 10,282   (View Stats)
JuJu: 239,193
iTrader: (0)
Blog Entries: 345
My Mood:
Thanks: 3,154
Thanked 3,926 Times in 2,647 Posts
Recipes: 43
hugs: 404
hugged at 1,343 Times in 798 Posts
Rep Power: 55
madhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond reputemadhen has a reputation beyond repute
Friendship-Kindness: Friendship-Kindness - Issue reason: from NikoSan999 Friendship-Kindness: Friendship-Kindness - Issue reason: from Dean 1000 Posts: 1000 Posts - Issue reason:  FV Blogger: Blogger - Issue reason:  Participation 2: Participation - Issue reason:  Thank You: Appreciation Thank You - Issue reason:  Book Club: Book Club - Issue reason:  Baking Club: Baking Club - Issue reason:  Needlework Club: Needlework Club - Issue reason:  Sewing Club: Sewing Club - Issue reason:  Homesteading: Homesteading Club - Issue reason:  Goalgetters: Goalgetters Club - Issue reason:  
Total Awards: 12 (more» ...)
Not Ranked  0 score     
Default

I have an external hard drive that I back my computer up to about once a week. They aren't very expensive, and they are SO worth the investment. My work computer crashed a few months ago, with no warning, and hardly lost anything, because I had just backed it up about three weeks earlier.

In addition, because I float back and forth between my personal computer and my work computer, I keep some of my files on a thumb drive, so I can check them, regardless of which computer I am at.

And if you need a transitional period, you can always print your Excel spreadsheet out and keep it in a notebook.
__________________
DH aka Mad Hen

EF fund: $0/$2,500.00

March grocery: $0/355 March no-spend: 9/15 2010 Lose-A-Pound-A-Week: 8/12 (146.8 - 138.8)

2010 Reading Challenge: 8/100 2010 Recipe-a-Month: 1/12 2010 Veggie Recipe-a-Month: 2/12
Run/walk challenge: 26/520 miles

2010 Skill-a-Month: 1/12 2010 Project-a-Month: 1/12 Fling 2010 in 2010: 415/2010

Total debt (with mortgage, HELOC, and 2 cc's): Nov 2009: $302886.42
madhen is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookSpurl this Post!Reddit! Wong this Post!
Reply With Quote Share with Facebook
The Following User Says Thank You to madhen For This Useful Post:
fixer (12-28-2008)
Old 12-28-2008, 09:40 PM   #6 (permalink)
MomToTwoBoys is happy to be me.
Registered User
Points: 35,291, Level: 45
Points: 35,291, Level: 45 Points: 35,291, Level: 45 Points: 35,291, Level: 45
Level up: 90%, 159 Points needed
Level up: 90% Level up: 90% Level up: 90%
Activity: 30%
Activity: 30% Activity: 30% Activity: 30%
 
MomToTwoBoys's Avatar
 
Join Date: May 2008
Location: Calgary, AB Canada
Age: 32
Posts: 2,715   (View Stats)
JuJu: 102,919
iTrader: (0)
Blog Entries: 23
My Mood:
Thanks: 1,283
Thanked 959 Times in 662 Posts
Recipes: 33
hugs: 157
hugged at 338 Times in 101 Posts
Rep Power: 14
MomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud of
Garden Club: Garden Club - Issue reason:  Cooking: Cooking - Issue reason:  1000 Posts: 1000 Posts - Issue reason:  Participation 1: Participation - Issue reason:  
Total Awards: 4 (more» ...)
Not Ranked  0 score     
Default

Yep we have an external 80G hard drive that DH swiped and took to work with him. I'm tempted to buy a 1T HD and use that (and it would seriously be six times larger than the one in my computer at the moment). They're about $140 at Best Buy but I also told DH I'd rather have some of those 2G memory sticks to put the budget on.
__________________
Wife to DH since 10/31/2002!
Mom to DS #1 08/13/98 Mom to DS #2 09/11/03

MomToTwoBoys is online now  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookSpurl this Post!Reddit! Wong this Post!
Reply With Quote Share with Facebook
Old 12-29-2008, 12:22 AM   #7 (permalink)
fixer is winterizing
Registered User
Points: 15,135, Level: 29
Points: 15,135, Level: 29 Points: 15,135, Level: 29 Points: 15,135, Level: 29
Level up: 69%, 315 Points needed
Level up: 69% Level up: 69% Level up: 69%
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
fixer's Avatar
 
Join Date: Oct 2008
Location: central Kentucky
Age: 45
Posts: 977   (View Stats)
JuJu: 144,344
iTrader: (0)
Blog Entries: 113
My Mood:
Thanks: 623
Thanked 646 Times in 385 Posts
Recipes: 4
hugs: 31
hugged at 110 Times in 54 Posts
Rep Power: 9
fixer is a splendid one to beholdfixer is a splendid one to beholdfixer is a splendid one to beholdfixer is a splendid one to beholdfixer is a splendid one to beholdfixer is a splendid one to beholdfixer is a splendid one to behold
Supportive: Supportive - Issue reason:  Participation 2: Participation - Issue reason:  Garden Club: Garden Club - Issue reason:  Homesteading: Homesteading Club - Issue reason:  Male: Male - Issue reason:  
Total Awards: 5 (more» ...)
Not Ranked  0 score     
Default

I am going to try Excel for our financial records next year. I have been wanting to do some thing on the computer for a while. We use a notebook but, the data is not used to it's fullest since it is hard to do comparisons. I picked Excel since it was already of our laptop and I have used it in the past.
__________________
Well Done Is Better Than Well Said............ Benjamin Franklin

The highest reward for a person's toil is not what they get for it, but what they become by it.......John Ruskin
fixer is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookSpurl this Post!Reddit! Wong this Post!
Reply With Quote Share with Facebook
Old 12-29-2008, 12:54 AM   #8 (permalink)
MomToTwoBoys is happy to be me.
Registered User
Points: 35,291, Level: 45
Points: 35,291, Level: 45 Points: 35,291, Level: 45 Points: 35,291, Level: 45
Level up: 90%, 159 Points needed
Level up: 90% Level up: 90% Level up: 90%
Activity: 30%
Activity: 30% Activity: 30% Activity: 30%
 
MomToTwoBoys's Avatar
 
Join Date: May 2008
Location: Calgary, AB Canada
Age: 32
Posts: 2,715   (View Stats)
JuJu: 102,919
iTrader: (0)
Blog Entries: 23
My Mood:
Thanks: 1,283
Thanked 959 Times in 662 Posts
Recipes: 33
hugs: 157
hugged at 338 Times in 101 Posts
Rep Power: 14
MomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud of
Garden Club: Garden Club - Issue reason:  Cooking: Cooking - Issue reason:  1000 Posts: 1000 Posts - Issue reason:  Participation 1: Participation - Issue reason:  
Total Awards: 4 (more» ...)
Not Ranked  0 score     
Default

I was just primarily concerned with going from a paper and pen system to Excel because I tend to make little notes each time I do a budget. When DH showed me that I could make notes on the calendar, I was floored! That was the selling point for me. At the moment, I'm using Microsoft Word 2007 for my book editing but I'm sure when I get through the 32 pages of Chapter Two, I'll take a look at Excel.
__________________
Wife to DH since 10/31/2002!
Mom to DS #1 08/13/98 Mom to DS #2 09/11/03

MomToTwoBoys is online now  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookSpurl this Post!Reddit! Wong this Post!
Reply With Quote Share with Facebook
Old 01-21-2009, 09:45 AM   #9 (permalink)
geckoace has no status.
Registered User
Points: 12,410, Level: 26
Points: 12,410, Level: 26 Points: 12,410, Level: 26 Points: 12,410, Level: 26
Level up: 74%, 240 Points needed
Level up: 74% Level up: 74% Level up: 74%
Activity: 8%
Activity: 8% Activity: 8% Activity: 8%
 
geckoace's Avatar
 
Join Date: Dec 2006
Location: Balitmore, MD
Posts: 1,678   (View Stats)
JuJu: 21,814
iTrader: (0)
My Mood:
Thanks: 212
Thanked 350 Times in 282 Posts
hugs: 52
hugged at 113 Times in 82 Posts
Rep Power: 9
geckoace is just really nicegeckoace is just really nicegeckoace is just really nicegeckoace is just really nicegeckoace is just really nice
1000 Posts: 1000 Posts - Issue reason:  Participation 2: Participation - Issue reason:  Goalgetters: Goalgetters Club - Issue reason:  Sewing Club: Sewing Club - Issue reason:  Natural Living: Natural Living Club - Issue reason:  
Total Awards: 5 (more» ...)
Not Ranked  0 score     
Default

i love excel i have our bi-weekly budget in one workbook with a tab for each month, then a year forecasted budget. then i have project budgets and savings projections in workbooks. i keep them all on my flash drive that i store...... in my binder LOL

if you are worried about a crash you can always upload it to google docs periodically
__________________
Reba

When you come to the end of your rope, tie a knot and hang on.
— Franklin D. Roosevelt

STATS

One Project per month challenge
Jan Feb Mar Apr May

Savings Goals
Savings plan for Bink's tuition
Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec

E fund build up
Jan Feb Mar Apr May Jun Jul Aug Sept Oct

2010 Goals
House electric updated
Pay off half of BofA card
Get compost bin
Put up Fence
Paint DR
geckoace is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookSpurl this Post!Reddit! Wong this Post!
Reply With Quote Share with Facebook
Old 01-21-2009, 10:14 AM   #10 (permalink)
MomToTwoBoys is happy to be me.
Registered User
Points: 35,291, Level: 45
Points: 35,291, Level: 45 Points: 35,291, Level: 45 Points: 35,291, Level: 45
Level up: 90%, 159 Points needed
Level up: 90% Level up: 90% Level up: 90%
Activity: 30%
Activity: 30% Activity: 30% Activity: 30%
 
MomToTwoBoys's Avatar
 
Join Date: May 2008
Location: Calgary, AB Canada
Age: 32
Posts: 2,715   (View Stats)
JuJu: 102,919
iTrader: (0)
Blog Entries: 23
My Mood:
Thanks: 1,283
Thanked 959 Times in 662 Posts
Recipes: 33
hugs: 157
hugged at 338 Times in 101 Posts
Rep Power: 14
MomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud ofMomToTwoBoys has much to be proud of
Garden Club: Garden Club - Issue reason:  Cooking: Cooking - Issue reason:  1000 Posts: 1000 Posts - Issue reason:  Participation 1: Participation - Issue reason:  
Total Awards: 4 (more» ...)
Not Ranked  0 score     
Default

I told DH that he had to sit down with me one of these weekends and actually show me how to do more with it than just entering data. I have no idea what half of the commands do!

I got all irritated yesterday because out of my own newness to Excel, I didn't know how to put lines in order and how to figure out why I was $0.47 off budget. I don't know which was more sad...

but DH did tell me he might have an Excel textbook downstairs from when he was going through school.
__________________
Wife to DH since 10/31/2002!
Mom to DS #1 08/13/98 Mom to DS #2 09/11/03

MomToTwoBoys is online now  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookSpurl this Post!Reddit! Wong this Post!
Reply With Quote Share with Facebook
Reply

Bookmarks

Tags
adopting, budgeting, excel, home, microsoft

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A Lesson Learned (Re: Excel budgeting) MomToTwoBoys Debt Reduction & Money Management 7 09-15-2009 01:58 PM
I'm looking for an excel template champagnium Frugal Living 2 05-29-2008 02:22 PM
Excel anyone?? rachelMcK Debt Reduction & Money Management 6 02-19-2008 01:34 PM
Want to learn how to use Excel? Darlene Computers 4 08-15-2006 08:55 AM
For those adopting, you can... homesteadmamma Adoption 3 01-20-2006 12:39 AM


All times are GMT -4. The time now is 01:44 PM.







Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
Copyright ©2001 - 2010, Frugal Village, LLC