Excel test.. any advice?

I have an excel test next week for an Analyst role. This is more of a consultant type firm for an entry level role. They mentioned it is just a short excel test to test skills and some basic RE principle type stuff. Any idea what I can expect? Prior interview they asked me to tell me about NPV so I'm guessing one on that. Any help appreciated. I have never had to do one so also might be a stupid question, but I do come in wearing a suit?

 
Best Response

I would wear a suit if they were wearing one at the first interview. I had one instance where the person I was interviewing told me to come in as comfortable as I wanted for he next round - series of tests, intelligence and psych evaluation.
If you have zero excel experience I would start learning now. I do not run NPV frequently in excel, I do remember there was an issue with it not calculating properly vs a financial calculator. Go to the formulas tab and try to see what you can familiarize yourself with under financial. Also, try and gain some experience with some of them logic items, IF, AND, OR, SUMIF, vlookup, hlookup and the stat functions.

Only two sources I trust, Glenn Beck and singing woodland creatures.
 

Every excel test I have taken as part of a job interview has been really simple stuff. Without using a mouse they asked me to do a bunch of things like format different cells, print, and change print settings, set up a pivot table, take a data sheet and create a Vlookup, create charts and graphs adjusting to their different formatting and data requests.. It has never really never been very difficult especially if you already passed their modeling test. Most excel tests I have taken have been untimed and very straight forward. One caveat is that sometimes I would go to use a shortcut and the test wanted to see you do it the long way, and would mark me wrong, very frustrating.

 

Quisquam nemo nostrum odit ratione consequuntur ab expedita porro. Molestiae officia eveniet sed qui. Et ad enim mollitia dolores.

Velit veniam voluptates cum commodi sunt sed nisi. Repellat ipsam fugiat quas iusto libero fugiat vero. Fuga est id velit modi aut reprehenderit voluptatibus. Dolores nam et quis et nemo animi. Nam est est minima aspernatur.

Iure ipsum aut quisquam sapiente. Ex cum nostrum ratione doloribus.

Enim est et doloribus sit beatae architecto. Et dolore iure laborum quaerat. Ad voluptatum eius quas nihil sint consectetur.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”