Talk

Advanced search

Any Excel experts...? (Job interview, eek!)

(12 Posts)
AnnaK Fri 09-Feb-18 16:50:30

I have an interview next week for a finance officer role in a school and they use Oracle and Excel. As part of the interview there is a spreadsheet task. I am fairly familiar with Excel but does anyone have any experience of using it for financial purposes? Many thanks in advance.

DarthArts Fri 09-Feb-18 16:51:41

Yes - what do you want to know?

AnnaK Fri 09-Feb-18 17:31:40

Are there any particular commands that might be used just in a financial setting. I can Sum, create equations in cells using the = symbol. Anything else?

SussexBonfireViking Fri 09-Feb-18 17:37:06

can you do sumif, sumifs, countif, countifs,

what are you like on pivot tables?

and array formula?

BrandNewHouse Fri 09-Feb-18 17:39:57

Can you format cells so that they show currency? Conditional formatting?

There are several financial functions around interest/loan payments.

margotsdevil Fri 09-Feb-18 17:41:46

Vlookup, hlookup, rounddown, nested if statements?

Can you use conditional formatting and link worksheets?

SussexBonfireViking Fri 09-Feb-18 18:06:55

if you can do index and match that will make you stand out

the formula works like:

= INDEX ( WHERE AM I LOOKING, WHAT ROW NUMBER(a) , WHAT COLUMN NUMBER (b) )

then in (a) we put a match to find the location of the item we are looking for

= MATCH ( value to look for , where you are looking , 0 ) (to get an exact match)

AnnaK Fri 09-Feb-18 18:36:17

Thank you so much. Some of the above I know, the others I will revise over the next few days. Really appreciate you input!!

mercurymaze Sat 10-Feb-18 08:34:15

What do the ifs do ?

Xascha Sat 10-Feb-18 09:37:55

the if works with a true or false

if ( 3 = 3 , yes , no )
if ( 3 = 4, yes , no)

AnnaK Tue 13-Feb-18 17:05:00

I can't thank you lovely Mumsnetters enough: I got the job!!

SussexBonfireViking Tue 13-Feb-18 17:47:44

fantastic!!! well done you

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