What are complex excel formulas/functions I can brush up on for a technical interview?

Thinking IF statements, pivot tables, SUMIFS, etc.

likefunny
Posting as :
works at
You are currently posting as works at

And people say genai is no threat to consultants

likefunny

Unless you’re fresh out of college these really aren’t the “technical”questions I’d expect unless recruiter gave the guidance

like

I’d say what you listed is call basic excel formulas tbh. I would think more along the lines of building out financial models

like

Those aren’t complex.

Get Balck-Scholes in a single cell and come back when you’re ready to review.

funnylike

Never seen it done

Anecdotal but I use a lot of countif, xlookup, pivot tables. Try using chatgpt to practice some vba.

like

OP, your list + EY1 should be good to go.
I wouldn't get caught up in vba unless it was specifically mentioned, though.

like

Sumproducts, calculated fields in pivot tables, vba, index/match, nested if statements

like

Sumproduct plus a few of the new O365 dynamic functions like unique are all you ever really need.

like

Index match combos

like

Sometimes yes, sometimes no, index march can be written to do more flexible things than XLOOKUP

like

Array formulas

like

Index match, pivot charts, multiple datasets

like

Solver

Conditional formatting

XLOOKUP, bro.

TODAY(), bro.

Related Posts

What sites do you use to apply to jobs? (like LinkedIn, Hiperpool, etc.)

like

Interviewing for RSM due diligence manager, i am trying to understand the salary range, bench time and work life balance

like

Most common behavioral questions for a hiring manager phone screen? (Tech company)

like

Hi Fishes,
Need suggestions on informatica interview.
What type of questions panel ask?
Anyone gave interview recently?

like

From where do the EY HRs procure the resumes?

like

I am currently an EH&S/AP associate for Walmart Supple Chain. I am a team lead in the department making $31.35 an hour working Fri-Sun from 5:30-17:30 (12hr). I am interviewing for EH&S/AP manager and I am searching for how much the managers are making on here but I can’t find any post about it. If I get an offer for the manager position, how much should I ask for my salary? Please let me know how much you are making as an EHS manager and please include your company as well.

Interviewing to crossover from plaintiff to defense work, wondering what a competitive salary offer would be from a firm in the V20-30 range, 5th year, antitrust practice. NY/DC scale. Thanks in advance

like

Panel presentation interview at ZS Associates .

Can anyone share their experiences, tips, anything? Thank you so much!


ZS Associates

like

Is dsa important for technical interview for 2-3 YOE?

Hello Guys, Its been more than a week, I accepted the salary breakup and Status changed to Evaluated in ibegin. I have not heard anything from Hr, she is not replying to any emails.

Till when I can get the offer letter?,Is there any chance I will not receive?

Non-eng... Got past the hiring committee! 🥳 does anyone know the process from now? And how long it typically takes? Thanks !

like

Is anyone here working in Whatfix or have given interview for this company?

like

After 3 rounds of Apple interviews, recruiter has requested a call. Do we think it’s more likely a rejection or an offer?

like

Etiquette question: how do I ask an alum PPED I’m hopping on a phone call with for a referral? (or do I not?) Thanks!

like

I JUST LANDED A PHONE INTERVIEW WITH GOOGLE!!! can I get some google phone interview tips, advice, etc.? (Forever grateful) 🙏🏾

like

I’m looking to transition from an academic medical center to pharma or a biotech. I have about 8 years of clinical research experience overall — 7 years combined as a CRC (CRC I, CRC II, and senior CRC) and 1 year as a PM. I’m also recently ACRP-CP certified.

I’ve worked with many different industry-sponsors and CROs throughout the years, but many jobs I am applying to require experience at a biotech/CRO/pharma company. Would really appreciate any advice or referrals. Thanks in advance!

like

Hi fishes,
I had interviewed for Cognizant and I was asked to submit my documents for offer letter release. This happened on the same day as my interview(Friday 6th May). I submitted my documents and I am trying to contact the HR who scheduled my interview, but she is not picking up my call. My question is how soon can I expect the offer letter to be released? And is there a possibility that they can reject my profile at this stage?

like

Can someone shed some light on the interview statuses of the candidate portal of Walmart ? My status is currently showing as "Interview 3 - Interview scheduled" and Activity shows "Interview confirmed - debrief" as Last activity. What should I make of this ?

like

Didn't have top grades, wasn't on law review. Worked at a midsize firm and was laid off in march-- have about 3 years experience in a hot practice area. Have been applying and had some interviews at larger shops but nothing has come of it. I'm still applying to roles (not many out there) in my area but coming to the realization based on number of larger firm rejection letter that I may not find a role. Where would you go from here if you were me? Was making good money at the midsize...

like

Has anyone had a client they works with TigerConnect? I was recently approached for an interview but can’t find much information about them.

like

More Posts

I am on a project with some one who went to Wharton and I used to hold Wharton in such high esteem and he is just so bad at his job.
His entire shtick is that I make slides, he forwards, then gets feedback and then forwards me that feedback.
Like bro how about you think through the takeaways for once. It’s like seeing my idols fall

funnylike

Hi Fishes,

Looking for a Business Analyst (Presales Consulting) role with 3.5 years of experience. Please let me know if you are aware of any such opportunities.

like

Hi, I am looking for opportunities.

Experience
4 years
ZS Associates left
1 year DRG.
Market Research primary, secondary quantitative, qualitative

If anyone has leads let me know

like

Let’s say you’re the main character of some action movie. Think military / Jason Bourne / Ethan Hunt type of guy. You’re only bringing one watch with you on your mission across the world. Streets of Paris, African jungles, Southeast Asia, and wherever else the mission takes you. What watch you wearing?

like

Question from a newbie consultant - What are some good online courses/ books to improve consulting skills?

like

I am holding two offers,

1. Tiger Analytics for Senior DE role, WFH.
2. Fractal for DE role, 6 weeks DE Training later project, WFH.

Finding both companies similar in terms of project. Please help pick one.
Looking for better hikes while working.

like

My joining date is on second week of Oct with Tiger Analytics. I have seen few posts that they are postponing joining dates. I am planning to join Tiger. Will there be any issue further. Yoe:3.5 yrs

like

I have joining in Tiger as Data Engineer next month in AwS, I have heard that they put in training for two months and ask to take some certification, can someone please provide info what kind of test or certification is expected....?? Has anyone given such test??

YoEx - 6
Tech - Bigdata

Is there any strong Marketing Department in Cognizant where Marketing Functional Roles (Brand Management/ Brand Development/Marketing/PPT Developments etc) is put to use? And if so, how can one channelise into the same.
Thanks

like
like

What’s the parental leave policy at your firm? Maternity vs paternity? Is two weeks paternity leave pretty standard?

My boss fired me because i ask for clarification on my employment right.

I got hired not long ago. I realise some of the employee benefits i was told (missing in the contract) contradict with what’s stated on the law. So i email the boss about it and ask for clarification. Immediately after the email i was fired.

Just want to make sure people know this and don’t apply jobs in this shady company- it is called UniQ Biotech, in Delta, BC, Canada

Post Photo
like

Hi guys, it's been 4 weeks since i joined GDS , I was assigned a POC task, in which I worked for a few days but now its on hold.

Could someone help me know what's avg bench time or how to get projects here, who should I contact(other then counsellor) or if there's any internal portal to apply for open positions in a project?

Thanks

like

My H1B extension was approved last week! Just want to throw out some positive vibes for everyone who’s still waiting on decision, and good luck!!!

like

Best resume templates? My old one looks stale...

like

Is Infosys has some policy of 70% in 12th and graduation for experiance candidate also?

like

Friday naps are elite

like

28 LPA (25L fixed + 3L variable) in Tech Mahindra or 30 LPA (all fixed) Mindtree for a Data Scientist with 8 years of IT exp and relevant exp of 5 yeras. Which one is better to accept ?

like

My motto is if it makes the sale go faster, I’ll stage it using my home décor skills. In return this means $$$$ in my pocket and referrals.

like

I’m so happy, after 2.5 years, I finally received offers to break into a CRE😀 One role is CMBS - Capital Markets Analyst and the other is an acquisition/ development analyst type of role. Both forms offered $70k base. What’s the best way to negotiate to $77k+?

likesmart

Additional Posts in Consulting

like

So how does priority baggage claim work? I just waited for half an hour at the carousel and someone walked up and handed my baggage to me. Was I supposed t omelet her somewhere? This is American

like

Best consulting firms (including boutiques) if you want to do product design/development

like
like

Did anyone read the top consulting firms to work for? 😂😂😂

like

In your experience, is "Going above and beyond" rewarded by your company? Or is it taken for granted?

likefunny

Folks who were weak in GMAT quant but strong in verbal: did you find that taking the GRE was a lot better for you and worth it?

like

What are some of the must read books in Management Consulting?

likefunny

Best consulting firms without the massive ego?

like

Can anyone refer me to the Amex Delta Platinum? Thanks!

like

My fellow South Africans impacted by what’s going on, my prayers are with you!

like

Which consulting firms are hiring for experienced Associate position? Have a friend who got laid off and looking for another job.

like

90% utilization, great snapshots BUT no relationships with the partners in my practice + currently on beach. Everyone I've worked with is shocked. Was told there were HC quotas. Not meritocratic.

like

Can you share your meeting preparation process or tips with me? Recently promoted to SC and finding that I need to really plan out meetings more than I did as a C. Thanks!

like

Since the firm has clearly abandoned the practice of matching its peers (e.g., BCG/Bain) in terms of benefits, would love to hear some of the benefits provided by our new peers (Big4)? ....

like

Hi all,
I was made aware that I could work for consulting companies under a personal LLC and increase the pay received. My understanding is this is because I would have to pay my own insurance, benefits etc. Can anyone provide any additional details or literature on this?

like

This is the second Four Points I've stayed in that has "Never Gonna Give You Up" on the lobby music playlist #rickrolledagain

like

BlackLine Anyone work at Blackline that can speak to their projects/wlb/remote positions?

like

So the “new way of working” is to actually read the online reviews and not ignore them? Genius

Post Photo
funnylike

Any book recommendations for the summer vacation season? What's your favorite book over the last year?

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