I’m giving a 90-minute presentation next week entitled Tips & Tricks. I’m not much of a tips guy as I prefer deeper discussions. However, tips presentations simply can’t beat because they allow me to combine disparate items. Nobody would care if I jumped from keyboard navigation to array formulas in a tips presentation. They probably expect it.
I have 35 tips prepared and I’m pretty happy with the list. The crowd will be intermediate to advance Excel users, so I won’t be showing them how to paste special. Oops, now I only have 34 tips. That’s less that three minutes per tip. My fear is that I’ll run out of tips before the 90 minutes. I’ll panic and start singing Streisand or something.
So if you have the time, throw me one or two of you favorite, lesser-known, Excel tricks.