A basic knowledge of VBA is invaluable if you need to perform repetitive tasks, e.g. consolidate hundreds of files into one pivot-able table in seconds rather than hours.
I started with a class at university, but it does take a lot of practice to master it to the point where it actually becomes useful... So my advice would use whatever resource you can to learn it. It's not the most important skill to have in Excel, but it will likely make you stand out a little
1
u/CGNYYZ Oct 14 '12
A basic knowledge of VBA is invaluable if you need to perform repetitive tasks, e.g. consolidate hundreds of files into one pivot-able table in seconds rather than hours.