Learning Excel's Visual Basic for Applications Language
In my previous article about 5 easy ways to learn excel i explained 5 methods that can help you learn the program and it's interface quickly. That are great, but the real skill in using excel is problem solving and creating sustainable solutions to business problems. The real power in excel is visual basic for applications (VBA). This is the inbuilt macro language that allows you to create your very own programs in excel. It will take you to the next level and increase your effectiveness of your business. Any spreadsheet application without a macro language will limit your productivity. By using VBA you can automate repetitive processes. All those manual excel tasks can be done at the speed of light. I would never consider myself as a programer - just a serious excel user. Here are some approaches you can take to start learning VBA.
1) Use the macro recorder - the macro recorder is a bit like the old VCR recorders. It is the easier way to get started to automate a repetitive process. It also a great way to learn how code is developed by the recorder itself. It gives you a head start when creating or developing your own programs. Many users use macros to get the majority of the code that is required and tidy it up and add additional code. The macro recorder does have its disadvantages as well. It uses a lot more code than is required, which can slow your process down, especially the standard page setup code. There is much faster code available. Also, the macro recorder records everything you do, especially selections to cells, which are not required. The biggest weakness is it's inability to loop through a process. If i want to combine the contents of 10 excel worksheets data into one. The macro recorder would only do this once. Everything would be hard coded, including cell reference and file names. Eventually, your demands from excel will push you away from the recorder to actually adding your own snippets of code. I did not believe this when i first started learning excel and VBA, but it is true.
2) Learn from books - There are many great books on the subject. Make sure you get one that is aimed at the beginner. Idiots guide are a good start to cover basics, but you should move on to more technical explanations and their application. It is the application of code that is important. Many books describe the method and it properties, but do not go into any detail of how to use it. The visual editor help option can describe the code already. It is the real life examples you need.
3) Take a course - If your employer can pay, then you should go on a course which will quuickly increase your learning curve.
4) Get online - there are many online course and ebooks and guide that will walk you through how to do anything in excel. For example, if you are interested in creating performance dashboards, then stewarttraining.co.uk provides an excellent guide and templates to help you get started. Even the code is provided for you. The charts and dashboard components have been done so you don't need to recreate them. For £20, it is great value. It is not plug and play because every dashboard has different requirements. It does not focus on the private sector. It could be used for any sector.
I Want To Start Mastering Microsoft Excel!
MICROSOFT EXCEL VIDEO TUTORIALS made easy today, find valuable SHORTCUTS To
using carefully designed VIDEO TUTORIAL TODAY!.
How You Could Simplify a 5-Hour Task To Become a 5-Second Task!
(Data Sorting, Data Analysis And Chart Plotting)
And you can use it again and again by just clicking on one button.
Are you really serious about Mastering Microsoft Excel, achieving excellent speed and result and perform like nobody could ever achieve before in your work!
If you are, you can make that an instant reality right now. Grab a copy of Excel Expert User at the great bargain now, while you still can!
VBA for Excel (Macros)
VBA is the programming language used within Excel to develop macros
Let me offer you my 30 years of experience in accounting and finance and my expertise in Excel certified by Microsoft to help you use all of this data and transform it into sound business decisions.
"Tired of Boring Online Courses?"
Then Stop Attending Them And Switch To The Fast Lane Now!
 You can learn the basics of Excel in less than an hour.
Some people make a table on Excel and then and up doing the math with a calculator since they don't know which of the the buttons are used to automatically deal with the numbers for them. You probably didn't even know how flexible the copying and pasting is on Excel.
This needs to end right now . You're wasting too much time using trivial techniques when you could just as easily use the automated techniques and work on things much faster.
It's called Easy Excel Basics because everything can be learned in under 1 hour! Think of all the things you can do with the time that you have left.
| 
