Excelling at Excel

Alright, that title isn’t entirely accurate… But I’m doing my best and I liked the alliteration, so I’ll call it a win.  I spend a lot of time at my job messing with excel.  Not because my job actually requires much excel knowledge–we mostly use it as a glorified table you can search and filter–but because I love the process of wrestling excel formulas.  I know that there is incredible power in excel to satisfy both my curiosity and my laziness.  And that combination is irresistible to me.  I can create a formula that can check to see if I’ve already met with a student, one that automatically inserts their ID number if I’ve met them before, one that looks at another workbook to see if they’re on probation, and a whole crap-ton of conditional formatting to highlight various points of mild interest.  It’s amazing.  And while I love it, I’m not particularly good at it.  I’m pretty sure at least one of the formulas I just mentioned is broken.  And I cannot for the life of me figure out why or how to fix it.  But the fact that I have something that works even part of the time is immeasurably cool to me.  I love that this is something I’m happy to struggle with.  The frustration of not having it quite right is enough to make me want it more without causing any lasting irritation after I move on to a different project.  It’s just the right amount of challenge without any external pressure.  It’s something I can tinker with without any negative consequences. That’s pretty cool.

 

PS I’ve just noticed that I start all of my sentences with “And.”  I’ll work on that.  Or I won’t.  So there.

Advertisements

One thought on “Excelling at Excel

  1. UPDATE: I figured it out. I figured out why my formula wasn’t working. I had spaces after some of the ID numbers which was causing the formula to count IDs with and without spaces as different people. And now we know

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s