Merlin’s weekly podcast with Dan Benjamin. We talk about creativity, independence, and making things you love.
Open Thread: How are you using Excel?
Merlin Mann | Aug 22 2006
Yesterday, I mentioned I'd been talking with someone who's looking at interesting things people are doing with Microsoft Excel. I talked to her again yesterday, and with her official okey-dokey, I'll virtually introduce Tralee Pearce (*waves*), a reporter from Toronto's Globe & Mail whom you might remember from a very swell article about the Hipster PDA. So, by request -- and to help Tralee with fleshing out her fun-sounding article -- I hope you all will jump in here: What kind of cool, novel, and non-obvious stuff are you doing with Excel? What's the wildest, most obsessive, most nerdy thing you ever saw someone do with our favorite spreadsheet program? 119 Comments
POSTED IN:
 Make your own paintings in...Submitted by JayGH (not verified) on August 29, 2006 - 9:37pm.
Make your own paintings in XL with this VBA code: Sub filly() Dim RR, GG, For RR = 1 To 70 For GG = 1 To 88 Cells(RR, GG).Interior.Color = RR ^ 2 * 4 * GG ^ 2 Next Next End Sub Someday I'll flesh out our puny isp 'personal web page' and share vba for * Attendance Tracking (Occurrence or Point system with bells & whistles) * Tool for adjusting 2 polypropylene's % in a plastic for desired Melt Flow * Tool to visualize color and it's 'neighbors' a little; redder, yellower, greener... Tips for Excel noobs: * Use it often for best retention * Tools/Customize/Options and then Always show full menus * Learn Index & Match (not VLookup) * Avoid merging cells if at all possible (trust me, it's almost never the only way * to get an effect you want and it will cause problems when you want to copy & paste) * Use Autofilter * Get familiar with the F9 key if you share workbooks or a PC with others * Visit Erlandsen, Pearson, Blood, Contextures, McRitchie, and others who * have put a wealth of good info on the web for our benefit. » POSTED IN:
|
|
| EXPLORE 43Folders | THE GOOD STUFF |
