Here is a collection of Excel functions that I found to be very useful in certain situations.

• Convert report into data table
• Convert YYYYMMDD to date
• Count within groups – formula
• Create a group column based on existing values
• Filter bold text
• Football bet template
• Job satisfaction check
• Romanian Whist score keeper
• Subtotal on filtered data
• Team Holiday Planner

… adding as I find new stuff.