How do I become a Excel / VBA Guru?

dbmathis

Well-known Member
Joined
Sep 22, 2002
Messages
1,064
I thank all of you that have been helping me lately in the forums. I have always loved working with excel and I am ready to become a MS Excel VBA guru.

I willl call myself a beginner. What books do I need to read and in what order?

Thanks
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
dbmathis said:
I thank all of you that have been helping me lately in the forums. I have always loved working with excel and I am ready to become a MS Excel VBA guru.

I willl call myself a beginner. What books do I need to read and in what order?

Thanks

What books? At the beginning stage, NONE!

First, become really strong with the native Excel environment. Become a wizard at Excel and you will reap far more benefit from that strong foundation.

Next, find yourself an actual project that requires building a full model in Excel. It should be rather complex -- incorporating the advanced knowledge that you have obtained in the first step.

I think that this is the most critical step -- to become comfortable building solid, replicable models that work and are efficient. For me, this requires an actual project that needs a solution -- not merely an example to follow but a project where you have to figure it out for yourself.

When you become good at building a worksheet/workbook, do so with the macro recorder turned on. Then study the resulting, inefficient code. You will learn the basics of Excel VBA.

Now is the time to buy a book. Avoid the advanced books for now -- the Bullen and Green book(s) come to mind as more advanced at this stage. Start with some of the MrExcel offerings, the Walkenbach books, or the Kofler books. They can be quite complete, so give a glance at a bookstore or library before buying. What is good for one person might not be good for another.

Throughout your journey to guru, take advantage of the MrExcel board and the newsgroups. You will learn a ton -- even some new ways of doing things you already know.

Good luck.
 
Upvote 0

Forum statistics

Threads
1,224,847
Messages
6,181,323
Members
453,032
Latest member
Pauh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top