Step 1:
Bill Management
Use SmartArt to fill it with colour and designs and it'll be nice to look at, as well as mathematically correct.
Set up rules so that if your outgoings are greater than your incomings your total box goes red, so you can see there's a problem. You can also set up rules so that if your telephone bill, for example, goes over a certain pre-defined limit, it'll get flagged and you know where to cut back for next month.
Formulas are easy to implement these days – just go to the formulas bit on the menu bar, and everything's practically done for you already. Select what you need and just fill it in.
Step 2:
Event Management
If you've got a big event to plan, like a wedding, Excel can make the whole thing much easier. Keep it to one document, but use different sheets for different bills. One for reception, one for the outfits, one for the ceremony and one for the honeymoon.
|