Client just mentioned how consultants are so good at excel because they saw me open Excel without using the mouse (windows key + “Excel”).

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

We outsourced some data analysis and facilitation to a vendor once. I was working with them and said, “So just throw a VLOOKUP on that so you can pull the other data in...”

Blank expression

“Are you familiar with the VLOOKUP function? I’d be happy to walk you through it...”

And that’s the story of how I taught someone doing data analysis for me how to use VLOOKUP.

And people ask me why I don’t delegate more....

likefunny

I had one created a model with a goal seek and a macro to run the goal seek for the client. Had to explain what goal seek is and what it does. Years later, client calls on my personal mobile to ask for a meeting. Turns out they needed help with goal seek 😂

likefunny
Recent IconRecent

I once showed a client how to manipulate the date, then drop formula down. His response: “I feel a lot better about spending millions of dollars on you guys now"

likefunny

Vlookup is for beginners - index match is the real thing 😉

like

Would’ve thought it was sarcasm, but they then asked me to walk them through the process.

It’s the little things 😄

likefunny

Like telling a monkey he is good at juggling... Half impressed half pity

likefunny

Show how you make a pivot table 😱😱😱

like

When you do “Alt + N + V” to create a pivot table and they be like 😳😳😳😳

likehelpful

Getting others to think that you're good at Excel is 90% of being good at excel

like

@M1. I learnt it the hard way but never use pivot tables when building a model. It doesn’t let your model be dynamic and leads to a lot of mistakes in copy pasting, data scrubbing etc. I let all raw data sheets remain as separate tabs, build a Database using SumIFs and then do all analysis and modeling off of that (also using formulas, no pivots). Takes a lot of upfront investment, but pays off immensely eventually in saved time.

Of course Pivot tables are good for quick analysis and a bunch of other things.

like

Excel is for rookies

like

M2 tell us more! How to apply slide design to photo design?

likefunny

Taught a client how to design slides....used the approach yo take photos on his honeymoon and his wife was super impressed with their photos.

May have been my proudest moment.

like

I hate index match, but then I also hate that vlookup requires your reference value to be on the left hand side so...

like

Honestly, sumifs are really light on processing and file size. These aren’t vlookups or index matches

like

Pivot tables are for impressing clients on the fly.

Of course you can't use a pivot table to underpin your whole model, but good luck with sheets full of sumifs -- you'll crash excel with a reasonable number of them.

like

My client once asked my what the median formula did in excel. Then she asked me what a median was

likefunny

I don’t have a mouse and I never use one...

like

Sumifs countifs for the win! I loved using those over pivot tables too, but long ago as an associate was told pivot tables are more advanced and I should use those for more impressive models. Looks like someone steered me wrong.

like

Alt + h + b + a
Alt + h + b + t

like

Related Posts

Hi Everyone
Can someone tell me about the adobe aem developer role ? How is the project related to ot in sapient?

like

Can you share a problem that you encountered in your last research project? How did you overcome it?

like

Hope everyone is doing well. I’m a resourceful project manager moving to the Detroit area in June. If you have any leads I’d love to connect.

like

Hi all, for anyone who has experience with completely virtual shoots did you find that there was an added time or monetary component versus tradition photoshoot? I’m working on estimating a future project for my agency and curious how they compare

like

If I need to take FMLA, will project and practice view negative against me?

like

Hi all please help 2ith your valuable information

Right now I'm in Notice period(tcs)..My Client is citi..they want me to join them. My YOE 1yr 10Month and I want to switch to different technology (angular/tableau) but I don't have much knowledge and hands-on exp.. Now I already have an offer of 8lpa ..how much salary should I ask Citi as I don't want to work on the same old reporting tool developmen thing?

Also kindly tell me yearly Hike , WLB, WFH facilities about citi banks 😊

If an Amended Complaint is filed in an action in which my client is one of many defendants but there are no new or altered allegations against my client - do I need to file an answer on behalf of my client?

like

What should the compensation be for a client onboarding manager in a big financial company?

like

How do you approach collecting documents from a client in response to discovery requests? Particularly with broad and vague document requests that leave you guessing about what the other side is looking for, even after you meet and confer. I’m realizing no one ever taught me a systematic approach to this problem. And that big, name-brand companies are absolutely terrible about record-keeping or even knowing what records they have.

like

For those of you who have had to increase soft skills as a means to grow and expand client relationships, how did you go about this?

like

I was laid off during Deloitte‘s mass layoff in July of last year. I have worked as an independent contractor since and projects haven’t been consistent at the client I’m working for. I’m looking to get back into a big firm and was seeing if anyone would be able to refer me or help get my foot in the door. I was a business analyst for 1.5 years at Deloitte and have several years of additional experience which I’d be more than happy to share.

like

How is Viacom account in terms of good project and learning opportunities?
Tech stack : Java, Spring Boot, Microservice, Cloud

like

We're hiring a remote Salesforce Technical Lead! This is a hands-on developer role leading client projects. Let me know if you know anyone who might be interested!

like

How is WLB at Tech Mahindra SBI Belapur client (on site), Can anyone help me with feedback?

like

What do folks find most frustrating about patent prosecution? Drafting, OAs, client relations, other?

For me, I dislike drafting the spec to explicitly recite the basic things it does, eg, server talks to client to do <basic action>.

like

How do you deal with teammates who don't take initiative or move things forward on a project without being told to do so?

We have a deliverable due on Friday with alot of things to get done before then and seems like no one cares? I ask for status updates and all I get is no, haven't done that, will do it now. Sure enough, ask next day and the response is no, haven't done it yet.

These folks are seniors as well. Partner looks to me to provide a status update, and all I can say is in process.

like

How is citi bank project in LTI ?

Looking for HCM/Org dev positions in SF. Not currently in consulting industry but have strong business transformation project background and seeking masters in HCM/HR. Willing to chat or get any advice on how to find a good fit!

like

More Posts

Hello guys,
I am to join KGS in the cloud engg team in advisory. Can anyone please throw a light in the kind of work, work hours and and wlb for this team?
Would be really helpful

like

Is 25 mbps slow for internet?

like

Can we resign and take resignation back at the last moment in LTI ? The reason for this drama is to get a good project & good technical work. I have been made a team lead with minimal technical work and lot of reporting so want to resign and take back so that I get some good technical work .

Yoe 10.5 years
Skill : SAP basis hana

like

How did you guys prep for your GMAT?
Is a course from Princeton review / m prep worth it? If so, which company is best? Or is it best to get an individual tutor which is obviously a bit more pricey by the hour but more personalized?

like

I’m interviewing for a position that’s a 6-MONTH HOURLY CONTRACTED copywriter position (5 years experience).

Any advice on negotiating salary on that..? I have no reference point on how much that would break down hourly for 6 months.

What’s a good range to negotiate for?

like

Suggestion required MSFT vs Amazon
Role ~ TPM
YOE ~ 10

MSFT (cybersecurity team)- TC $265K
Remote/Hybrid (connected with HM and got to know about team and role, good wlb)

Amazon (Ads Marketplace) - TC $263K
NYC/ Remote ( connected with HM and got to know that wlb is good and also got to know its a high visibility role / team). HM was really king enough to connect and provide insights of his team post clearing the loop.

Need help/suggestion Amazon Microsoft

I have no problem lying to get what I want

likefunnyuplifting

Seeking advice. My company was acquired and the new CEO (white, cis gender) is a fragile misogynist. He's an old-school marketer and it's like having your dad in a meeting explaining (continued..)

Riley loves ball. Arya loves Riley 😆

Post Photo
likefunny
like

Is 200k TC a good expectation for a PGM at Google L4? Non tech PMO.

like

Even though the market has turned bearish; how many people are actively planning their legacy and what they leave their loved ones? How are you doing it today?

like

Would you still move forward with a company if they put you on the back burner and said they’d reach out if their preferred candidates don’t work out?

like

Enter puts on all the potential tiktok acquirers for sept 18. Only one of the players will win the deal, while the other three will likely drop 5-10% in stock price. One option may expire worthless, but you win on the other three. Thoughts?

likesmart

Are there any onsite or even online trainings that are relevant for Risk Assurance, Data analytics more towards Operational audits, Continuous Control Monitoring etc?

like

Friends trying to lure me into buying a 3k honma ladies graphite golf set. Ive played twice, want to pick golf long term but cant yet justify investing much upfront. Is it essential?

funny

I've been in practice for about a year at a high stakes plaintiffs litigation firm. I make $85/year, I'm in the office at 8 and leave around 5:30. I work occasionally on Saturdays. When we have something big coming up, I stay extra to get it done in time. I've never missed a deadline.

I had a meeting this week where the partners told me they questioned my commitment because they were working more hours than me.

Am I the problem here and should work more, or is it time to find a new job?

like

Can someone refer me to another company?

like

Which books would you recommend to a product counel for tech startup about strategy, management, and leadership?

like

Dealing with aging parents. What was the moment you and your siblings decided to step in and take control? What would you have done differently? More in next post.

like

Additional Posts in Consulting

Desi Consultants!! - who all are thinking of hiring Sima Taparia (after watching Indian matchmaking on Netflix) for finding your future significant other?

likefunny

Hi All - I am in the last stage of interviewing for Booz Allen. I’m an aspiring consultant transitioning from industry (healthcare). BAH told me the position itself is full time but it is “attached to a contract.” Should I be worried that I would lose the job if and when the contract ends? Would love insight from current or former BAH folks

like

has anyone here enrolled in the harvard extension school? i’d like to ask some questions if you have.

like

Is anyone willing to look at my resume to let me know if I’m qualified enough to be a consultant at Deloitte? TIA

like

What is maximum amount you can submit for cell phone bill reimbursement ?

like

Have any of you with herniated discs gone back to running without your symptoms or pain returning?

like

Best consulting firms in Houston?
Looking for new opps

like

What life experiences should I ensure I have before I start in consulting in a couple months? Travel the world? Backpack under the stars? See family a lot? What do you wish you would’ve done before starting?

like

I am fairly certain the Westin hotel staff are refilling our in-room water bottles with tap water (the safety snaps are always broken). My wife is pregnant and we don't know WTF to do?

like

Tell the truth: are you more productive at home than the office? How much more? How about your coworkers? Are they more productive in your estimation? And lastly, your whole team - is it more productive in a remote environment?

likefunnysmart

Are any top consulting firms hiring for experienced analysts currently? I know ACN and some others are cyclical for resources 2-3 years out of college, but I’m looking to make a move sooner than fall

like
like

Is it really bad if you renege an offer after you've received some of the relocation reimbursement, if you just don't pay them back, are you technically reliable? The offer is at will right.

like

Last minute getaway to San Jose Los Cabos this weekend. Staying at the Hilton resort. Suggestions of where to go and what to see? Please and thank you

like

Went on a few dates with this lady. I got a new job and it’s where this lady works. I thought we wouldn’t overlap since different department. Now having a meeting with her tomorrow 😱

funnylikesmart

Would it be too much if I asked my parents if I can get a small work desk to keep at their house while I live there? I'd be so much more productive.

likefunny

Miami fishes! If you had a choice, would you stay at the Ritz Carlton South Beach? Or at the Miami Beach Edition? And why? Thanks!

like

Comp noob here. Do all startups (Series C) offer RSU/ ESOPs? 8yoe. Will be joining as a team leader part of the growth team. If they don’t, should I ask/ insist? Anyone able to share experience?

like

Pros and Cons of Flexible/Unlimited time off policy while maintaining the utilization targets to avail leaves?

like

Looking for some material for a crash course in IT strategy consulting - books article etc. any recommendations would be appreciated

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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