Thread List
First Page Previous Page Page 82 / 305 Next Page Last Page
Subject#Latest
3 18.07.11
6 18.07.11
7 18.07.11
2 17.07.11
1 16.07.11
5 16.07.11
5 14.07.11
6 14.07.11
7 14.07.11
2 14.07.11
3 13.07.11
2 13.07.11
1 13.07.11
1 13.07.11
5 12.07.11
1 12.07.11
5 11.07.11
2 08.07.11
3 08.07.11
2 08.07.11
7 08.07.11
3 07.07.11
2 07.07.11
2 07.07.11
5 06.07.11
2 04.07.11
2 04.07.11
11 04.07.11
3 04.07.11
4 02.07.11
5 01.07.11
1 01.07.11
1 30.06.11
1 30.06.11
1 30.06.11
6 30.06.11
2 29.06.11
3 29.06.11
3 29.06.11
14 29.06.11
6 29.06.11
3 29.06.11
3 29.06.11
10 29.06.11
4 28.06.11
1 28.06.11
4 28.06.11
1 28.06.11
11 27.06.11
4 27.06.11
First Page Previous Page Page 82 / 305 Next Page Last Page

Excel based case study

 
#1 Excel based case study
27/11/2009 16:36

lola

Hi, as part of a recruiting process (Efficio Consulting) I will soon have to do an excel based case study. I have never done such a test before and I do not know what to expect. I would appreciate if somebody who gained experience in such exercises would share his/her experience with me. Thank you

Reply  Quote   
 
#2 RE: Excel based case study
27/11/2009 17:17

Kim to lola (#1)

I have had stats based case studies (risk management). I would recommend you do more than they ask (of course correctly).

I once did an Excel based case study in which I was asked to present results graphs/results in Excel. However, I actually wrote a mini report detailing each step I took, why I chose it and did the results make sense in the real world.

They want to see how you think. You need to think through and always have the so-what question in mind before coming up with a method. Never make any assumption without an explanation.

Hope this is helpful.

Reply  Quote   
 
#3 RE: Excel based case study
01/12/2009 16:07

Carrie Crevel, Efficio Recruiting Coordinator to lola (#1)

I am the Recruiting Coordinator for Efficio and would be happy to give you a brief description of our Excel case study. This is essentially a 1 hour exam designed to test your analytical skills when using Excel. We provide you with a large amount of "spend" data, similar to what our clients provide us, and you have to answer 4 questions relating to this information. The most important thing we look at is how the candidate solved the questions (i.e. what tools in Excel are used) - not simply the final answers.

If you have experience in using Excel in a highly analytical manner, you should be fine.

Any other questions, feel free to let me know.

Reply  Quote   
 
#4 RE: Excel based case study
31/07/2010 22:09

Alison to Carrie Crevel, Efficio Recruiting Coordinator (#3)

Hi, thanks for the above info and could you shed some light on the general recruiting process.

How long did Efficio take to back to you after you sent over the applications? And how is the online test for the 1st round like?

Efficio seems a really strong firm and I heard its culture is energetic and morale high. Would appreciate any information regarding the company as I just gave in my application days ago.

Many thanks!

Reply  Quote   
 
#5 RE: Excel based case study
12/07/2011 16:39

Amie to Carrie Crevel, Efficio Recruiting Coordinator (#3)

To Carrie Crevel, Efficio Recruiting Coordinator

Could you please give an example of questions to be asked on that case study? The type I am interested is exactly the one you have described. Other question relates to best way to get prepared to that sort of case study, which is based in Excel?

Thank you in advance!

Reply  Quote   
 
#6 RE: Excel based case study
14/07/2011 10:24

Carrie to Amie (#5)

Hello

Unfortunately this exam was developed in house by Efficio consultants, and therefore we do not have an example of questions to provide. To the best of our knowledge, we are the only management consultancy using an exam of this type.

However, if you are comfortable crunching data on Excel, and using the main functions (i.e. vlookups, pivot tables, sumif, etc) you should be able to successfully complete the exam.

The best way to prepare is through general Excel use and practice, using large data sets.

Reply  Quote   
 
#7 RE: Excel based case study
14/07/2011 13:00

Amie to Carrie (#6)

Thank you!

Reply  Quote   

Top of Page

ThreadID: 59399

Advertise
Your Jobs!