Seeking developers experience
N2IT
Inactive Imported Users Posts: 7,483 ■■■■■■■■■■
I am looking at honing my skills in Access and Excel and want to take it to the next level.
I would give myself a 5 out of 10 using Excel I have a long way to go, but I was wondering in your opinions what would be the best way to get stronger? I have bought power user videos for Access and Excel and want to spend several months going through those and really grabbing new concepts and ideas. However taking it even farther you need to grab VB. Do you think taking a class at the community college or just picking up a book would be enough? I realize that time, time and more time is the really answer, but as far as effciency goes what do you recommend?
I really want to become strong in Excel and Access, even to a development level.
Any information would be greatly appreciated.
I would give myself a 5 out of 10 using Excel I have a long way to go, but I was wondering in your opinions what would be the best way to get stronger? I have bought power user videos for Access and Excel and want to spend several months going through those and really grabbing new concepts and ideas. However taking it even farther you need to grab VB. Do you think taking a class at the community college or just picking up a book would be enough? I realize that time, time and more time is the really answer, but as far as effciency goes what do you recommend?
I really want to become strong in Excel and Access, even to a development level.
Any information would be greatly appreciated.
Comments
-
JDMurray
Admin Posts: 13,081 Admin
All of the applications in Microsoft Office support Visual Basic for Applications (VBA). VBA as a scripting language similar to VBScript, but is used for writing anything from simple macros to very powerful programs. Becoming a VBA programmer is necessary to claim full mastery over the Microsoft Office apps.
If you like writing software I'd really recommend you giving it a try. VBA doesn't change very often, and there is quite a bit of code and information already on the Web.
Getting Started with VBA in Office 2010
Programming resources for Visual Basic for Applications
Download details: Office 2003 Editions: Excel VBA Language Reference -
N2IT
Inactive Imported Users Posts: 7,483 ■■■■■■■■■■
All of the applications in Microsoft Office support Visual Basic for Applications (VBA). VBA as a scripting language similar to VBScript, but is used for writing anything from simple macros to very powerful programs. Becoming a VBA programmer is necessary to claim full mastery over the Microsoft Office apps.
If you like writing software I'd really recommend you giving it a try. VBA doesn't change very often, and there is quite a bit of code and information already on the Web.
Getting Started with VBA in Office 2010
Programming resources for Visual Basic for Applications
Download details: Office 2003 Editions: Excel VBA Language Reference
JD thanks again
I decided to take the intro level VBA class at the community college after going through those links. A lot of the jobs I have been applying (application analyst position tier 3) are seeking some knowledge so I decided to go through with it.
They also require SQL knowledge, but I am fine there. I have real world and academic knowledge with SQL.