Related Posts
More Posts
When the partner checks in on the junior associate

Hi,
Is anyone facing same situation?

Most obscure game you’ve played?
How are these? Mens Suede Black from Todd’s

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

Anyone have a good source to learn sql
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.




Index match
Use sumifs and countifs even when you have a single variable so whenever you have several you are used to the syntax
Agreed with this. Additionally, sometimes your analysis changes. Having to move the parameters around becomes burdensome
Not in finance but sumif, countif is always useful
Xlookup, index match, sumifs, aggregate, table nomenclature, and charts. If you really want to impress learn spill arrays and lambda functions.
Not all Excel users have Lambda yet. Would add Correl and Forecast to that list for an FPA role.
Bowl Leader
Agreed with the above functions mentioned. Sumifs will be your best friend in what sounds like cash flow forecasting models. Brush up on using DPO/DSO to forecast operating disbursements/receipts. If you really wanna knock it out of the park, read up on how you’d forecast differently when paying vendors via check vs wire (checks take time to clear and cash doesn’t leave bank until vendor decides to cash it)