Aces High Bulletin Board

General Forums => The O' Club => Topic started by: rpm on September 30, 2005, 09:25:30 PM

Title: Gawd I Hate Excel
Post by: 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?:mad:
Title: Gawd I Hate Excel
Post by: AdmRose on September 30, 2005, 09:29:41 PM
Alcohol often enhances the computing experience.
Title: Gawd I Hate Excel
Post by: Russian on September 30, 2005, 09:29:58 PM
Forget Excel and go straight to Access.
Title: Gawd I Hate Excel
Post by: VOR on September 30, 2005, 09:33:29 PM
Good luck. Look on the bright side...at least it isn't Access or Powerpoint.
Title: Gawd I Hate Excel
Post by: Eagler 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
Title: Gawd I Hate Excel
Post by: AdmRose on September 30, 2005, 09:38:51 PM
Play the Excel drinking game!

Everytime you get an error message - take a shot!
Title: Gawd I Hate Excel
Post by: Eagler 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? :)
Title: Gawd I Hate Excel
Post by: AdmRose 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?
Title: Gawd I Hate Excel
Post by: rpm 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.
Title: Gawd I Hate Excel
Post by: Eagler 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 :)
Title: Gawd I Hate Excel
Post by: rpm 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.
Title: Gawd I Hate Excel
Post by: AdmRose 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? :D
Title: Gawd I Hate Excel
Post by: Gunslinger on September 30, 2005, 10:24:06 PM
Excel is easy but just takes experience.  There's several help sites online as well.
Title: Gawd I Hate Excel
Post by: Scherf 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.
Title: Gawd I Hate Excel
Post by: rpm on September 30, 2005, 11:07:16 PM
Quote
Originally posted by AdmRose
The VLOOKUP, or the drinking game? :D
Column formatting.
Title: Gawd I Hate Excel
Post by: fuzeman on October 01, 2005, 12:55:57 AM
Try this:
Here is Excel:
http://office.microsoft.com/en-us/training/CR061831141033.aspx

Here is Access:
http://office.microsoft.com/en-us/training/CR061829401033.aspx
Title: Gawd I Hate Excel
Post by: Scherf on October 01, 2005, 07:56:57 AM
Quote
Originally posted by Eagler
forget access and go to Oracle



Charge your clients vast quantities of $$$ for Oracle, then make good your escape before they realise how doomed they are.



:noid
Title: Gawd I Hate Excel
Post by: Nilsen on October 01, 2005, 09:59:24 AM
Forget it all and get cute secretary that excells in...
Title: Gawd I Hate Excel
Post by: Chairboy on October 01, 2005, 10:31:31 AM
Access is like Fisher-Price's My First Database.

And it's NOT excel.  It does different stuff.
Title: Gawd I Hate Excel
Post by: Sandman on October 01, 2005, 10:55:25 AM
Quote
Originally posted by Eagler
no expert but would be glad to help if I can - VLOOKUP is a wonderful thing sometimes :)


Damn straight... VLOOKUP and nested functions can make you appear godlike. ;)
Title: Gawd I Hate Excel
Post by: Scherf on October 01, 2005, 11:20:55 AM
Pivot tables are good too.
Title: Gawd I Hate Excel
Post by: Sandman on October 01, 2005, 11:21:50 AM
Yeah... but they're pretty easy. ;)
Title: Gawd I Hate Excel
Post by: Scherf on October 01, 2005, 02:00:00 PM
Shhhhh!

Don't tell!