Excel Test - PWC
I have an interview coming up, which includes a 15 minute Excel test. I am told that if I dont pass the excel test, there will be no interview. Now, I am OK on Excel but I'm not feeling too great about the interview.
Anyone have any tips on how to improve on Excel? Or what consists of these interviews and tests? Anyone done any?
Would really appreciate the help.
Take WallstreetPrep's Excel crash course online, its $40, really good.
just did it, its trivial,
data entry, focussing on accuracy, formatting cells (2dp, bold, borders), making a graph from a table, sum formulae, saving (yes, seriously), and if/else/then/while loops in vba.
Interview is tell me about a time when questions, typically around teams and managers, so when you disagreed with someone, when you had to lead someone, had to get a job done with the scope unclear, when you made a mistake, what would you do differently.
gl
Hi there,
I had an Associate asset management interview today and aced it but after I had to do a quick excel test/basic data formula's/manipulation for 15mins, I unfortunately got way too nervous and only completed half of it and just froze, as I did really well on the interview, would they pass me regardless? OR would they pass me and weigh the interview more than the test result? Or would they need a certain benchmark result for the test in order to pass me/even consider the interview?
Also, should I ask them if I can re-do it or shall I wait for them to come back to me and see what they say?
Please let me know your thoughts below.
Thanks
I don't know about PWC, but any excel test I've ever seen has to do with hlookup, vlookup, pivot tables, sumif, if, and formatting.
Where would you recommend to brush up on shit like that? Like on the internet. I've had a look in my local bookshop and there isnt a whole lot there.
I just did a search for excel tutorial and this popped up and seems like it's free.
http://www.excel-easy.com/
That's going to cover a lot of basic stuff. I think the best way to learn is to get the basics down from something like the above, and then play with stuff in excel to try and get down what different formulas are doing, how to create tables, etc. Anytime you have an actual issue you can't figure out, check out a forum like mr.excel.com or something and there is likely a topic there that is applicable to your question (or post one). That really helped me learn a lot of vba coding.
I don't know about the guides being mentioned as I've never used them, but I'm sure they would do a good job as well.
Hi there,
I had an Associate asset management interview today and aced it but after I had to do a quick excel test/basic data formula's/manipulation for 15mins, I unfortunately got way too nervous and only completed half of it and just froze, as I did really well on the interview, would they pass me regardless? OR would they pass me and weigh the interview more than the test result? Or would they need a certain benchmark result for the test in order to pass me/even consider the interview?
Also, should I ask them if I can re-do it or shall I wait for them to come back to me and see what they say?
Please let me know your thoughts below.
Thanks
Curious as to where this was at? Thanks.
Hi there,
I had an Associate asset management interview today and aced it but after I had to do a quick excel test/basic data formula's/manipulation for 15mins, I unfortunately got way too nervous and only completed half of it and just froze, as I did really well on the interview, would they pass me regardless? OR would they pass me and weigh the interview more than the test result? Or would they need a certain benchmark result for the test in order to pass me/even consider the interview?
Also, should I ask them if I can re-do it or shall I wait for them to come back to me and see what they say?
Please let me know your thoughts below.
Thanks
PWC, what position in PWC doode?
Quae ut ut ut atque quia nemo dolores distinctio. Placeat veniam et assumenda incidunt.
Sint quibusdam sequi architecto et iste praesentium et. Fuga quasi possimus illum quae culpa modi facilis. Dolores dolore vero rerum illum deleniti dolorum qui.
Distinctio perspiciatis impedit vitae sit cum perferendis. Est animi qui accusantium consequatur. Asperiores qui modi esse dolorem sapiente consequatur culpa. Consequatur in ut atque voluptatum modi repudiandae. Qui omnis corporis temporibus deserunt est expedita.
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...