Related Posts
Additional Posts in Consulting
Good one Booz....
Got a random email from a supposed Amazon recruiter for a SDE position (which is not at all a fit). The email is amazon.com domain and there are no red flags in the body but it doesn't feel like an Amazon recruiter due to the tacky signature, etc. Has anyone seen this kind of cold-calling from FAANG recruiter?
Best place to buy an iPhone 7 and not pay 1K?
New to Fishbowl?
unlock all discussions on Fishbowl.




How sad is it that Excel is 30 years old and is still used as a core consulting tool.
That’s like... 3x older than the first iPhone (for scale for anyone younger than Excel).
And may gawd have mercy on our souls
https://en.m.wikipedia.org/wiki/Microsoft_Excel
Alt + F4. It solves many issues with Excel
Index/match or offset
Index match > vlookup and hlookup
Vlookup!
=INTERCOURSE(ME + YOURDAD)
IFERROR ❤️
Experts Share Their 10 Favorite Excel Functions
https://www.vertex42.com/blog/help/excel-help/favorite-excel-functions.html
Why would anyone ever use Vlookup over Index match????
S&1:
VLOOKUP(A2,B3:C7,2,0)
INDEX(C3:C7,MATCH(A2,B3:B7,0))
Which one looks shorter to you?
A3, yeah, but imagine if you need to insert a column between column 1 and 2, then vlookup goes haywire, while index match stays intact. Clearly, you know how to use both, so I assume you're aware of all pros of index match over vlookup... Still a puzzle to me though, why would anyone use vlookup over index match?
You need to better distinguish between needs and wants. You may want a favorite Excel formula, but you don't really need one.
Index match is dope
Index match is more efficient from a cpu processing standpoint as well. Will be faster with large datasets
Indirect (shout out to all my modelers out there)
SUM
Waiting patiently for concatif to become a real formula...
Don't learn VBA in 2017 please. Learn python.
=‘tab name’!<cell letter><cell number>
Saves so much time 😍
And the text function bundle deserve a shout out for when you have to clean and sort badly broken down data 🙏
It’s an add-on rather than a function but shout out to Power Query. Combines well with PivotTables for aggregations on clunky CSVs