Typical behavioral questions such as tell me about yourself, "tell me a time when you..." questions regarding teamwork, time management, etc. Excel assessment tested basic excel skills such as vlookup, concatenate, basic formula syntax - you are given an excel file that has mock data tables and have room for you to fill in answers by populating formulas or editing formulas. The case study was a walkthrough of a process done at Yext. Then you are given an example of a client and problem and questions to answer that you will explain to the client as a presentation. Doesn't matter the format of the presentation as long as you mention all the answers to the questions given. You get to present that twice, and afterwards are two rounds of behaviorals with different people at the firm.
