vote up 5 vote down star
4

Recently as part of my job I have had to edit and create a lot of excel spreadsheets. I am familiar with some Excel formulas but while editing the spreadsheets I don't feel that I'm using the full potential of excel.

Are there any books/online resources which guide someone with a programming background in Excel?

flag

6 Answers

vote up 3 vote down check

I think there are two necessary step towards achieving your goal.

  1. Learn VBA (obviously)
  2. Understand Excel's object model. This MSDN article, Automating Applications Using the Office Object Model might be a start.

Also, record some macros and examine them afterwards (Alt + F11). It helped me a lot when I tried to understand the VBA code that such macros produced.

link|flag
Excellent answer. VBA and the object model are core to taking full advantage of Excel. – Troggy♦ Jan 15 at 8:28
Since you have previous programming knowledge, picking up VBA and the object-oriented methods are probably going to be easy. Out of probably 500 financial analysts at my company, I am the most knowledgeable on Excel. It was easy as I was a CS major for 2 years. – Stephen Jan 16 at 5:21
vote up 1 vote down

I learnt Excel VBA Programming thanks to this book. I absolutely recommend it:

Microsoft Excel VBA Programming for the Absolute Beginner / Duane Birnbaum

link|flag
vote up 0 vote down

Look up the VBScript stuff for Excel on the MSDN site.

link|flag
vote up 0 vote down

I recommend the books written by John Walkenbach. Since you're already comfortable with Excel and programming, then I'd look at: Excel 2007 Power Programming with VBA (or its 2003 equivalent). His "Excel Bible" might be of interest, depending on how in-depth your knowledge of Excel is.

Also, the Excel-L programming list is an excellent resource when you have specific questions:

http://www.lsoft.com/scripts/wl.exe?SL1=EXCEL-L&H=PEACH.EASE.LSOFT.COM

link|flag
vote up 0 vote down

Right here on SuperUser and over at StackOverflow, especially with respect to coding.

link|flag
For extra help, sure. But I think he meant more an online tutorial, to not ask about anything each time. – Gnoupi Jan 15 at 6:48
Perhaps, but I have been able to glean an inordinate abount of information using just StackOverflow. I guess it depends on the person. – Optimal Solutions Jan 16 at 4:26
vote up 0 vote down

I have also been able to get some darn good help from folks on Youtube via their tutorials.

link|flag

Your Answer

Get an OpenID
or
never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.