Often people who are experienced with spreadsheets flee to learn Visual Basic. Excel brings a lot of functionality built in so you do not feel the need to learn to program. In fact, there are a number of reasons to get comfortable with writing macros in Visual Basic (VBA).
VBA looks good on your CV
Microsoft Office is used by nearly every employer in the world and the broader your skills with the suite of applications, moreis an attractive candidate when applying for jobs. Visual Basic macros in Excel is the same language used in Word, Access or other Office applications.
Once you know how to write macros in Excel, using the Word macro is only a matter of learning some new object definitions. Even if you are happy with the company you work for, it never hurts to improve your ability to work. The more you can do more valuable you are to your boss. Also, you never know what will happen tomorrowbring unexpected and could force a dismissal to start looking for work.
Get more value to Excel
Stretch your dollar further software using the full functionality of Excel. If you are not using Visual Basic, Excel is only half of an application. It 's a bit like buying a car, but making only right turns. Learn to write your own macros opens a world of functionality. You are no longer limited by the built-in. Now you can write your own and make them almostanything you want.
Macros allow you to create complex functions without calculating intermediate cells that may be required when using the built-in. For example you could have a list of values and want to put any value in an equation and then add the values. With built-in functions that should have had a cell next to each value that puts it into another cell, then the equation that summarizes the results. A macro could step through each value, perform the calculation, and the sumtotal of all in a cell.
Get your work done faster
When you first learn Visual Basic, Excel built-in functions might seem like a faster way of doing things. Puzzling out the program structure and results of exit turn right rather than quick and dirty to use shortcuts on the spreadsheet.
Over time, your VB programming skills will improve and will make custom functions faster. Although it takes time to create the function in advance, will beSave time each time you use. Soon there will be a standard library functions of self-creation that can easily be added to every piece of work they do.
Do not be discouraged. It can take months to become proficient with Visual Basic, but once you are comfortable with it you will be glad you took the time to learn.
No comments:
Post a Comment