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.
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...