How to create a email-merge with attachments, CC's, HTML formatting, and from a shared mailbox
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!
Do you need to save a whole bunch of files as PDF? this is the way to do it with the free PDFCreator and VBA in excel/word.
Escape from the boundaries of excel, and grab a list of files from a directory, maybe even change their names
When you get the spreadsheets back from your participants, how do you aggregate all of the data into a research 'database' ?