As you are a Team Leader, Learning VBA is not going to help you. You just need Basic Excel Knowledge to manage your team.

VBA is for programmers who need to develop softwares.

Learning VBA is like - How you learned Bi-cycle. You will learn it, but it would take you an year to master it. You need immediate returns of your invested time, to make more money, and should not waste your another 3-6 months.

If you want true answer read below:

Firstly, Excel and VBA directly has no relation.  VB (Visual Basic) is a separate programming language like other languages Java, .Net, C++ etc.  Visual Basic for Application (VBA) is used as support to all Microsoft Office applications in form of Macros.

So, VBA macro is nothing but that component of Visual Basic which does certain tasks alowng with Microsoft office applications which helps in some automations.  People have misconcept that for automation VBA is required.  It's INCORRECT.

Excel is application full of logic through it's formulae and functions.  So, automation can be done using formulae only even better than VBA.  Just by putting input, you can get output if your solution model is perfect.  There is no need to run any macro.  Further, disadvantage of macro is that one should learn VB first and editing is not simple for person who has not learned VB.  Also modification in existing VBA code is not that simple unless you know thoughtprocess of coder.

So, logic is most important.  If you have it clear, you will creat path to reach solution and excel functions are powerful enough to help you doing that.  VBA or excel functions are not going to help you with logic.

To conclude, make your logic clear first and learn excel functions.  If you are good with those, then only jump for VBA coding.