Excel Tutorials?

Nitefly · 7 Dec 2011 at 14:44

Hi there,

I've recently been offered a job but it requires good excel skills, particularly in regards to formulas and linking spreadsheets.

However, my excel skills are rusty - are there any decent tutorials anywhere that will help me?

Many thanks

izzop · 7 Dec 2011 at 14:48

Have a look at Mr Excel, might be a useful resource for the future.

Regards

Nitefly · 7 Dec 2011 at 15:26

Thanks - I assume that's a forum for question asking? Cheers

FNGsam · 7 Dec 2011 at 15:46

Just google it, that normally solves it for me

WillyNelson · 7 Dec 2011 at 16:19

Google taught me almost everything I know about Excel.
"Excel 2007 [what you want to do]" Hit enter
Usually there's someone who's already asked the question you want the answer to.

Linking spreadsheets: =click on cell in other workbook/sheet you want to link to, hit enter.

Do they give examples of the type of formula they're interested in; lookups, if statements, etc?

AberystwythLAD · 7 Dec 2011 at 16:23

Excel is easy, so easy, they teach it on a BTEC in IT.

I know everything about Excel now after having it forced down my throat in college. Use an IF statement, program this to make macro's to make things easier in the future.

I hate excel :mad:

Participant · 7 Dec 2011 at 16:23

I remember when I told a prospective employer that I was good with pivot tables and I'd never used one. A couple of hours on Google the day before I started meant that they never knew I was fibbing. (Now pivot table god).

Egon · 7 Dec 2011 at 17:34

AberystwythLAD said:
Excel is easy, so easy, they teach it on a BTEC in IT.

I know everything about Excel now after having it forced down my throat in college. Use an IF statement, program this to make macro's to make things easier in the future.

I hate excel

That entirely depends on the level in which you go into... BTEC (I'm assuming level 2?) isn't exactly a high level!

Excel can be a very powerful and complicated tool. Most users only ever brush the surface of what it is capable of.

semi-pro waster · 7 Dec 2011 at 17:47

Excel can be tremendously powerful and can make pretty complicated work very easy but occasionally (just occasionally) it seems to go the other way and what logically seems like it should be simple becomes a bit more difficult than it should be.

The Excel help function is actually pretty decent but I do tend to go straight to a search engine when I'm stuck or alternatively look back over older spreadsheets where something similar has been done.

Do you know what formulas you're likely to be expected to know, I might be able to help with some although I'm far from an expert. Also if you don't mind me asking what type of job role is this for? Doesn't sound very law related since most law professionals of my acquaintance barely manage to turn on the computer and use Word.

mollymoo · 7 Dec 2011 at 17:50

It would help to know what the job is really but i know where there are good tutorials on excel for accountancy.