Tutorials

I spend a lot of time looking for shortcuts. To save my future self and others from this cruel irony, I've documented some of the tricks I found for doing various tasks common in the kind of work I do. There are surely existing and even more comprehensive materials out there, but if your goals are as narrow and specific as mine sometimes are, I hope you find these tips I've documented for myself helpful.

Excel

Macros

If you find yourself wishing you had an undergrad student to do something for you, you probably just need a macro.

Formulas

They do more than just add stuff up for you!

Pivot Tables

Don't spend time reformatting columns. Use a pivot table! They are magical.

Flash