My son Adam has just gone out on his own, as a fitter for a window company. He's been doing it for just over a month now and its become clear (to ME) that it would make life much easier for him to keep track of his expenses if he had some sort of spreadsheet

Now, not that I'm the interfering type of Mother but I thought I'd 'try' to make one for him, so that all he has to do is, open it and fill in the appropriate boxes and hopefully, at the end of the month, press a button and everything is totalled

I've got a Mac version of Microsoft Excel, which although I have had a play with some time ago, I'm really a complete novice

He will basically need..

The Date

1 column for Parking expenses

1 Column for the Congestion charge

1 column for Materials

and 1 column for miscellaneous


I need to know what option I need to start with(I kind of presume its 'data analysis?)and what I need to add, so it knows to add the columns up

What would be REALLY cool, would also be if somehow he could also have a way of adding the price of the job, so that it calculated the percentage due to him at the end of each month. But I'll settle for the list above first!

Any tips gratefully received