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

[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. :)