Learning Excel

reehsetin

I can do basic functions on excel and use basic formulas (am fairly good with techie stuff generally just this is my first time I’ve had to use excel for managing data), I’m having to do quite a lot of work on excel at the moment and a lot of the work is quite laborious because I’m working with a fairly large amount of data.
I have been googling how to do some things and checking excel’s help function but some things I can’t find, maybe it’s because I’m not searching for the right term or maybe it isn’t possible in excel.
What’s the best way to find out and to teach myself a bit more about excel, e.g. things like there is one unique number on sheet 1, I want excel to find that number on sheet 2 and copy across a result e.g. yes/no/pass/fail

I had a look at courses but it was £80+ for learning the basics and I'd prefer something web based anyway
Any ideas?

JasX

I hear youtube has a lot of Excel tutorial type videos, might be one place to start.

GSXRCarlos

check the microsoft help pages, not sure of the exact page, but google excel tutorials and see what you get

libra10

You might find this useful

http://inpics.net/excel07.html

Lots of help here

http://office.microsoft.com/en-us/training/default.aspx?ofcresset=1

Jake'sGran

The word EXCEL always makes me laugh as the teacher at a course I went on suggested to one lady that she practice Excel and she responded "I'd rather stick pins in my eyes". I'd never heard this expression before. Don't Microsoft issue the full instructions on line?

rmg1

They do now. There are also some very good books to be had (I use Excel daily and find the books very useful for some of the more "interesting" formulae!)

geewhiz

Can't go wrong with this site, full of useful info that i've found helpful over the years:

http://www.cpearson.com/excel/topic.aspx

Lakeuk

Learn to use the hot keys, master the ctrl & shift keys and your through put will greatly increase as you zip round your data

michaelro

You tube should be good for tutorials but if you ever have a question

mrexcel.com is invaluable.

I've also used the cpearson site above several times :cool:

PhilCo_2

For the example you've given you need a vlookup. Once you've learned them playing with data becomes a lot easier.

rmg1

I've currently got 78MB worth of eBooks (and that's zipped). Some of them have much the same info and two of them are for VBA programming, but I can e-mail them if you want.