Posts Tagged ‘Excel’
Present and gift logging spreadsheet
Sometime it can be hard to think of what presents to give for birthday, Christmas, Valentines or anniversaries. Having a record of what presents you have given before can help to provide inspiration, and can help you avoid giving the same present twice. I’ve made a simple spreadsheet for logging gifts and presents. I’ve put some example [...]
Managing holiday money with an Excel burn down chart
If you go on a short holiday then it should be pretty easy to manage your holiday money. It isn’t too hard to track how quickly your foreign currency is running out when you are only abroad for a week or two. If you are going on holiday for a number of months then it becomes a bit harder. When I recently went on holiday for three months I [...]
2011 One Page Excel Calendar
2010 is still over a month away and yet I've already had several requests for a 2011 one page excel calendar. The format of my 2010 excel calendar seems to be a good one so I'm repeating it for the 2011 version. As in previous years I've made a blank calendar with just the days / months marked out, and a calendar with the 2011 UK bank [...]
2010 One Page Excel Calendar
We're well into 2009 so to follow on from my 2009 Excel one page calendar it seems time to put up the yearly calendar for 2010. As before I've done a blank calendar with just the days / months marked out, and a calendar with the 2010 UK bank holidays highlighted. 2010 Excel calendar - blank (7kb) 2010 Excel calendar - with UK Bank [...]
2009 One Page Excel Calendar
Following on from my 2008 Excel one page calendar I've produced a new yearly calendar for 2009. This time I've done a blank one with just the days / months marked out, and one with the UK bank holidays highlighted. 2009 Excel calendar - blank (7kb) 2009 Excel calendar - with UK Bank Holidays highlighted (7kb) Like before you should [...]
Graphing the AXA Sun Life 50 Plus Protector
Following on from my post where I graphed the AXA Sun Life Guaranteed Over 50 plan I thought I'd look at a more complex product to see what kind of graphs I could get out of it. Unlike the Over 50 plan, the AXA Sun Life 50 Plus Protector features a lump sum and premium that increases over time. There is also a maximum number of years that the [...]
Graphing the AXA Sun Life Guaranteed Over 50 Plan
On TV recently I've been bombarded by adverts about the AXA Sun Life Guaranteed Over 50 Plan. The current version of the advert is presented by Michael Parkinson. Previous versions have been presented by June Whitfield. I am no way near the age of 50 and these plans have no relevance to me. I should also point out that I am not a financial [...]
Weekly planner in Excel
If you find that you never manage to get everything done, or if your life is a bit disorganised you may find it helpful to make a weekly plan. Here is a very simple weekly planner in an Excel spreadsheet. The best way to use it is to print out a set of them (the whole week fits on one A4 page) and then at the end of each week plan what you will [...]
2008 Excel One Page Calendar
For the past few years I've found Excel to be useful for creating one page yearly calendars. Here is is a download link to my 2008 Excel calendar - 2008 calendar. I've highlighted UK bank holidays in yellow but you can change these cells if you live somewhere else. Update: A 2009 Excel calendar is now available.
Excel embarrassment
Microsoft Excel can be great for knocking up complex calculations and graphs. It is however very easy to get it wrong. Here is a good compilation of stories of how even big businesses and organisations make very public screw-ups when using Excel. http://www.eusprig.org/stories.htm
