43 Folders

Back to Work

Merlin’s weekly podcast with Dan Benjamin. We talk about creativity, independence, and making things you love.

Join us via RSS, iTunes, or at 5by5.tv.

”What’s 43 Folders?”
43Folders.com is Merlin Mann’s website about finding the time and attention to do your best creative work.

Open Thread: How are you using Excel?

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?

JayGH's picture

Make your own paintings in...

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.




An Oblique Strategy:
Honor thy error as a hidden intention


Subscribe with Google Reader

Subscribe on Netvibes

Add to Technorati Favorites

Subscribe on Pageflakes

Add RSS feed

The Podcast Feed


Merlin used to crank. He’s not cranking any more.

This is an essay about family, priorities, and Shakey’s Pizza, and it’s probably the best thing he’s written. »

Scared Shitless

Merlin’s scared. You’re scared. Everybody is scared.

This is the video of Merlin’s keynote at Webstock 2011. The one where he cried. You should watch it. »