May 10, 2013
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...
Feb 27, 2013
This tutorial was prompted by a question on one of the LinkedIn groups I’m a member of. An IT Technician has a spreadsheet that displays a list of tickets submitted to the HelpDesk. Each ticket has a status (for example Resolved, Pending, etc) and a date. The...
