Anyone certified in excel?

03gade

03gade

Member
I'm thinking about going for the master certification, i didn't know anything about excel last week, i'm finishing up a 6 hr training video tomorrow and then gonna watch some more in depth ones. hopefully after tomorrow i should be good to go for the specialist certification but i feel like putting master on my resume will mean alot more.

Any tips on where to get good info/the test?
 
getting certified essentially means you go to a community college or technical college and your current degree holds no water. But if that is the case, get certified.
 
Needed to be certified as a requirement for the Business School at the University of Denver. Its really easy and you have unlimited tries as long as you pay for them. Just keep retaking the exam until you pass if you have no way of studying.
 
had no idea you could get certified in excel, but i'm a fucking wizard at it. that's what happens when it's the first program you open and the last one you close 8-10 hours later, 5 days a week...year after year.

 
I had to take a semester long class doing nothing but Microsoft Office projects for our business school. So basically I'm a certified wizard in everything excel.
 
excel? like the software?

it's a generic spreadsheet package... can you also get certified in ms word? haha

if you need to use a basic spreadsheet program you should use gnumeric anyways.
 
I use them! Pivot tables make Stats a breeze when trying to create complex graphs of data.

And VBA macros are fun to just fuck around with. (Like making the sudoku solver i mentioned earlier)
 
I was trying to use solver on this kids computer, and for some reason it was in french and he didn't have the option to change it to english. So it was pretty entertaining to try and make it do what we wanted.

Are you certified in french excel?
 
ughhh

excel is NOT meant for stats or graphs! neither is gnumeric, but they have at least fixed the problems that excel has with precision. Microsoft has ignored this problem for over a decade.

Free and a million times better than excel:

http://www.r-project.org/

http://plplot.sourceforge.net/

http://www.gnu.org/software/octave/

http://www.scilab.org/

and for graphing/fitting basic stuff in a more familiar way to excel users (uses tables) use qti-plot:

http://soft.proindependent.com/qtiplot.html

it's free (gratis) for linux and cheap for mac osx/windows. It's open source so you could install it free on mac/windows but I would just pay for the precompiled binary.

Sci Davis is similar (but more limited in functionality) but free for all platforms.

If you want to waste time and money using excel, then go for it. I think that gnumeric or libre office are both powerful enough for what these programs are built for. I use libre office to keep track of my marks and my bills. That's what these programs are designed to do. To quickly set up a sheet to calculate stuff. It's not the proper tool for doing real work.

Take the time to learn the proper software and soon enough it will pay off and you will save lots of time in the long run.

It's the exact same for like ms word.

Sure it might be ok for like a term paper, but imagine how much of a headache it would be to write your masters thesis in word! You might as well learn LaTeX now (or start with LyX).
 
I only have to take Stats 201 for my major so it works just fine for doing the simple stuff like 1 and 2 factor experiments and ANOVA tables.
 
out of curiosity, if use in the business world isn't "real work", what exactly is your definition of "real work". as an accountant, i can't even imagine doing my job without excel.
 
STEM fields.

I was just kidding around though because he coolly said it as if everyone goes into business. Maybe your run-of-the-mill cubical worker can get by with excel (or probably libre office as well). But it's not like the folks at CERN or NASA are doing their work on it.
 
Certs don't mean shit, just a way for schools to get money, past an undergraduate level. I use excel almost every day at work. It's nice to understand how it works, you learn it while you use it
 
I actually use excel to analyze a decent amount of chemistry data. But that's because chemists from the dark ages went through stupid amounts of math to lineariz everything because plotting anything other than a straight line by hand was impossible. You end up plotting the ln of the inverse of the concentration or something else weird though.

But I want to learn fancy computer shit eventually.
 
Agreed. Ive been using Excel at work for 10+ years now. I use it to underwrite real estate development deals and although the IRR calc is slighlty skewed it is still the universal program that is used by finance/accoutning people.
 
No. No no no no no no no. R is one of the worst languages I have ever had the displeasure of programming in. Even Numpy (and people know me to be a Python hater - especially v3.2 and it's list-type and monadic syntax) is a better option. Optimally, Mathematica is best, since it has the only competent resolution of floating point errors for large sig figs. R is like the Ruby of stats languages - there are better out there.
 
come back with free (libre) software and I might listen to you.

PS. Sage is gonna take over (in all it's python glory).
 
Ugh. Freetards. I'm sure you're running R on your Yeelong notebook, since it's the only one that actually uses completely FOSS software including 3rd party BIOS. If not, I'm sure you're using one of the FOSS Linux distributions, since the BSD and MIT licenses are considered to unrestrictive to be FOSS. If not, since most FOSS distros are unusable (even Debian isn't considered FOSS since it is nonfree-capable), then please don't talk to me about libreware. If you mean free as in "I don't want to pay", that's a perfectly valid argument, but not one based on performance.
 
just because I prefer free software doesn't mean I have to go around acting like RMS. I'm not going to use some crazy distro just because debian gives me access to nonfree software. Maybe I should have said open source.

I never argued that the performance of free software was better. You probably know a lot more than me about why mathematica is better than R for stats. You are also probably doing way crazier stats than most scientists need to do. To be honest I don't think I know anyone who uses mathematica for stats. Even if they have it on their computer.

Either way I was recommending it as an alternative to doing stats in excel for crying out loud. Even if it's really that inferior it's still leaps and bounds ahead of excel...
 
sorry i'm late, but yeah i want to get certified just cause i didn't know anything about the program and a few jobs i had to pass up, i graduated magna cum laude from uconn, so its not like i have no qualifications, i just thought it would be nice to put on my resume. also probably dumb, i just learned 2013 which i'm sure noone uses but its whats on my computer, there's no practice tests out there, but you can retry for free these days, i think im just gonna do that.
 
Libre carries a ton of baggage with it. I fully support OSS and people's choices, but FOSS is just a retarded standard. Sorry.
 
You must log in or register to reply here.
Back
Top