Barclays interview questions

Note that the interview I attended is part of the graduate program - might vary for line hires. Interview process consisted of 3 main parts: Phone interview (2 weeks after online application submission) - Usual HR questions; why do you want to work for investment banking, why Barclays, tell me about your resume, and stuff like that. Excel Skills-based Test (approximately 1 week after phone interview) - Test of basic excel skills and some VBA; stuff like vlookup/arrays for excel and some simple stuff you can do with the macro recorder in VBA. Assessment Centre (same week, after Excel Test) - Consisted of 1:1 competency based interview with line manager, prioritization exercise (give order of priorities on several selected tasks, explain and interact with the other people at the AC), and case study presentation (also 1:1). Line manager called on same day in the evening, offer was in the mail the next business day. Relatively smooth process - Managers and staff seem relatively nice; HR was mostly prompt and responsive.