Interview for an Attendance Officer

[Mercel]

I have been lucky to be offered an interview for an Attendance Officer next week. I have been told there will be a test afterwards using EXCEL. I have got some experience of using Excel but not huge amounts. Can do basics ie simple formulas, listing things etc - does anyone know what they might require me to do?

I'm only guessing from the job title but could it be that they could ask you to work out the attendance figures for the week/term/year determine the absence or persistent absence percentage? or report on attendance by year group or sex or race? good luck

Totally guessing here but if the job is about analysing data and then presenting the information to other interested parties, then they might give you a pile of data and ask you to show it in a table or in a graph to make it easier for others to understand. Functions like average, sum, count might be useful.

A bit more advanced - if you have loads of data with column headings, pivot tables in Excel can be handy to make life quicker as you can pick and choose what data you want to display and add/remove totals and subtotals. Pivot tables will be new to most people though so don't worry if that is a step too far as they take a bit of getting used to.

I would focus on being able to do basic functions and tables and different graphs eg line graphs, pie charts, etc. to start with. You can always say that you understand that there is more advanced functionality within Excel that you are not as familiar with but are willing to learn.

I'm not familiar with the role so am guessing here. Hopefully someone who knows more will be along to help :)