Invited to Teams Video call with intended line manager, preceded by a Excel test which needed to be submitted prior to interview. Had mitigating circumstances so was allowed to submit test later in the day. Interview went very well, questions were relatively simple. Excel test consists of 3 sets of questions, with data held on a separate tab in the worksheet. Need to utilise IFS Statement, pivot, VLOOKUP and text to column, nothing too demanding. Interviewer said I was a very strong applicant and liked me very much, however received notice a week later my application was not successful and received no further feedback despite emailing their HR department for my own profession development.

The process was fairly unstructured, it didn't seem interviewer was prepared for it. They tried to get the feel of the attitude and not so much of technical information and achievements to date or examples of specific cases.