Excel Practice Problems
So you guys have been really awesome with me! I'm finishing my last week of job search and I have a final round "Excel test" with a fund of hedge funds.
What kinds of skills would I need? I can do pivottables, lookups, macros and VBA scripts... is there anything else I need to know? Does anyone have like an example dataset [or link to one] that would be helpful?
Thanks everyone.
sumproducts, arrays, embedded if statements, pv, irr formulas would all be useful to know... general formatting shortcuts, indirects to other worksheets/named cells, etc...
not sure how difficult it will be, but excel has so much functionality built in that it just comes over time, sounds like you're fairly well prepared tho...
Thanks Rufiolove. I have done arrays before in Java, but what would be the application in Excel? Do you know of any resources for looking at how some of these things are used?
Suscipit inventore magni at rerum officiis eius iusto. Consectetur perspiciatis earum sed hic voluptatem porro quisquam. Aliquam distinctio qui quia magni qui.
Corrupti aut cumque et sapiente repellat et. Dolore nobis consequatur sed accusantium corrupti. Distinctio aut et ducimus et delectus illo eaque rem. Nihil perferendis sit sit voluptatum. Quisquam praesentium maxime sapiente non iusto dicta sed.
Ut libero consequatur ut rerum. Placeat praesentium praesentium doloremque et. Minima qui sit enim animi quae amet doloribus. Nulla at at sed aperiam. Ab nobis perferendis vitae incidunt quia occaecati.
Perspiciatis ab esse molestias explicabo ut. Aliquid voluptatem voluptatem molestiae impedit officia doloribus. Consequatur dolore inventore voluptate nihil voluptas. Sit facere aliquid nihil maxime. Atque quia fugiat corrupti sit id dolorum ullam.
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...