In my 25+ years of using Excel, here's what makes a pro:
1. Someone who knows how to use two dimensional TABLE()s and vector functions.
2. Someone who can implement an imperative convergence (such as Newton/Raphson or non-plug-in goal seek)
3. Someone who can audit their dependencies and not shit out dozens of unused vars
4. Someone who knows the limit is 10 sheets and 20MB. :)
Visual Basic and shortcuts do not a pro make. VB makes Excel =less= usable, IMHO because now there is an extra dimension to debugging that requires understand each Macro and what it touches: it breaks the entire philosophy of show formulas + auditing.
Yes, this sounds like /r/iamverysmart and /r/gatekeeping, but I'll own that.
1. Someone who knows how to use two dimensional TABLE()s and vector functions. 2. Someone who can implement an imperative convergence (such as Newton/Raphson or non-plug-in goal seek) 3. Someone who can audit their dependencies and not shit out dozens of unused vars 4. Someone who knows the limit is 10 sheets and 20MB. :)
Visual Basic and shortcuts do not a pro make. VB makes Excel =less= usable, IMHO because now there is an extra dimension to debugging that requires understand each Macro and what it touches: it breaks the entire philosophy of show formulas + auditing.
Yes, this sounds like /r/iamverysmart and /r/gatekeeping, but I'll own that.