Related Posts
Hi fishies, welcome to the OHG bowl!
When is external hire IBD recruiting season?
Hello
I am Vinay and currently working in Kyndryl-IBM. My company has so many openings and I would be happy to refer you all. Just provide your email-id and the role you wish to apply for.
If you're looking for a change please contact me.
LinkedIn: https://www.linkedin.com/in/vinay-kumar-384281151/
Phone No: +91-9030866812
Email: vinaykumar818486@gmail.com
If you need further help please feel free to contact me
I'm available for all your job-related needs and don't hesitate to reach out.
Just got US citizenship! Can't wait to vote :)
Additional Posts in Consulting
What’s your long term career goal?
Ta ta towel?
Houston downtown JW vs Westin.. Thoughts?
New to Fishbowl?
unlock all discussions on Fishbowl.




Index/match
And Index/Match/Match
Force Quit / End Task for when it freezes
F4
Ctrl-s to quick save
The email of an associate to tell them to do it :)
Index, match, sumifs, countifs, maxifs, minifs, averageifs, if, isna, concat, trim... Pivot tables are also useful for aggregating data but my team doesn't like them. 😔
Knowing the hot keys for filter, remove duplicates, paste as values, insertion/deletion of columns, etc. are also useful, but you can get by without them.
They fear what they do not understand. 😔😔😔😔😔
Alt + F4
F9 to show calculated values inside formulas; ctrl+[ to trace depends and F5 enter to get back to original cell
=Google
Paste special
Alt =
Ctrl + C; Ctrl + V
I’ve become a huge convert to powerquery since PwC has been force feeding us. It truly is a game changer
Alt + H, V, V - paste as values
Alt E+S+(whatever you like) is incredible
Sumproduct() and double unary, you plebeians