Automatic snapshots in Excel using nested IF arrays and drop-down menus
Copying and pasting back and forth from Excel into Word makes me want to bang my head against the wall. I automate the process with =ifs(), =countifs(), and =sumifs(). I preview some of those techniques here.