IT Test for Administrator

(13 Posts)
DiaryOfAWimpyMum Fri 21-Jun-13 18:52:18

I had the interview yesterday with a panel of 4 and answered 16 questions fairy well once I got past the initial nerves and was advised they would let me know next week.

She called me today so say she needed to take the interview process further as me and one candidate are neck in neck and she cannot decide between us, so I have an IT test next week and a decision will be based on that and references.

My references should be very good, I had a fantastic working relationship with my last line manager and the one previous to her so that should be okay and it is really out of my control.

I have today at home, made a mail merge (word) made a lovely little chart (excel) used autosum, created labels (access)

Is there anything else you can think I may need to 'brush up on' pre-test? Or anything else I can do to show them they need to PICK MEEEEEEE. blush

Any tips or ideas would be greatly appreciated.

Celador Sat 22-Jun-13 06:07:36

Excel formulas (I would go with vlookups, how to record a macro, basic IF statements) & how to create a basic powerpoint presentation.

Good luck, hopefully you get the job!

MrGeresHamster Sat 22-Jun-13 06:25:30

Data entry and accuracy of it.

Formatting in ex

MrGeresHamster Sat 22-Jun-13 06:27:06

Sorry hit post too soon...

Formatting in excel and word.

Letter writing (etiquette/grammar/spelling)

DiaryOfAWimpyMum Sat 22-Jun-13 12:52:13

I will do some more work with excel, create a macro and more formatting in excel, my word skills are pretty good, I need to brush up more on my excel possibly.

Thanks a lot, I need to check my work more I think, not fairy well fairLy well.

I wish they could have just made a decision!!

FadBook Sat 22-Jun-13 12:59:15

Also Microsoft outlook (email), perhaps creating a signature or organising a meeting using the calendar.

Good luck - I'm sure you'll be fine.

DiaryOfAWimpyMum Sat 22-Jun-13 13:51:43

Oh yes the calendar too I will have a little play around with that.

I'm fairly good with letter writing I had to do a lot of that in my last work, mail merge, formatting, header, footers, centre, bold, underline, oh I need to do a macro again.

I think it may be out of my hands, if I don't get I will apply for more

DiaryOfAWimpyMum Sun 23-Jun-13 09:41:37

I have a thick question if anyone see this.

Does every Word use DVS for Macros or is it just word2013?

I think I played around making various macros for 2 hours yesterday, I love macros geek

That's a bit sad on a Saturday night. hmm

Everything is so easy in Word 2013 I'm now worried the 2008/2010 version will trick me up, gah it will go on the references no doubt and it's no a big deal at all anyway, I will be upset for 24 hours or a week then I might find more good jobs.

alimac87 Sun 23-Jun-13 23:26:42

Good luck good luck!! crosses fingers

DiaryOfAWimpyMum Tue 25-Jun-13 11:51:45

thank you!! It's today envy <<<------ = nervous interview feeling

I have spoke to a few people who know the organisation and have been told by 2 different people that 'I probably will not get the job' hmm

I am still going though, if I have came this close they might pick me for another job sometime, somewhere and feeling this level of nerves is fantastic experience.

<grasping @ straws>

Celador Tue 25-Jun-13 22:32:14

OP, how did it go?!!

DiaryOfAWimpyMum Wed 26-Jun-13 05:57:54

Absolutely terrible!! blush

To begin with I was shaking and hitting the wrong keys as I'm so used to my laptop now but got over that, managed the 2nd part but the first past was listing wages net and gross and I have never done payroll. confused

I typed the majority of the spreadsheet out saved it knew there was no way I could do it so saved all my work and smiled and left. She sent an email a few hours later saying I hadn't got it but I knew when I left I hadn't.

I think there was a bit too much on Financial side for me tbh

DiaryOfAWimpyMum Wed 26-Jun-13 07:22:32

Tbh if it wasn't in a test setting I would have found how to do it no problem and I know now (infuriatingly) what I should have done, but it's too little too late.

I had brain freeze.

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now