If you do anything in Excel, you'll have to "write" it yourself. There's nothing in Excel that is set up for managing finances. If you don't know what I'm talking about (or are unfamiliar with Excel) then this is probably a bad idea. If you are familiar with excel and can setup some pretty functional spreadsheets, then I'd try it first and if it isn't working for you then I'd go to Quicken.
OK, so your main goal is to track your personal finances and monitor how you're spending your money. Well, this is exactly what quicken is for, but there are some benefits and drawbacks.
Pros:
The main part of the quicken interface that you'd use is just like a checkbook register. You can fairly simply enter in an expense and assign an expense category, memo etc...
These categories are tracked and you can look at all sorts of charts on how you're spending your money.
Quicken has budget tools built in so it'll help you look at your current spending and create a budget and track your spending against it.
It also allows you to download transactions from most banks and credit card companies, so that eases data entry.
Cons (I'll just list one, Im getting tired):
Do you use cash?? When I withdraw $200 for spending money, in quicken I enter that as an ATM withdrawl and the category is "cash". I might spend $50 on entertainment, $20 on lunches, $35 on groceries, $12 on a bottle of wine, $5 on girl scout cookies, $15 on new bike tubes... I don't have the patience to individually track all these purchases in quicken. Plus there's no place to download cash transactions from. In order to truly know how this money is spent or to take advantage of the budget tracking feature, entering this expense under "cash" is useless. I must go in and track my spending to the gnat's ass within the tool. That's just not going to happen with me.
I am much better served to sit down, create a spending plan for a typical week. Basically I decide to pay cash for everything then determine how much cash I'll need per week. So I estimate lunches, groceries, entertainment, gas... Then I give myself that amount of cash per week and that's all I get. Some of my estimates will be high, some low, but my weekly spending amount covers it. Then I track all other expenses. But again, I'm not monitoring all of those little things that I spend money on each week.
Quicken is a good tool, but to get real benefits out of it, you really need to be extremely detailed. Personally I do better when I operate at a slightly higher level. And I can create all the tools I need and track the historical things I care about like net worth, assets, debt, liquidity in Excel. I don't need a pie chart that tells me I spend x.xx% of my monthly income on groceries.