You know you are an Excel guru when ....

[enduser0001]

You know when you are an excel guru when ...
You get a phone call at 4:55 P.M. on a Friday from some manager in another market asking for some God forsaken report about who know's what, and after completing this report and emailing it back, you are still out the door at 4:59.

You know when you are an excel guru when ...
Your boss asks you to work on a particular problem and by the time you chew it up in Excel and send it back to him, he blankly gazes upon all of the lines of data and formulas you have added. At this point he is so overwhelmed and confused it doesn't matter what the data outcome is because he can't rceall what it was exactly that he asked you for in the first place.

 

[Tazguy37]

when you cant take it watching people doing things manually....

Me! I can't even begin to count the number of times I've wanted to grab the keyboard from somebody and just say "Move over!"

 

[Norie]

You know when you are an Access/Excel guru(geek?) when you look at code created in Excel by a Business Analyst (£350 p/day) that analyses 12000 lines of data and takes 2 days, and then export it to Access and run a query that takes 5 seconds.

And then you take apart/clean up the code(all those uneccesary loops/selects) and make it run in Excel in not much longer than 5 seconds.

And you forget to ask for a raise.

 

[tactps]

When you:
- Get excited by the next version of Excel having more rows!
- Think it's funny to point and tell users "press that key", and, when they do, you yell "NO, NOT THAT KEY!"

 

[tactps]

And when you read through 8 pages on this topic, like I did!

 

[tactps]

And when you start writing macros that speak (or should that be email?)

 

[tactps]

When you think this is funny:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = 7 Then Target = 4
End Sub

or this:
msgbox("Hit any user to continue")

or this:
"Step away from the keyboard and keep your hands where I can see them!"

(I'll stop now)

 

[Barry Katcher]

When you keep coming back to this thread, years after it was started, and still think it's funny.

 

[Tazguy37]

When you think this is funny:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = 7 Then Target = 4
End Sub

I would LOVE to try that one out on some of my coworkers!

 

[tactps]

--------------------------------------------------------------------------------
Originally posted by tactps:
When you think this is funny:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = 7 Then Target = 4
End Sub

--------------------------------------------------------------------------------
I would LOVE to try that one out on some of my coworkers!

I have - and it was very funny!!!!

I also had one that used speech to tell the employee that they were x minutes late for work and that payroll and the managing director had been informed by email (I had planned to also put an email in their sent folder - but never had the guts) as a workbook_open event.

I guess I should stop before someone takes me seriously, freaks out and resigns!

or maybe not.....