Excel Functions to Analyze Data
Recruiting right now but haven’t worked in a while. What are some of the must know functions/formulas yall use in excel to cut up information to analyze/present in decks/perform diligence on? Other than lookups or pivot tables
That's about it. Most databooks are just re-organizing data through look-ups/SUMIFS and/or creating charts and pivot tables.
Thank you! This will help me structure my answer better in interviews.
Sorry maybe I’m being dense but I’m not understanding how large would be helpful if you have a bunch of customer data for example?
Is it like sumif based on customer id —> roll up thousands of data entries into customer profiles —> rank customer —> % share of revenue gives you a “concentration”?
Yeah exactly, pretty commonly you might get a monthly revenue by customer file with one row per customer but the source data not sorted high-to-low. You can use the large function across a particular month (or annualized month of data) to pull the #1 largest account, next largest, etc. to assess concentration with top 1, 5, 10, etc.
IndexMatch, IF combined with AND / OR
Voluptatem quasi quo modi ut eum sapiente. Ut est sit qui quia eos aut saepe. Sit et voluptate molestiae nihil voluptas ducimus.
Aut quia provident qui sit ut consequatur exercitationem eaque. Harum ea aut voluptatem et et pariatur. Distinctio aliquam dolorem vel voluptate. Totam in autem possimus omnis veritatis. Magnam est consequatur ipsum delectus. Deserunt reprehenderit deleniti quo recusandae dolores ut id quaerat.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...