I teach myself vlookup again every time I have to use excel.

like
Posting as :
works at
You are currently posting as works at
Highlighted IconHIGHLIGHTED

We're proud of you!

like

Memorizing formulas is like memorizing the dictionary. The real skill is in knowing where to go and how to build a formula. And google... using Google to find someone who has already asked that question and gotten a formulas :D

like
Recent IconRecent

Wait till you find out about index match and index match match

like

MBBD!

like

Keep this crap to yourself... Sincerely, your colleagues

like

I honestly can't believe there are consultants who don't know vlookups

like

@BCG1 haha...probably won't. I avoid excel at all costs. Just don't get on projects that require me to use it.

like

That's incredible

like

Not knowing excel will bite you eventually. It's like not knowing how to spell. Sure you can survive but you'll look like an idiot.

like

@bcg2 completely disagree. You don't have know excel to survive in consulting. I don't enjoy heavy data analysis, so I don't do it and I don't get staffed on projects that do because that's not why I'm here.

like

@D1 I do the exact opposite. Whenever I have a call with someone who wants to staff me, I let them know that I don't do data analysis...which is fine because those aren the projects I'm working on.

like

I watch the YouTube video every time. Luckily, I have BAs/SCs now which means no more excel for me.

like

Honestly, not to be too mean, but this is why more than 40% of jobs are projected to disappear over the next 20-30 years- you're gonna be automated :/

like

@KPMG2 and I would forget it as soon as the exercise was complete

like

A few members on my current team are from Human Capital, and the MANAGER was visibly frightened when she found out she needed to do a vlookup...

like

^Throw an ISNA or ISERROR in there after the if(

like

What is hard about vlookup I've never understood this

like

You don't give yourself enough credit, OP. Force yourself to use it on a weekly basis and you'll never forget it. Even if it isn't for work, I download.CSV files from investment sites to build fun dashboards and find opportunities. It's exciting when you master 1 formula. It's addictive as you add new ones.

like

Watched a Senior Consultant YouTube how to insert rows in excel. Person has15+ years of working experience. Also this person got hired for a role that is 70% in excel...

like

Probly one of those things you say on a more anonymous setting

like

Related Posts

There’s now a lawsuit in Texas challenging PREP. How much longer do y’all plan to live in the US? This is actually how I predicted this would unfold. That folks with moral objections would file a lawsuit like this, and then get it up to The Church for review, and then overturn Lawrence v Texas. This is just happening a lot faster than I thought.

like

I got a 7.5 % hike despite a progression from Senior Grade 1 to Grade 2. Has it been the case with most of the fishes here or is it just me? SSL - EY Private( BTS)

like

Anyone working at Levy Ratner? How is the office culture and about how much do you get paid?

like

I have given my managerial round last Friday, but i haven't received any email or call from HR. How long it will take? And HR notify us if we are not selected.

like

I'm looking to rent a *fully furnished* 1BR or studio, starting mid-August or September 1st. I'd appreciate advice or leads!

2yrs of post-undergrad experience at D and have offers from two FAANG companies. Worth it to stick it out for a couple more years to open up more offers down the road, or should I get out while I can?

like

Question from a new consultant: how do you manage your frustrations when your manager completely changes their mind about a deliverable, after you put in all the work and finish what they originally asked for on time? Is this normal in consulting?

like

I am asked about salary expectation for Senior Devops Engineer role in Berlin, Germany.
What should be the expectation.
I am currently at INR 30 LPA in Bangalore.
Thanks.

like

Just got an offer at Microsoft. Anyone here I can chat with?

like
like

Does any 🐠here work at L.E.K? How is the culture and do you have many opportunities to work abroad

like

One says they are regional AOY, the other claims SEA AOY. A joke of an awards show.

Post Photo

Help me ask for a raise in my upcoming performance review? In sum, my company’s HQ is in Texas and I feel I’m being paid a Texas wage when I live in Los Angeles (the role is remote). We do have a San Francisco office and I want to ask my boss to match me what staff are making there. As that’s more comparable. Based off of Glassdoor, my salary matches Texas’s exactly and SF has the same role at 10k more. Should I show him the Glassdoor page? Don’t want to come off too strong. Please advise

like

Hello Fishes, Just curious to know anyone working with any gaming companies (EA Games,Activision, ubisoft, Sega,etc)
Like how do they hire?
Which tech stack they would be looking for?

likehelpful

Brand new (like, just-had-a-kid new) mom here. Life seems manageable with the baby sleeping much of the time. It gets worse from here doesn’t it? I’m scared 😱😱😱

like

What has been difficult for you in the endeavor to complete half your deen?

like

Anyone know how to be selected for Prestige 40 under 40? Don’t think can apply

like

Just found out my husband is being transferred to the Chicago area in about two months, I know finding a new job mid-school year will be tough but if anyone has any leads on a secondary opening please share!

likesmart

Additional Posts in Consulting

How long can u stay in the bench before getting fired at Accenture?

like

Anyone have any insight into Infosys bonuses? Specifically, what sort of payout ratio (maximum potential vs. actual payout)?

like

Anyone have specific financial goals they're willing to share and how to get there? I'm 30 yo, l10 and $$ gives me anxiety. Currently making ~$95k with $30k in brokerage and $30k 401k. Or, tips for not stressing out that I'll be broke in retirement? Should I make a lateral move out at some point and target a $250k salary by X age?

like

Vision 2020+ 🙄

like

I left Accenture Strategy right before the regional model got announced. How has it affected things at the Consultant and below level?

like

Looking to improve general communication skills (especially around structuring narrative/ key messages), any books/courses that you would recommend?

like

It's 9:05am and the client till isn't in yet... Wtf?

like

What are some good questions to ask Partners for a team day question panel?

like

When conference goers come into the Sheraton lounge and are *blown away*

like

Does anyone know if dry shampoo counts as a liquid? It's an aerosol, but not a liquid, right? Any personal experience? Thanks ladies! Or men that use dry shampoo... 🤔🙃

like

Almost 4YOE at Big 4 TAS. Seen high turnovers this year. Thoughts on the following options: FPA vs. CorpDev vs. MM IB vs. MBA to BB/EB or MBB?

like

Bain fish, does anyone know how utilization in North America is trending for this year?

like

Help - how do I fight claims by scammer healthcare providers?

I recently went to 2 different providers.

Dentist, made appt via Zocdoc to see a dentist that was in network. Another dentist at the location saw me instead who was out of network. I have text evidence they said it would be covered before visit. Claim was denied - asking for ~500 dollars.

Saw a specialist who’s office staff verified my insurance would fully cover the claim. Get the claim, says they are out of network. Owe 600.

like

What is the best consultancy for Media and Entertainment work? Considering a move…

like

What are your book recommendations?

like

Charlotte has to be the slowest moving airport!!!

like

Since we’ve all been working from home for months now, what’s the best office chair out that y’all are using for our long work from home hours? Looking to invest in a better one than my ~$150 one from Amazon.

like

Just fired my therapist. Feels better than it should

like

Question: obviously in a standard configuration the middle seat gets the arm rests, but who gets it in a regional 2x2 format? Window? Aisle? Survival of the fittest?

like

2yrs of post-undergrad experience at D and have offers from two FAANG companies. Worth it to stick it out for a couple more years to open up more offers down the road, or should I get out while I can?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal