Log in

No account? Create an account

Previous Entry | Next Entry

I've been juggling MS Excel for two years now. I recently taught myself the joys of "V-Lookup," a wonderful function that has made it possible for me to make a spreadsheet that instantly calls up product inventory levels, relative reading difficulty levels, price and sales history by entering in a 10-digit product number. I'm SO thrilled. This is endless hours of work reduced to about six cut-and-pastes. Woot. I just bought the Excel 2003 Bible. I took it to bed a few nights ago. The pages with pivot-tables stick together now.

Well, no, that's just wrong. That didn't happen.

Anyway, I'm *good* with excel. Not *great*, but pretty good. Definately "my next class will be advanced usage" good.

I'm building a spreadsheet to automagically reference three other spreadsheets, and my boss looks over my shoulder, and says "you're building a spreadsheet?"

"yep," I say. "Real labor-saving."

He points at the screen, where because of the default column widths, a book's information is listed as

ISBN              TITLE       PRICE
1078345965        Susie and th$5.50

and says, "You know, you can make that column wider, so it shows the entire title!"

Yay for personal discoveries...


( 8 comments — Leave a comment )
Mar. 3rd, 2005 12:37 pm (UTC)
LOL - I can completely relate.

I've learned so much about Excel in this position. (I too love V-LOOKUP.) But there are so many things to know about this mysterious little application, that you find yourself wondering, "Will it take me longer to just put this information in, or to find a way to make the spreadsheet do it for me?"


I send you patience and luck in building your wonderful work-saver.
Mar. 3rd, 2005 12:52 pm (UTC)
bosses are SO helpful sometimes, aren't they?
Mar. 3rd, 2005 01:07 pm (UTC)
I don't know. "Susie and the $5.50" could be an interesting book in a whole different kind of way.
Mar. 3rd, 2005 03:05 pm (UTC)
" I just bought the Excel 2003 Bible. I took it to bed a few nights ago."

I *do* hope that you at least bought it dinner first..... *stern look*

Mar. 4th, 2005 05:36 pm (UTC)
I recall once, when I was a student working at UT, my fiftysomething coworker -- who had, you must know, been doing her job for a good twenty or thirty years -- said the following:

"athene1765? (that's my name, you see) You're good with computers right?"
"Could you help me with this?"

I scootch my chair over and peer at her computer. She is using Excel.

"I want to save this document. But I don't want to save over what I already had. Can I...can I give this another name?"
"...Click File. Click Save As."
"Ooooh! You're so smart! Thank you!"
Mar. 7th, 2005 11:25 am (UTC)
Nod...My mother was dragging all her text into a new document to do the same trick.
Mar. 9th, 2005 04:54 pm (UTC)
I must belatedly also add my 'huzzah for VLOOKUP'. That function make sooooo many silly things easier for my day to day Excelleration.
Mar. 9th, 2005 08:31 pm (UTC)
Good use for MS Excel files...
Open with openoffice.org
Enjoy a different take on the "everything but the office sink" UI

( 8 comments — Leave a comment )