mastery over Excel

[juldea]

So it's not really anything cool in the long run, but dammit, it makes me feel awesome....

After a couple hours of trial and error yesterday and a couple this morning, and I have created a huge VB macro in Microsoft Excel to automate the boring, brain-numbing, time-consuming weekly task of formatting a particular report I get from the Finance Dept into something not just readable, but scannable.

So normally I go through this set of commands that takes half an hour or so every week... now I just hit the macro and it's all done within seconds. And I WROTE IT. Like... I'd record some commands as a macro, go into the editor, extrapolate from what I saw, and go on to add additional commands without needing to record them.

Hey, it's the little joys in life, y'know?

i r teh smrt

Comments

You are my hero

[anitra.livejournal.com]

I do not have enough time and energy to learn Excel macros (probably because I don't use Excel very often.)

See, you don't need to be a super-smart computer person to do cool automated stuff! Maybe I shouldn't have spent all that money going to WPI...

college

[juldea.livejournal.com]

Remember that I only make $14/hr to do this. ;)

[idonotlikepeas]

Every time you make the machine do what you want it to instead of the other way around, it's a win.

[juldea.livejournal.com]

Good point.

[alexx-kay.livejournal.com]

Go you! That's halfway to being a database manager :-)

[juldea.livejournal.com]

What's the other half, how well does that pay, and how much of my soul will I lose if I become one? ;)

[alexx-kay.livejournal.com]

Doing similar things in Microsoft Access (or Filemaker). Well, that, and actually being called one, I suppose.

~8 years ago, I was making $16.50 an hour at it, as a temp.

I don't think it's any more soul destroying than general clerical work. Arguably less, as management usually doesn't bug you as often :-)

[juldea.livejournal.com]

*hmmmm*

I can wrangle Access too... Never played with Filemaker.

Not being bugged by management = doubleplusgood.

[corwyn-ap.livejournal.com]

And thus she takes her first hesitant steps down the road to hardcore software geekdom...

This is how we all got sucked in.

Good for you,

[juldea.livejournal.com]

I thought that was the CS course I took in University?

[en-ki.livejournal.com]

Nah. CS students may or may not be geeks. People who use their computers effectively are. I know whereof I speek.

[juldea.livejournal.com]

Well, then, let me rephrase: "That CS course I took in college, wherein it was pretty unnecessary for me to take the final because I'd get an A anyway, but I still did and ended up with a final grade of 130-some%, and yes this was CS for CS majors and not CS for art majors."

[en-ki.livejournal.com]

I was thinking more of the limitations of some CS undergrads and grad students I have known.

[juldea.livejournal.com]

Well, true. But I wasn't one of those, I was just taking the course for fun. :)

[adalius.livejournal.com]

Soon you shall know the power of the dark side.