VBA stands for Visual Basic for Applications. Even with the acronym unraveled, VBA might not meant that much to you but essentially it is the computer ‘language’ in order to create Macros. So what’s a Macro? Well, it’s all the instructions that you enter into Excel via VBA for the spreadsheet to perform tasks and to have style and formatting. It’s what makes a spreadsheet more than simply a set of numbers in a table by automating tedious mathematical tasks. So creating Macros and being ‘fluent’ in VBA are essential skills for a consultant. To get up to speed, here are the top websites…
1) http://www.homeandlearn.org/ Probably the best free course for beginner’s of VBA (and if any skills need brushing up then you can head to the main Excel website). 10 sections with multiple sections within each of these so that the info is short and snappy rather than too drawn out and complicated.
2) http://office.microsoft.com/en-gb/training/get-in-the-loop-with-excel-macros-RZ001150634.aspx Microsoft’s own free online training course for Macros. The tests at the end of the sections are good ways to assess whether you are understanding what you are reading.
3) http://www.howtogeek.com/162975/geek-school-learn-how-to-use-excel-macros-to-automate-tedious-tasks/ Basic introduction to what macros are with a worked through example and screen shot pictures.
4) http://excelvbatutor.com/vba_tutorial.html 23 tutorials on VBA by Dr. Liew Voon Kiong. Ebook to go with the tutorials available to download.
5) http://www.anthony-vba.kefra.com/vba/vbabasic1.htm A basic website which is a little difficult to navigate but there are good free VBA tutorials here
6) http://spreadsheetpage.com/index.php/tip/C32/ Useful guide to VBA functions but explained quite technically so not for the beginner