software

Just thinking!

Having just participated in a recruitment process I noticed how
frequently people where prepared to attribute the epithet quot;excel
expertquot; to themselves. It is also clear that this is usually well
intended but also substantially inconsistant across candidates.

Any ideas on what could or should be done to differentiate candidates
successfully?--
tony h
------------------------------------------------------------------------
tony h's Profile: www.excelforum.com/member.php...oamp;userid=21074
View this thread: www.excelforum.com/showthread...hreadid=509438Have them solve what YOU consider a difficult Excel problem
'Steal' some problems form this list and make up a quiz; with carefully
written questions he/she should be able to answer without using a PC
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;tony hquot; gt; wrote in
message ...
gt;
gt; Just thinking!
gt;
gt; Having just participated in a recruitment process I noticed how
gt; frequently people where prepared to attribute the epithet quot;excel
gt; expertquot; to themselves. It is also clear that this is usually well
gt; intended but also substantially inconsistant across candidates.
gt;
gt; Any ideas on what could or should be done to differentiate candidates
gt; successfully?
gt;
gt;
gt; --
gt; tony h
gt; ------------------------------------------------------------------------
gt; tony h's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21074
gt; View this thread: www.excelforum.com/showthread...hreadid=509438
gt;
just make up a little test to give them before the interview- ask to explain
dcount, pivot tables, macros, etc... I did something similar for an IT
position once, and a couple people looked at the test, and walked out. What
a great screening tool!!

quot;tony hquot; wrote:

gt;
gt; Just thinking!
gt;
gt; Having just participated in a recruitment process I noticed how
gt; frequently people where prepared to attribute the epithet quot;excel
gt; expertquot; to themselves. It is also clear that this is usually well
gt; intended but also substantially inconsistant across candidates.
gt;
gt; Any ideas on what could or should be done to differentiate candidates
gt; successfully?
gt;
gt;
gt; --
gt; tony h
gt; ------------------------------------------------------------------------
gt; tony h's Profile: www.excelforum.com/member.php...oamp;userid=21074
gt; View this thread: www.excelforum.com/showthread...hreadid=509438
gt;
gt;

Several years ago, I took and passed an Expert Qualification test called
MOUS (Microsoft Office User Specialist). It was a shot at doing just what
you're interested in, quot;qualifyingquot; and Excel user. This test was supposedly
supported by Microsoft and cost me $75 (non-refundable in case I failed). If
you can find someone with MOUS credentials, they probably know a little more
about Excel than the average bear. After all, they put up the money of their
own hoping to qualify......one would not do that unless they felt pretty sure
of passing. I understand the MOUS Program underwwent a name change
tho........I think it went to just MOS (Microsoft Office Specialist). I do
not know if it is still even in existance, or if the new test is as hard to
pass as the old one was. but you could check with Microsoft.

Vaya con Dios,
Chuck, CABGx3
quot;tony hquot; wrote:

gt;
gt; Just thinking!
gt;
gt; Having just participated in a recruitment process I noticed how
gt; frequently people where prepared to attribute the epithet quot;excel
gt; expertquot; to themselves. It is also clear that this is usually well
gt; intended but also substantially inconsistant across candidates.
gt;
gt; Any ideas on what could or should be done to differentiate candidates
gt; successfully?
gt;
gt;
gt; --
gt; tony h
gt; ------------------------------------------------------------------------
gt; tony h's Profile: www.excelforum.com/member.php...oamp;userid=21074
gt; View this thread: www.excelforum.com/showthread...hreadid=509438
gt;
gt;

quot;tony hquot; wrote:
gt; Having just participated in a recruitment process I noticed
gt; how frequently people where prepared to attribute the
gt; epithet quot;excel expertquot; to themselves. It is also clear that
gt; this is usually well intended but also substantially
gt; inconsistant across candidates.

quot;Well-intendedquot;? I think you give them more credit than they
probably deserve. In my experience, almost everyone claims
they are an quot;expertquot; of whatever it is they do. That is true of
almost every profession. I no longer give any value to the claim.

(Actually, I will go a step further and say that a true expert
rarely calls himself that.)

gt; Any ideas on what could or should be done to differentiate
gt; candidates successfully?

I want to say that I sympathize, but you must also understand
that it is nearly an impossible problem. There is no difference
between your problem and recognizing a quot;tax expertquot;.

Keep in mind that even a certification only tells you that the
person was able to pass the test. It provides little insight into
their problem-solving skills, not even their ability to use every
element of Excel with quot;expertquot; capability. Moreover, unless
you have Excel expertise yourself, it might difficult for you to
evaluate a candidate's ability to solve quiz-like problems that
you might present as a test.

Here are some steps you can take to ameliorate the problem;
but please keep in mind that they are no guarantee.

First, be sure that someone you trust and whom you believe
quot;really knowsquot; Excel and its use in your company is involved
in the evaluation process.

Second, before any recruiting, sit down with people in your
company who quot;really knowquot; Excel and determine what Excel
skills you require. Excel is a very broad product now; for
example, quot;spreadsheetquot; skills offer little insight into quot;charting
skillsquot;, much less the ability to create interactive or aesthetic
products. And even quot;knowledge of macrosquot; does not go far
enough to determine a person's skill with VBA, for example.
Some macros depend only on standard knowledge of Excel;
some require quot;programming skillquot; as well.

Also, with this self-evaluation, you might discover that some
of the quot;Excel skillsquot; that you require are really from other
disciplines such as accounting, statistics and, as I mentioned,
computer programming (which itself is overly broad).

Third, ask candidates specific questions about those Excel
skills (or discipline skills) that you depend on. Yes, it might
be useful to have some quot;typicalquot; problems at hand. But
usually, any problems that can be solved within the short
time of an interview or quot;recruitmentquot; are usually trivial
enough that it does not take an quot;expertquot; to solve them.

What I think works better is to ask a candidate about a
real-world problem that either you have not solved yet or,
better, you solved only recently. Do not expect a neat
complete solution. Simply look at the candidates reaction
and listen to his response. If his eyes gleam with the
challenge, if he asks reasonable follow-up questions
(which should be necessary), if he offers some quot;off-hand
ideasquot; (not real solutions) that seem to be going in the
right direction, and if he can demonstrate just a few details
on the spot, you probably have a winner.

And I will add that if you are not comfortable with presenting
such a challenge, you are not the correct person to conduct
this part of the interview or screening.

Having said all that, keep in mind that it's still quot;a crap-shootquot;.
I think that is true of nearly everything -- for example, hiring
a plumber or electrician to do a job.

Good luck!


I think you are probably right in that. Once you are sufficiently expert
to realise how much there is to know it is difficult to call yourself an
expert.

I do remember one quot;expert in Excel and Lotusquot; couldn't give me a
formula for adding up a column of numbers!--
tony h
------------------------------------------------------------------------
tony h's Profile: www.excelforum.com/member.php...oamp;userid=21074
View this thread: www.excelforum.com/showthread...hreadid=509438Hello,

You must define your purposes of employing someone who must use Excel. Does
the person have to know everything or is it for basic accounting purposes?

People who say they are an expert are really saying they have common
knowlede of the package. You have to weedle out their quot;expertisequot;. They may
be experts with pivot tables, or macros or SQL, etc... Find the person which
best fits your requirements. Do not spend time looking for the expert
whoknows everything - needle in the haystack.

If you find someone who quot;enjoysquot; the workings of Excel but is, perhaps, not
as experienced as you prefer, just remember, there are pages like this that
helps those who want to learn more.- -Mark
www.geocities.com/excelmarksway

PS I am not an expert, I am a nexpert.
quot;tony hquot; wrote:

gt;
gt; Just thinking!
gt;
gt; Having just participated in a recruitment process I noticed how
gt; frequently people where prepared to attribute the epithet quot;excel
gt; expertquot; to themselves. It is also clear that this is usually well
gt; intended but also substantially inconsistant across candidates.
gt;
gt; Any ideas on what could or should be done to differentiate candidates
gt; successfully?
gt;
gt;
gt; --
gt; tony h
gt; ------------------------------------------------------------------------
gt; tony h's Profile: www.excelforum.com/member.php...oamp;userid=21074
gt; View this thread: www.excelforum.com/showthread...hreadid=509438
gt;
gt;