How Do I Study for Finance Excel Tests?
I have been on several finance interviews where I have been given excel tests. Sadly, i havent done well on them. But I know excel, just not in the way these companies expect. Just to let you know, the test doesnt ask to calculate present value or bonds, for instance. Rather, they ask for example, of converting 5020360 into $50.2M. Another example is, rounding 1.367 to the nearest .5. They also ask about vlookups and pivot tables.
Whats the best ways to study for these types of questions on an excel test?
You can really learn about formatting, formulas and pivot tables (basic excel skills) just using google..
The best thing is to take up mock up or assessment tests at online to excel in your finance tests.
Google is your best friend.
I also found it really useful when I downloaded practice exams off the net and practiced it by myself. Try using this http://www.excelfunctions.net and http://www.gcflearnfree.org/excelformulas/practice-reading-formulas/1/
They are both really useful and helped me a great deal.
In short, just keep practicing and it will be second nature to you in no time!
Learn how do it and then practice.
Hic praesentium labore aperiam ipsam. Dolore alias odit culpa ea quis ea. Repudiandae temporibus sint consequatur hic sed ut.
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...