Author Topic: Gawd I Hate Excel (Read 409 times)

rpm · « **on:** September 30, 2005, 09:25:30 PM »

I'm having to learn Excel from scratch on my own for work. I can see the wonderful performance it's capable of, but I am "hunt and pecking" my way thru it. I've even tried using the wizard to format columns, but wind up doing the formulas 1 cell at a time.

Why on earth did'nt they teach this when I was in school? All those wasted hours learning punch cards... Where's my bottle of Jack?

AdmRose · « **Reply #1 on:** September 30, 2005, 09:29:41 PM »

Alcohol often enhances the computing experience.

Russian · « **Reply #2 on:** September 30, 2005, 09:29:58 PM »

Forget Excel and go straight to Access.

VOR · « **Reply #3 on:** September 30, 2005, 09:33:29 PM »

Good luck. Look on the bright side...at least it isn't Access or Powerpoint.

Eagler · « **Reply #4 on:** September 30, 2005, 09:34:17 PM »

forget access and go to Oracle

what are you tryin to do in excel

to format column:
format top cell, copy, select column, Paste Special, Formula

AdmRose · « **Reply #5 on:** September 30, 2005, 09:38:51 PM »

Play the Excel drinking game!

Everytime you get an error message - take a shot!

Eagler · « **Reply #6 on:** September 30, 2005, 09:41:51 PM »

Quote

Originally posted by AdmRose
Play the Excel drinking game!

Everytime you get an error message - take a shot!

can you do that at work?

AdmRose · « **Reply #7 on:** September 30, 2005, 09:44:20 PM »

Quote

Originally posted by Eagler
can you do that at work?

Depends. How much do you need your job?

rpm · « **Reply #8 on:** September 30, 2005, 09:45:50 PM »

It's a payroll spreadsheet with 7 departments. I have to breakdown hours, overtime, costs, ect. This store was doing it by hand and entering it into forms. I copied the spreadsheet from the home store, put it on my work computer, emailed the sheet to myself at home and I'm setting it up for my new store. I had to change all the personell, pay rates, ect.

I found the Jack, BTW.

Eagler · « **Reply #9 on:** September 30, 2005, 09:48:05 PM »

Quote

Originally posted by rpm
It's a payroll spreadsheet with 7 departments. I have to breakdown hours, overtime, costs, ect. This store was doing it by hand and entering it into forms. I copied the spreadsheet from the home store, put it on my work computer, emailed the sheet to myself at home and I'm setting it up for my new store. I had to change all the personell, pay rates, ect.

I found the Jack, BTW.

no expert but would be glad to help if I can - VLOOKUP is a wonderful thing sometimes

rpm · « **Reply #10 on:** September 30, 2005, 09:52:29 PM »

Thanks, Eagler. I've got it whipped now. That earlier suggestion saved me at least an hour.

AdmRose · « **Reply #11 on:** September 30, 2005, 10:14:52 PM »

Quote

Originally posted by rpm
Thanks, Eagler. I've got it whipped now. That earlier suggestion saved me at least an hour.

The VLOOKUP, or the drinking game?

Gunslinger · « **Reply #12 on:** September 30, 2005, 10:24:06 PM »

Excel is easy but just takes experience. There's several help sites online as well.

Scherf · « **Reply #13 on:** September 30, 2005, 10:48:57 PM »

Deleted.

7- Members should remember this board is aimed at a general audience. Posting pornographic or generally offensive text, images, links, etc. will not be tolerated. This includes attempts to bypass the profanity filter.

rpm · « **Reply #14 on:** September 30, 2005, 11:07:16 PM »

Quote

Originally posted by AdmRose
The VLOOKUP, or the drinking game?

Column formatting.