So I realize this isn’t a tip that everyone can use… not too many people have a bunch of very large images they need to shrink down all at once. And not everyone has Photoshop (if you don’t have Photoshop, I have a work-around tip for you at the end).
HOWEVER, I think this handy time-saving tip is pretty awesome and maybe (hopefully) at least a few of you do too:
My office has baseball season tickets for Business Development purposes. Every so often, we have games that aren’t reserved for BD, so we raffle them off for the employees. Before I got here, the raffle coordinator would actually conduct a raffle… printing out each person’s name on a strip of paper, folding it up, putting it in a hat and drawing a winner. What a waste of time! This is so much faster. And since most of our employees aren’t in the main office any way, it doesn’t matter how a winner is selected (just as long as it’s random).
Here’s how we do raffles in Excel now:
1. Set up the list of names in Excel. All the names should be in one column.
2. Go to Random.org and use the sequence generator to generate a squence of numbers in one column:
This is a handy little short-cut if you need to format information in a document that is not continuous. Instead of highlighting each bit and formatting one-by-one, you can highlight everything and then format all at once. This trick definitely takes some practice, but if you get the hang of it I know you’ll use it a ton.
BTW, have you noticed that the cool new word is “ton”… pay attention, you’ll hear it all the time now. I wonder where it came from…
Continue reading for screen captures of the steps. (more…)
