Excel woes

[xirokx]

Hi,

I am desperately trying to get my head around Index & Match and SUMIF functions in excel ....I need it for work, so need to understand it on a level where when I need to do some analysis I can easily say "yep I can index match that or SUMIF the other"..

What do you guys suggest?

Do you know of any tutorials that can quickly and easily help me master this?

Please help

Cheers

 

[xirokx]

has to be excel...

mark thats great but I was hoping for something a bit more idiot proof as Im a newb something like a little tutorial...

So far I have checked google and failed miserably in finding anything useful which is written in lamens terms..