Tuesday, September 10, 2013

Light Bulb Moment

I swear sometimes I make things more complicated than they have to be. And then I have that "Aha!" moment where the light bulb goes off. It happened to me today and I just had to laugh at myself. I've been spending a lot of time on the spreadsheets for work, getting ready to export/import our contacts and data from one program to the next. Naturally I'm frustrated and feel like my brain is fried with all of these functions and cells in Excel. So when it came time to transfer from one workbook to the next, I failed horribly. I was copying columns and getting crazy error messages because of all the formulas. I searched Google for ways to take care of this with other shortcuts and functions so my data wouldn't change format or disappear into randomly coded symbols. It was time consuming and tedious, I was at my wits end. I thought to myself - there HAS to be an easier way to do this.

And then it hit me. I could simply keep the same sheet I had, and change the title of the columns to match the sheet where I was trying to transfer the data. It was that easy the whole time. I felt so stupid for wasting all that time and energy! But I had to laugh it off. At least I learned new functions and cheats for Excel. I've just improved my skills. There is a silver lining!

- L

Goofy light bulb
img src

5 comments:

  1. It's funny how the smallest things can make you insane until you just take a step back.

    ReplyDelete
  2. exactly! I need to take a step back more often and save myself some heartache

    ReplyDelete
  3. exactly! I need to take a step back more often and save myself some heartache.

    ReplyDelete
  4. Excel is a scary scary place. It's fantastic that you figured it out.

    ReplyDelete
  5. It definitely is. I cannot wait for the days where I never have to look at excel again.

    ReplyDelete

Show me some love, share a suggestion, add an idea, or just say hello...