• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need a Interview questions workbook

Ehtisham Ali

Ehtisham Ali

Member
Hello Everyone,

I need to interview candidates on regular basis for their basic and some advanced Excel skills.

I need to test below mentioned skills.

VLOOKUP,SUMIF,SUMIFS,HLOOKUP,COUNTIF,COUNTIFS,PIVOT,GRAPHS,SUM,CONCATENATES,DATE AND TIME CALCULATIONS etc.

I want a 10-15 tricky questions test for about 30 mins.

Candidates hired will be responsible for below mentioned tasks.
Daily reporting in a telecom sector containing large data, monthly dashboard modifications containing complex formulas. performing ad-hoc requirements using excel.

Please help.
 
Bear in mind that there are many ways to answer real world questions in Excel. I would design a test around that fact. I'd give them some data, and ask them to summarize it to show a particular view. Then I'd see what they did to get there.

Maybe they don't need to know so much about SUMPRODUCT if for instance they can use a PivotTable to come up with the same answer. (And in fact I'd probably favor use of the PivotTable over SUMPRODUCT).

I'd also ask them how they would overcome some tricky problem they couldn't immediately solve. See if any of them mentions help forums like this one. Maybe ask them what online resources they refer to apart from Google when trying to answer a tricky Excel problem, and see what they say.

Also, I would encourage people to bring anything they can to support their claim that they have 'advanced excel' to the interview. When I go for a job interview, I take screenshots of a whole stack of things I've built over the years.

Lastly, I'm in favor of open tests. Let them use Google when doing the test. Because in the real world, you WANT them to use Google if they are stuck, rather than spending precious company resources reinventing the wheel.
 
You must log in or register to reply here.
Back
Top