Excel test ("30 mins max") included in final interview

Hi,

Upcoming Monday I will have my second and last interview at a large real estate company. The job title describes the job as a Junior Treasury Analyst, but it basically comes down to the following:

  • contact with banks for communication regarding various topics, such as covenants
  • cash management and analysis
  • reporting
  • making and checking payments

I had an interview this week with two different members of the team and now I am the last candidate. However, this Monday I will have a phone call with their overseas headquarters (in the US, I'm from Europe) and I have been told it will include an Excel test beforehand as well. The recruiter, who is not part of the company but obviously has a lot of contact with them, told me it should not be too heavy and that it is more focused on looking how I work with data. However, I definitely don't want to underestimate this test and therefore I want to practise for this as much as possible in the coming few days. I have taken all Beginner and Immediate lessons at Excel Exposure, which offers great free lessons.

This includes pivot tables and some formulas such as VLOOKUP, but I was wondering whether you guys could recommend me other things I should practice. There's not going to be macros or VBA or anything like that, but I think that in a junior treasury function within a competitive S&P500 company they have some level of expectations. Any tips would be much appreciated. Maybe some free/cheap exams that require you to make use of pivot tables and such intermediate formulas, so that I can practise using them.

Kind regards,

Jeffrey Bloemen

 

Maxime modi nisi modi voluptatibus quam. Architecto optio qui non. Blanditiis et pariatur culpa commodi repellat aut dolorem sed.

Nihil commodi sit culpa cupiditate. Doloribus dolorem deleniti sint delectus animi. Minima qui aut doloremque explicabo voluptatem dolor. Quis eaque sed placeat libero nisi. Tenetur ut non nulla repellendus placeat possimus nesciunt ipsum. Omnis placeat aut laborum eos harum omnis dolores. Et incidunt blanditiis nostrum soluta repellat.

Sunt et et ullam necessitatibus dolor ut. Quae assumenda laborum rerum architecto quod ullam. Sit id voluptatibus dolore voluptatem at nobis ad. Libero cumque explicabo est laborum error rerum nihil. Voluptatem earum reiciendis quasi ullam aspernatur. Qui autem perspiciatis maiores occaecati et corporis praesentium.

Career Advancement Opportunities

April 2024 Investment Banking

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

Overall Employee Satisfaction

April 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

April 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

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
98.8
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...”