Listing excel as one of your skills on your resume

>listing excel as one of your skills on your resume
>not knowing how to do a vlookup

better luck on your next interview chum

Other urls found in this thread:

exceljet.net/excel-functions/excel-vlookup-function
youtube.com/watch?v=rOVXh4xM-Ww
youtube.com/watch?v=s-aD1RfgVsw
youtube.com/watch?v=ZXMzolw3SWI
twitter.com/SFWRedditImages

Did you there is an entire subreddit dedicated to Excel? Reddit has so much more variety :(

I can just Google that

reminds me of the alleged SQL expert who had apparently used SQL throughout her entire masters degree and yet couldn't explain how to do a fucking left join

> not knowing how to use a search engine
> better luck working in ancient Excel

exceljet.net/excel-functions/excel-vlookup-function

i use Index Match instead

oh lol i know how to do a vlookup.

im just pissed that we had a candidate today come in who said they knew how to use excel and yet when i asked her about how to do a vlookup she looked like i just asked her how to solve a fucking rubix cube

>not working for your dad working 15 hrs a week making 75K

You're not special for knowing how to use fucking EXCEL. ANYONE CAN GOOGLE IT IN 5 SECONDS AND USE ANY FORMULA YOUR TINY PEA BRAIN THINKS IS "DIFFICULT". You seriously think vlookups are hard you fucking moron?

Lmao, get the fuck out of your $15/hour tech support job faggot. Your skills are useless.

>ANYONE CAN GOOGLE IT IN 5 SECONDS AND USE ANY FORMULA YOUR TINY PEA BRAIN THINKS IS "DIFFICULT"

there are so many people out there who cannot wrap their mind around the concept of 'vlookup'

its honestly like how we look at potential new hires with vs without college degrees:

if you have a college degree it doesnt mean you are smart but if you DONT have a college degree you are definitely an idiot

True, you've opened my eyes to studying before an interview if I lie...

literally this
So if i said i don't know and would use google, how would you react?
>I outperformed my fucking coworker, he had a senior technical college degree even doe i had like 0 work experience.
>he made 1/3 more money
>asking for a raise two times from my boss, didn't got one
>Quit without notice
i was literally trading crypto the whole time, i had like 1 hour or less of real work per day

there are fucking morons who do not even study before going to an interview.

if you study you will be leaps and bounds above the competition

My nig, so much more versatile

Yeah, what you're saying just goes to further prove that you probably work for $15 an hour at a 20 person company making lamps or some shit faggot.

I attended college for 1 year as a Cyber Security student because it wasn't even worth my time. I live in the DC area, picked up an instant $30/hour job right away based on my skills that I learned OUTSIDE OF COLLEGE.

College is literally fucking useless if you are actually intelligent and have the drive to learn outside of the class. Literally the best hires you'll ever have are the kids that didn't waste their time learning forced school curriculum, but rather took their time to really learn what they were interested in, in my case Programming/Cyber Security.

In fact, I'd go as far as to say if you have a college degree it makes many companies look down on you for the simple fact that you weren't smart enough to land the interview without a degree in the first place.

Excel is STILL the greatest program ever written.

says man without college degree and neet

=vlookup('Fucks I Give','Veeky Forums:Veeky Forums',2,FALSE)
>None

I've spent my last 10 years working in Excel every day. It's the most amazing tool there is.

>bragging about $30/hr in the DC area
You don't seem to understand, we go to college so that we don't end up like you
>tfw making $40/hr in Kansas just because I got my degree

>single quotes
>not wrapping that with ISNA() or IFERROR()
nice try

It is.

And yet, most of the "experts" have no idea what Alt+F11 gives them.

you seriously think you'll ever be considered for "senior architect" or "lead developer" if you dont have a fucking degree?

ive never seen a manager without at the very least a bachelor; usually they need a masters degree.

stop shitposting, you need to wake up early tomorrow to get a fresh start on the job hunt

what do you want someone to say when you ask that? explain the function or something?

>tfw put down my I.Q, and the amount I made on Crypto (in %) on my resume.
>tfw got the job.

>but if you DONT have a college degree you are definitely an idiot
Us non-degreed plebs can fix that by voting in laws that require employers who require a degree pay a bonus on hire equal to the cost of that degree. If he jumps to another employer and job requiring degree, another bonus gets paid. BOOM now companies pay for the education they require in their workers (like they always should have, rather than pushing it on the students).

most of the VBA i wrote these days is turning friendly user interface spreadsheets into tabular data so they're pivot table friendly.. also data aggregation where folks have 100s of excel files with data and they need to get pulled together for some analysis.

The world doesn't always work like that. In the larger corporate structure, yes.

But in the small corporate world, all they care about is whether you can do the job or not. For the smaller company, success is the only measure.

I think I'm going to start listing IQ on my resume. Can't hurt me any more than 2 interviews in 2 years...

Oh I've lived in VBA for years.

For a while I used it to crunch data from a 120 unit restaurant company. Some time ago I used it to write a management program for a trucking company.

Since I retired I use it now mostly to write functions to can an analyse options chains.

>But in the small corporate world, all they care about is whether you can do the job or not. For the smaller company, success is the only measure

this is a fucking lie. the smaller companies in the small corporate world are all about building up their infrastructure to be scalable. one they have that in place they will pass you over for that managerial position and entrust it to someone smart enough to have a degree.

this is how it always works

>I’m not competent, I just have credentials that trick people into hiring me
Observe the educated brainlet, Veeky Forums. He’ll successfully climb the ladder, but will always be mediocre.

I’m one of these fancy titles, I pull $130k base (don’t live in NY or SV otherwise I’d be getting 180-200), and didn’t waste my time with school. While this brainlet was racking up debt, I was already at work building my savings.

Nice. What I find most useful about Excel/VBA is the fact that I can write fully functioning software that people are not afraid of, and it works on everyone's desktop without some random dependencies that corporate hasn't approved of. I've watched good engineers spend days writing sophisticated programs to parse data/logs in various ways while I can do everything they are in an hour using Excel, then another 30 minutes to give it a friendly face/dashboard for mgmt. Congrats on retirement, I will be there in about 4 years.

>implying a vlookup is difficult
>implying vlookup implies you "know excel"
So many stupid implications.

>not knowing how to use R

I'm a noob VBA guy. I basically can use the recorder and make a button to start it.

Any good books or videos on how to make an actual program in vba? Like with a splash screen and all that, like you two are describing?

That's simply not true. For example, with one of my former clients we made a $150k/year billable deal over the phone, in 5 years I only met the guy in person once, and he NEVER asked me about my education.

What he DID do though is talk to people who had worked with me and asked about my reputation.

Outside of the large corporate structure, no one gives a shit about degrees. If you do the job, you move up. If you don't, you move out.

Wow...I wasted my time and money...
How can I get out of my dull $49k job?

yes use the wiseowl tutorials on youtube. recording a macro isn't nearly as effective as writing script. you need to know for/while loops and other crazy vba shit like making a drop down menu have multiselect options

I've skimmed through a couple books, but most of the useful knowledge I've gained was through experimentation in solving a real-world problems. Granted, I probably noobed my way through that by grabbing code snippets from stack overflow. Sorry, I don't have a better answer.

check em
-vba god

I'm not sure, I'm self-taught.

When I started, I started by using the record button, then going in to see what the code looked like.

I think I bought just a simple book on VBA functions, and the function help screen gives you a lot of good information.

Most (if not all) functions inside of worksheets are available in VBA; but VBA also has the additional benefits of allowing you to write custom functions, use classes, use external libraries, etc.

If nothing else, the first thing you will want to learn is how to put values in cells.

For example....

Thisworkbook.Worksheets("MySheet").range("A1").value="Hello World"

Putting values into cells, or reading values from cells is a good place to start.

actually the better answer i can give is not to worry about remember syntax and such, but understanding what the platform is capable of -- i.e., what you can do. understanding data, how to transform it so you can analyze it is important. all of the syntax and such you can look up later.

>Asked her
>She looked
>Her
>She
This is totally normal. Interviewed a female who had 3 years java experience, she couldn't even code a Fibonacci counter. All the other dudes aced it. Female colleague gave her some pseudo code to work with. She still couldn't solve shit. She still got the job anyway, but was fired later for false sexual assault accusations

hilarious. ITT: a lot of incompetent excel fags trying to convince each other they know something. Get the fuck out of here

>tfw data entry specialist
>tfw paid to play puzzles with excel all day
>literally just vlookup'ing my life away

I hate my job more than anything else in the world. Learning statistics & econometrics to incorporate into my excel work. Maybe someday I can at least be paid more for doing this cuck tier bullshit

riiiiiggggggttttt

save yourself the headache of using a deprecated language like VBA and use python to interact with excel instead

The nice thing about excel is that it can be used in nearly every business.

Knowing how to use excel enhances your abilities, makes your life easier, and makes your company more money.

i work from home and make $200k/year diddling in spreadsheets as an "incompetent excel fag", i'm okay with this.

I'm not theoretically opposed to the idea, especially in-house. With some of my old clients I would often use other languages to interact with Excel.

But if you're going to deploy anything to your clients, it's often easier to just use the vanilla version.

I hope you at least take a few minutes each year to feel guilty about working in your PJ's and listening to the TV all day while you're working,.

>Makes your company more money
What a wagecuck. I work the bare minimum to not get me fired. I absolutely hate the thought of making money for my boss. I know how much he earns and it's unjustified. He even slaps my face with the facts every time he is drunk and any chance he gets. Instead of climbing the corporate career through hard work, I take credit for the work of my team and get promoted playing office politics, best advice that drunk fuck ever gave me. The politics is what makes me wake up and go there. I'm 26 now, and in upper management for a big conglomerate. Dont even know how gnome3 looks, last one I used was 2 when Ubuntu was still cool. Main goal is to end up on the board.

I feel guilty about it every day, especially as I watch siblings do something they hate as a career. CNBC keeps me company.

holy shit are you me?

im in this pretty much the same position, except havent quit yet

did it work out? did they fuck you over when it came time for a new job reference?

honestly who cant do a vlookup?

I don't know how long you've been doing this, but I was doing it from 2003-2010, and CNBC was always on in the background.

It was pretty amazing to watch the whole boom and bust live on TV

I literally interviewed someone last month who said they were an excel master. I asked them about VLOOKUPS and they gave me a blank stare.

Not as far back as you, but I do go back and watch the various clips of CNBC reports from 2008/2009 on youtube. I got interested in markets a little too late to take advantage fully.

>control F

It was odd. Prior to the crash, most people thought that the leaders were too smart to let a crash happen.

When the crash happened, there as a full freakout.

The three things that stand out in my mind...

1. Jim Cramer having a total meltdown on live TV:

youtube.com/watch?v=rOVXh4xM-Ww

2. When the first bailout vote failed, and the dow collapsed before our eyes as no one knew if anyone would survive:

youtube.com/watch?v=s-aD1RfgVsw

3. When Mark Haines called the bottom and the brokers cheered, because if anyone could call the bottom he could.

youtube.com/watch?v=ZXMzolw3SWI

...

>I've spent my last 10 years working in Excel every day. It's the most amazing tool there is.

Clark?

>if you have a college degree it doesnt mean you are smart but if you DONT have a college degree you are definitely an idiot

So the guy who took on a six-figure debt that is immune to remedies like bankruptcy to get a job that maybe starts around $50K if he's lucky...but the guy who didn't go to college and can do your job and 10 others simultaneously AND do it better is the "idiot". Right.

Sounds like you are invoking the typical educated idiot self-affirmation...like you know you are a fucktard and real need some way to justify pissing away 4+ years of your life and a lot of money on something that has no real chance of showing ROI.

>you seriously think you'll ever be considered for "senior architect" or "lead developer" if you dont have a fucking degree?

Who the fuck cares about a title?

>ive never seen a manager without at the very least a bachelor; usually they need a masters degree.

McDonalds really trying to raise the bar...

>stop shitposting, you need to wake up early tomorrow to get a fresh start on the job hunt

Another cuck who fell for the "you need college to succeed" bait. You'll need $100K per year just to break even on rent/mortgage and the loans you took out...lolol

>this is a fucking lie. the smaller companies in the small corporate world are all about building up their infrastructure to be scalable. one they have that in place they will pass you over for that managerial position and entrust it to someone smart enough to have a degree.

Smart people don't need a degree to "prove" it. Their accomplishments speak for them.

>this is how it always works

You're clearly drinking some rancid koolaid and operating at a severe level of cluelessness.

It's too bad Bill Gates dropped out of college. If he had just stuck it out, he could have amounted to something.

>his job involves using spreadsheets as a major job function
Enjoy your sub $40K salary, loser.

what do you do user?