Related Posts
PLTR is crushing it the past two weeks.
More Posts
Visual Storyteller
Conversation Starter
Conversation Starter
Additional Posts in Consulting
soo my sleep schedule is effed up, i keep trying to wake up early-ish (7am) but i’m lacking motivation and i wake up tired 😴
i stumbled upon this article that talked about this book. we always hear about the “secret” of strong leaders is that they wake up early. has anyone read this/tried it out?
5 AM Club, The: Own Your Morning. Elevate Your Life. https://www.amazon.com/dp/1443460710/ref=cm_sw_r_cp_api_i_n2GdFbJJEFKSN
Best books on leadership and self development?
Any recs for CIPM study books?
How's LEK doing in Europe?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
1,000,000% Very easy to learn and people will act as if you can speak russian.
Better than MBA
I used to make a lot of VBA macros but now moved away from them. Transparency of what algo does is really low and its much easier to explain someone by breaking the process down into multiple steps via Excel formulas. That said, still great for things like auto loading of data from some database, generation of charts etc
Rising Star
Also good for quickly formatting regular data calls from some archaic system that only exports to Excel, PDF, and some other weird file types nobody ever uses.
Maybe once a upon a time it was a real differentiator and useful. Today you would be much better investing your time on tableau/power bi (dashboard and analysis) and SQL to manage big data. Even as a general consultant, these skills are were handy. (Speaking from my experience)
Rising Star
Project specific. Honestly, just remember that the 'record macro' button exists and you're probably in good enough shape.
It's often a little easier to share a macro because not every workstation has Python or R Studio, but they all have Excel.
Agree with the other comments. There are enough alternatives and enough of us who do know VBA that makes it unnecessary (you can email global excel help 😀). If you have time and willingness go for something else, good suggestions above.
A little VBA and a lot of Python (Flask, Selenium, Pandas)
This way you can integrate Excel with more capable Python tools.
Strategic Ops here - its been essential on a couple projects of mine, and I majorly saved the ass on my team getting us to automate analyses that would have been soul sucking to do late at night manually.
It’s pretty similar to python and you can also record specific functions to learn from it. I have definitely used SQL and Tableau more, but it’s a good tool to have that requires little effort to learn.
Sure is. I remember working on a PPT deck of 150 decision trees. It was so much worth it to code a little VBA script to copy paste data from my Excel in a template...
Why learn it vs python?
I originally come from commercial and am starting to find that out for myself haha. I admit there is a bit of misinformation out there and it can become a significant hurdle.
Good luck with your project! I hope you can sway the client.
I speak Russian 😅 and sometimes use VBA for specific mechanical tasks :)