PDA

View Full Version : Thank God for Excel



Ted S.
10-05-2011, 02:24 PM
Awesome program. I've been using this software for both of my current college courses (Computer Apps in Accounting, and Quantitative Methods(Business and Economic Statistics)).

I've always been a bit afraid of this program because it was a bit too techy for me, but after doing the majority of my QM class on paper, writing out all of the equations and plugging the values in for an easy quick cross reference, I've been learning to use Excel a whole lot better. Just learned to use the data analysis function to help come up with the data needed to estimate a multiple linear regression equation. Way easier that attempting it by hand on paper. (Single linear regression was tedious enough). It even made a nice ANOVA table.

Anyways, if you’ll don’t know how to use Excel, I strongly recommend learning how to use the software to at least an intermediate efficiency. Especially those of you running Detailing businesses who do your paperwork by hand.:props:


I’ve been hunkering down on learning this since a guy I used worked with landed a decent entry level job based on the fact that he is a wizard with the software.

embolism
10-05-2011, 02:28 PM
I use excel a lot

combined with essbase, it is the only way to look at financials

used to have to download off a mainframe then clean up the data ugh...

read up on pivot tables, index and match formulae, and vlookups. Some dead useful stuff with just those 3 functions.

Ted S.
10-05-2011, 03:05 PM
I use excel a lot

combined with essbase, it is the only way to look at financials

used to have to download off a mainframe then clean up the data ugh...

read up on pivot tables, index and match formulae, and vlookups. Some dead useful stuff with just those 3 functions.

I will definately look into those things, especially vlookups. I've read that vlookups is like an alternative to nested IF functions, which are a pain in the ass to get right for me.

kronos
10-05-2011, 05:39 PM
I see it used a lot by some sports bloggers. They use it to try to find correlations between different sets of data, e.g., minutes played and win percentage.

I liked making histograms, scatterplots and bar graphs with it.

What version of Excel are you using?

BobbyG
10-05-2011, 05:51 PM
Microsoft Excel is a great program and a very powerful one at that. I use Office 2007 at work and 2010 at home.

Ted S.
10-05-2011, 06:48 PM
i see it used a lot by some sports bloggers. They use it to try to find correlations between different sets of data, e.g., minutes played and win percentage.

I liked making histograms, scatterplots and bar graphs with it.

What version of excel are you using?

2007

TS656577
10-06-2011, 06:58 AM
I love excel for engineering stuff. The amount of things that can be done with it if you know how to use it is quite amazing. Between the formulas and basic code (if/else statements), excel is something I can't imagine not having now.

CEE DOG
10-06-2011, 07:25 AM
Excel FTW times 1,000,000,000,000,000,000,000,000,000,000

My only question is who doesn't use Excel?!

TS656577
10-06-2011, 08:16 AM
Excel FTW times 1,000,000,000,000,000,000,000,000,000,000

My only question is who doesn't use Excel?!
People with Macs? :poke::dunno:

C. Charles Hahn
10-06-2011, 11:15 AM
People with Macs? :poke::dunno:

Uh, they do make Office for Mac, you know....

maxniman
10-06-2011, 11:36 AM
Excel FTW times 1,000,000,000,000,000,000,000,000,000,000

My only question is who doesn't use Excel?!


Ha - I was just thinking the same thing - it has been around for years

Bunky
10-07-2011, 06:26 PM
Excel FTW times 1,000,000,000,000,000,000,000,000,000,000

My only question is who doesn't use Excel?!

Can Excel calculate that high? Very handy.

rfinkle2
10-07-2011, 07:20 PM
I loves me some excel.

Ech0
10-07-2011, 09:34 PM
Excel at work and Openoffice Calc at home.

331TwistedWedge
10-07-2011, 09:55 PM
i started using excel in the late 90's ... out of 300+ postal employee workers, i got promoted due to my excel skills ... this meant, no more 1pm-1am night shift hours (with 1 day off, usually a tuesday) to a 7:30-4pm mon-friday gig ... i LOVE excel and it saved my life ... lol ...

i now drive a semi locally, but still use it for football office pools ...