Been deep in excel programming this week. These are my top tricks and tips that I found helpful.
Writing a formula that concatenates a bunch of cells into a comma delimited list is a pain. This makes it easier.
When you're automating shape production in powerpoint, but want to make a simple way to select shapes by a given property (shape, size, colour etc).
Creating a fully customisable heatmap in excel. It's visually compelling, reletively easy, and fun too!