Although spreadsheets are incredibly simple to use, the complexity comes in the planning and creation of a spreadsheet that does exactly what you need. Once you have the requirements, and know how you want it to work, you will find that implementing the spreadsheet is the easy part.

OT: I have used spreadsheets for years (decades?) but I have yet to know how to create a Pivot Table. I haven't bothered to learn, mainly because I can't find anyone who can explain the basic concept of a pivot table to me. I wouldn't mind if you guys give it a try.

Exactly what is a pivot table, and why would I need to create/use one?