Excel Test - PWC 
(Baboon, 105
Points)
on 2/22/12 at 7:25am
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
Take wallstreetprep's Excel crash course online, its $40, really good.
just did it, its trivial,
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
I don't know about PWC, but
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.
"It is hard to fail, but it is worse never to have tried to succeed."
Theodore Roosevelt
www.breakingintowallstreet.co
www.breakingintowallstreet.com has an awesome and pretty comprehensive excel course
Good is the enemy of Great
PWC, what position in PWC
PwC, what position in PwC doode?
spaceagecowboy wrote: PWC,
PwC, what position in PwC doode?
Forensic Services analyst
Something Creative wrote: I
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.
breakingintowallstreet.com -
breakingintowallstreet.com - take the Excellence with Excel module. More than enough to get you through this.
"It behooves every man to remember that the work of a critic is of altogether secondary importance, and that, in the end, progress is accomplished by the man who does things." - Uncle Teddy.
BoxerRebeller
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.easyexceltutorial.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.
"It is hard to fail, but it is worse never to have tried to succeed."
Theodore Roosevelt