Related Posts
And there goes GIO's chance at the Haas F1 seat
What is the slary range for level 25?
Additional Posts in Consulting
Finally found THE one, after over a year of searching and trying out at least 5 different ones!
A nice comfortable office chair.
https://ergochair.co/collections/chairs/products/ergonomics-mesh-chair-w-adjustable-headrest-and-armrest?variant=32511617597491
My criteria: mesh seat and back, arms, headrest
I tried cheap ones from Amazon. Expensive, second hand gaming chairs. Tried HM Aeron (second hand) and while I didn't like the bulk and the general design, I was sold on the mesh seating. I wanted to get the ErgoChair 2 from autonomous, but it doesn't have mesh seat.
AMA.
any fishes in Memphis, TN ?
Hello! Anyone work at GE Healthcare?
New to Fishbowl?
unlock all discussions on Fishbowl.




One of my favorites is INDIRECT which allows you to change the cell you are referring to on the fly.
Also, not really a formula, per se, but a method for simplifying your formulas: helper columns!
Alt + F4. It solves many issues with Excel
Nested IF statements
Index match is indeed a powerful one, especially if you do a cross lookup with index match match
Solver
Also, to all the VBA gurus out there, where do I start learning it?
If I know I'm not going to insert a column, why not use vlookup?
OP, MSDN would be a good start for VBA.
Offset is the most underutilized and underrated excel function
I can’t seem to comment the link (I tried on two different devices). Just Google Power Query, it’s at the top of the list
Conditional formatting 💙
Just a tip from my side: combine filter with SUBTOTAL
GIVETO(SA1)
Oh btw, it was supposed to be "Nerd question", damn you autocorrect!
I was just being snarky, because I knew it was a typo, though I thought that it was "new" not "nerd"
P2, Haha, now I get your first comment!
Countifs 💁
Countif ftw
Most used is probably vlookup. So quick
Using - - within sum product for weighted average ifs 🤭
Are you f*cking serious...
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