In this video, a 10 minute clip taken from a webinar that I delivered in 2012, I build a spreadsheet that can be used by anyone planning a wedding. The video covers absolute cell references, SUMIF, COUNTIF and conditional formatting. I used Excel 2011 for Mac but everything works equally well in all Windows versions too.