{ "media_type": "text", "post_content": "What are your favorite or most used excel formulas/functions?", "post_id": "562e5c8dcdbb590300eac55c", "reply_count": 15, "vote_count": 3, "bowl_id": "552d1d24dc1c586b09d2d051", "bowl_name": "Consulting", "feed_type": "crowd" }
null

What are your favorite or most used excel formulas/functions?

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

One should NEVER use vlookup! Too much space, columns are not reliable!!! A proper model should just have index/match!

like

Everything in excel can be done with four formulas: index, match, offset and sumproduct. First and most important thing any analyst should know

like

@bain: agree. Vlookup and pivot tables scream "rookie" and "pmo template jockey" to me

like

Couldn't live without vlookup and once in a while its sister hlookup

like

@chicago 😂😂😂

like

Offsets can save you a HUGE amount of work (if you know how to use them)

like

1) CNTRL and ~ (view formulas)
2) ALT and F4 (repeat last action)

like

Sum

like

Exactly. 1st year analysts do Vlookups. Index and Match is a more proper algorithm. I&M also requires less computing power, making your model lighter.

like

Either vlookup/fuzzylookup or if

Vlookup!

Ctrl+space; shift+space; Ctrl+ -, basically anything ctrl

=Randbetween and vlookup when creating dummydata

Index Match > vlookup Errday

Why would I want to use offset ? I almost never need it. Always used index match

Additional Posts

Would anyone be willing to refer to EY/Deloitte/KPMG FDD?

like

ACN Strategy to McKinsey direct-elect partner - pros, cons? I am told the expectations and culture is so different, it’s not worth the move, even for a bit more comp. Any insight from those that made the move?

like

Just heard IBM has halted their hiring process for at least 2 months! @ibm

like

Has anyone bought and rented out property in the DC area? Any idea on how long it usually takes to find tenants? I'm considering purchasing a house.

like

Why aren’t any of us doing anything about the recent shooting? We are the industry that makes voices. Where is our voice?

like

Prepping for a one-man project. Any tips, tricks, advice?

Kinda scared 😬

like

What do you do when they offer you a range, and you don’t want to seem like a money grubber and of course want the highest part of that range?

Should I wait for the HR person to tell me the offer, and then decide? Because I would be happy anywhere in that range...

like

Hip Hop 101: How To Reach and Teach Today’s Hip Hop Generation... by The Empowerment Perspective Group. Stay Empowered!

Post Photo
likeuplifting

Had a full on hormonal-induced breakdown earlier tonight. I know the underlying issue is the combination of: running my own household (taking care of myself, apartment, and my two adorable turtles), working full-time+ in big law, and studying for the UBE when not doing any of the above. Just feeling overwhelmed right now and would greatly appreciate any words of advice and/or encouragement. Thank you all :))

like

Anyone else exhausted from the dating apps? I feel like I’m never going to find my person. But I’m 27 and haven’t really had a serious relationship so I feel like I’m running out of time.

likehelpful

Was just hired by one of the Big4 and am currently going through a background check. I sell clothes online as a hobby (4 hours a week outside of working hours), but it is filed under a LLC in my name. Do I need to disclose this to the firm? I don’t want them to worry about it. Also I have never worked during business hours. In my opinion, selling clothes is not a form of outside employment… it is a hobby. Do I still need to disclose this?

like

Hey! Anyone interested in purchasing a SXSW Film badge at the early bird special cost of $895?

like

Any Facebook 🐟 in Corporate FP&A willing to chat about their experience? Saw a post that may be interesting and wanted to understand the day to day a little better.

like

Hi moms! My friend is traveling to Cabo solo with her baby (she is meeting her husband, who is already there), does she *really* need a notarized letter from the father? She'll have baby's passport + birth certificate, but may not have time to get the letter before her flight.

like

Which is better ABB India or KPMG Global services?
YOE:7.10
Tech stack: .net full stack
CTC: ABB- 23+3.4
KPMG- 24+ VP(nothing mentioned in offer letter though)
Any suggestions? Which one should I go for and why?

like

Anybody aware of something changing at Merrill? We have a meeting next week that’s mandatory and not clear on subject matter. So typical A type FA, I assume it’s a comp change. Anyone know anything?

like

Hey Googlers, I have an upcoming interview for BA, with HM. Already, cleared 1st one with Recruiter. Any tips, resources or suggestions or help would be appreciated. Role is within Ops.

P.S: I asked for Level didn’t get a answer.

Already reviewing videos from Jeff Sipe, some docs from recruiter and online search.

LOE: 5

like

What’s Horizon like these days? How is work life balance?

like

When's the Falcon's parade? And who's cancelling travel besides me?

like

Anyone have experience working with an Edward Jones financial advisor? Recently married with first kid and looking for more hands on, holistic investment guidance given new goals. Cont:

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

For account settings, visit Fishbowl on Desktop Browser or

General

Legal