Advanced Excel Tutorials?

Question

I'm looking for an advanced excel tutorial to learn more about automating things, creating more user-friendly data entry screens, etc.

As well as easy-to-understand beginner's lessons on VBA...

Is there a good free internet source, or a reasonable buy-at-a-book-store, computer store book or cd-rom to help me?

Answer 1

Go to this excel tutorial site, it will have all the info, intermediate to expert level, topic by topic listed with examples.
http://www.cpearson.com/excel.htm
I tried quite a few books to improve my excel vba, I ended up going back to excel vba help because those books either is too elementary or have narrow coverage.
My approach in advancing in excel vba was...
1. get myself a lot of practice on real projects/problems
2. using macro recording feature and study the code generated by Excel itself.
Hope this would help.

Answer 2

VBA isn't the easiest thing in the world to learn, but the book I would highly recommend is Excel 2003 Power Programming with VBA by John Walkenbach. Check it out on Amazon, and read the customer reviews. By the way, as long as you are using Excel 97 or later, this book is applicable.With the book you get a CD with Excel files containing most of the example macros in the book.

Answer 3

Why do you want to go for books when you can get a live online instructor led excel training on webex for $ 59 or so.

Just checkout this site www.excelgoodies.com , they have a special course where they teach u only tips and tricks etc which is not actually displayed on the packages page. just try chatting with consultants online there.

I learnt it from them. May be u can give a try.

Answer 4

try
http://www.anthony-vba.kefra.com/

You might try half.com also. I've gotten cheap books on there before.