what is the best way to learn excel?

[ajishkumar]

What is the best way to learn and master excel? I am not an avid reader. I am a keen observer. My style is to watch and learn. So, videos work best for me.

Which one do you recommend?

Thanks,
Ajish

 

[meldoc]

Hello

Start here.

http://www.youtube.com/user/bjele123

And here.

http://www.youtube.com/user/ExcelIsFun

 

[Derek Brown]

I would recommend the MrExcel LiveLessons DVDs:
http://www.mrexcel.com/store/index.php?l=product_list&c=9
There is one available for Excel 2003 and another for Excel 2007.
Available from the MrExcel store, Amazon.com etc.

 

[smithgt]

I've just downloaded the Bill's eBook and there is a reference to a free tip card that maps each item on the Excel 2003 menu to a tab on the Excel 2007 ribbon.

Where can I find this?

 

[Domski]

I've just downloaded the Bill's eBook and there is a reference to a free tip card that maps each item on the Excel 2003 menu to a tab on the Excel 2007 ribbon.

Where can I find this?

You'd be better off posting this question in the Mr Excel's Products sub forum: http://www.mrexcel.com/forum/forumdisplay.php?f=19

Dom

 

[scottylad2]

The Excel is Fun series on youtube is a great place. over 1000 videos all categorised and mostly in watchable 10 minute kinda size. There's everything from beginner through to advanced.

Also if you have an I-phone, you can get the Mr Excel downloads onto your phone, and learn in your tea break at work! these are mostly only a couple of minutes but imo they are for someone who has a decent knowledge of excel.

Good luck, you'll be hooked in no time!

 

[WaterGypsy]

Just get stuck in - it's the only way to learn anything .... use real life situations to build your knowledge and don't try to do anything too complicated until you know the basics ...... common sense really .... you can't learn from books or from videos you can only learn by doing the job

 

[scottylad2]

Just get stuck in - it's the only way to learn anything .... use real life situations to build your knowledge and don't try to do anything too complicated until you know the basics ...... common sense really .... you can't learn from books or from videos you can only learn by doing the job

have to disagree, seeing an array formula demonstrated then using this board to see how its applied in everyday situations makes far easier learning than just getting stuck in. With no prior knowledge, using excel help files to learn the difference between Sumif and Sumifs would leave most newbies baffled but watch a video demonstration or a mr excel podcast and they start to make much more sense.

 

[WaterGypsy]

Ah fair point clearly when you know what you need then a worked example is valuable ....

... but what I was getting at was that until you know you need an array formula there is no need to learn about it.

If you build up your expertise step by step - building on what works and discarding what doesn't then you'll be better off than someone with a solution looking for a problem to fit it .....

 

[Patience]

I'm with WaterGypsy on this. Even if you did learn about array formulae before you needed it, you'd forget it by the time you did need it. At least that's how my brain works, anyway.