I am here for another 2 days, right?
So my boss is giving me busy work, because she doesnt want me to start something and not finish before I go. No problem.
Yesterday, I took the Excel Proficiency Tests they give all their interviewees. She said people were getting really poor scores, and she wanted me (an Excel Guruher words, not mine) to time myself and see how I did. Apparently, I did ok, but not great 75%ish?
I pointed out I didnt know half the terms the tests were referring to, and the hard versions of the Excel tests appeared to be referencing an older verison of Excel, like 2000 or older.
SOI offered to develop new tests for Beg, Intermediate, and Advanced. I also started making application tests---one where the interviewee has to make a spreadsheet. (this is why I asked you ladies about it)
MY POINT: (it rambles)
I built the tests, and passed out copies to the accounting people who had bombed the old versions. They all did about as expectedper my experience with watching them use Excel. I also gave a few versions to non-accounting people who have little-to-no Excel skills, to see if it was too hard. They were allowed to use the program Excel if they wanted to. (I figure if people can cheat on the Excel test, then they can cheat while USING Excel, and be at the beginners level,-right?)
1. I gave one to the receptionist, whom I am friendly with.
2. She gave it to the guy who has the hots for her, who is a self-proclaimed Excel God
3. He couldnt do the advanced one, so he came over to me.
4. He asked me to write him a script in Visual Basic to pull data out of this gynourmous spreadsheet they are using as a database.
5. I recognized some parts of the spreadsheet. It used to be The LeWinter Report, but last week they canned LeWinter, and then re-wrote the report.
6. The New LeWinter Report is over 6 gigs, and WAY easy to crash.
7. I asked Excel God why he wanted the requested scriptand what they use this giant report for.
8. He tells me.
9. I said, You know, when you all were fixing The LeWinter Report, you deleted the ONLY PART that was any use to 1-You, 2-Accounting, 3-The Agents who receive the data from their individual tabs.
10. I also said, I can fix it, and automate the data retrieval, as well as the emails you have to send out twice a month
11. He said, Well it is automated now. The data pulls and then we send out individual emails. We only send them out once a month, because it takes someone a whole day to copy and paste the info into an email.
12. I said, Yeah, thats lame. Let me teach you about MAIL MERGE.
13. I am spending my last 2 days here building the mail merge so they cant mess it up.
Thats right, I just taught Excel God and the CEO about Mail Merge, and probably eliminated the need for another whole employee.
Tell me again why they didnt want to pay me what I am worth? Why did they low-ball my salary offer by $20K?
