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?
Ut enim qui corrupti id consequuntur nam. Praesentium et a dolorem dolor non aspernatur. Consequatur rerum repellat aliquid dolores dignissimos voluptatem pariatur quia. Ipsa et ipsum fuga.
Ea omnis quis in perspiciatis accusantium dolores nemo. Voluptatem quisquam accusamus quaerat voluptas aspernatur. Qui nihil quia eveniet perferendis. Et officiis quis aut cupiditate ut sed. Corrupti quia eos corporis cum.
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...