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
- 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 antest 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 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.
Consulting Case Interview Course
- 2,037 questions across 209 consulting firms. Crowdsourced from over 600,000 members.
- 11 Detailed Exclusive Cases developed by a McKinsey Associate and 10+ hours of video.
- Trusted by over 1,000 aspiring consultants just like you.