I feel bad saying this, but also try learning Visual Basic for Applications with Excel. This is actually a great suggestion for anyone who works with Excel a l

I feel bad saying this, but also try learning Visual Basic for Applications with Excel. This is actually a great suggestion for anyone who works with Excel a lot. Knowing VBA (VB for Apps) can save you (or your assistant) hours of repetitive work. Here's a good way to learn: 1. Notice some annoying task that you do regularly in Excel (e.g., importing a data file, preforming a calculation on a data set, or laying out data in a visually pleasing way). 2. Find the Record Macro command, then do the task again. 3. Excel automatically creates source code for the macro. You can open up VBA from some Excel menu; that will show you the code. 4. Edit the code to do what you really want. Often the generated code isn't perfect, or there are other features that you'd like. I will warn you though - VBA is kind of a horrible, poorly documented language. It's not unusable, though - you just don't want to use it for large projects.