Related Posts
Hello,
I had my interview with Infosys for .net full stack developer.
It went well and i am hoping for a positive response.
Want to know how much should I expect Or at what pkg should I negotiate with them.
I am thinking of proposing 13-15 LPA negotiable.
4 YOE and 7 LPA currently
.Net full stack
Infosys
More Posts
Are you not entertained?

Additional Posts in Excel Genius
Everyone: Excel is a smart app
Excel:

Would anyone be willing to teach me vlookup?
New to Fishbowl?
unlock all discussions on Fishbowl.





Date related formulas, such as networkdays(). Powerquery is also helpful dealing with repetitive queries from sheets that require formatting and calculations upstream. Knowing shortcuts is also a plus to showcase your efficiency
ISNUMBER(MATCH()) is one of my most commonly used functions. It finds if element in x is present in y.
I use IFNA a lot so that when something doesn’t pull it doesn’t break my model altogether. I create links in my models to take me to other places in the workbook - sort of like a table of contents. I use the filter function in combination with the unique function to pull out actively owned symbols from a journal of entries (don’t know if that is common or not). I’ve used RRI but not a lot - mostly Pivots, sums, sumifs, lookups cover most of what I do
SUMPRODUCT is super handy at the right time, it does a lot more than the basic use case
Didn't the FILTER function make that redundant? I personally don't like SUMPRODUCT because it is vulnerable to errors in any of the arrays referenced. In other words, it breaks far too easily.