#18 - Teach myself to use Excel

Elizabeth February 27th, 2008

Part of my 101 Things in 1001 Days challenge

logo_excel.gif

I can finally hand in my tattered membership card to the “I can’t use Excel” club!

Against all the odds, I’m crossing this one off my list. I managed to fight all the barriers that stood in my way (procrastination, reality tv, lack of giveashit) and figure out why people are so into this spreadsheet fad.

Actually, I admit that Excel is kind of cool. I’ve never had to use it at work, and never saw a purpose for it in my personal life, so it’s just one of those things I never got around to. But now that I’ve seen all the awesome stuff it can do, I’m spreadsheeting everything to the point that I think I might have a bit of a problem.

This morning I woke up at 5am, unable to fall back asleep because I couldn’t stop thinking about a new idea for a spreadsheet. I ended up getting out of bed and creating an exercise-tracking, diet-watching masterpiece that would bring a tear to your eye! And although my new hobby might be bordering on obsessive compulsion, at least it’s fun.

See? (Identifying figures removed!)

excelgraph.gif

If that’s not the most incredible weight-loss graph you’ve ever seen… well, I’ll eat my hat. In fact, let me just create a spreadsheet for Hats forcibly consumed in 2008 just in case, ok?

OK.

8 Responses to “#18 - Teach myself to use Excel”

  1. fragilehearton 27 Feb 2008 at 5:16 pm

    Ah excel. My best friend… I use excel spreadsheets for so much. Even something as simple as printing a schedule of my favourite TV shows! Like I said in the Sarah Silverman post, I’m a geek ;p

  2. fragilehearton 27 Feb 2008 at 5:16 pm

    p.s. I meant to add, Congratulations! on discovering the wonders of excel :)

  3. Justineon 27 Feb 2008 at 5:53 pm

    haha - it’s like crack, isn’t it. I love Excel. I excel EVERYTHING too. We should form a facebook group. LOL

  4. Hirenon 28 Feb 2008 at 4:19 am

    I know this is a totally random comment, but I humbly submit a suggestion for your new-found Excel skills:

    http://www.flickr.com/photos/mickeydog/2295762483/in/pool-songchart

  5. Elizabethon 28 Feb 2008 at 11:42 am

    Hiren: That is hilarious! It’s about as pointless as the stuff I’ve been making, too :D

  6. Davidon 29 Feb 2008 at 3:42 pm

    Congratulations on learning something new. Your new-found knowledge will open a lot of doors for you; personally and professionally. One of the best way that I’ve found to expand that knowledge base is to find a need to use Excel. One that requires you to push, and expand, your limits.

    Excel can be a very useful application. Over the years I have found a lot of new ways to use it. I have more than forty excel files on my home computer. One of these currently has 61 tabs on everything from finances to “Deal or No Deal” and my 101 list in graph form. (I’m still working on that last one.)

    I enjoy going on multi-day hikes and have a hike plan sheet. One of the formulas calculates the 7 days rolling average of hiking miles per day. Here’s the formula:

    =IF(G3>6,(SUM(INDEX(H$3:H$207,MATCH(G3-6,G$3:G$207,0),):H3)/7),”")

  7. [...] #18 - Teach myself to use Excel February was the month that I defeated Excel, and started making kickass graphs. [...]

  8. Excel & Music « Beyond 30on 31 Mar 2008 at 4:59 pm

    [...] today and I couldn’t not share it here, because not only is it funny… I actually know people that use programs like excel to graphically represent all manner of things!  Music and statistics [...]

Trackback URI | Comments RSS

Leave a Reply