Hello and welcome to r/LifeProTips!
Please help us decide if this post is a good fit for the subreddit by up or downvoting this comment.
If you think that this is great advice to improve your life, please upvote. If you think this doesn’t help you in any way, please downvote. If you don’t care, leave it for the others to decide.
I just got home from a christmas party at a company i just started with and one of the youngest accountants was introduced to me by everyone as “thats Nick, hes an absolute wizard with excel” including both the owners of the company.
Cant buy that kind of reference
I used to be so bored in my job that I would create a horse racing game in excel by using rand and trunc to give me random numbers and if the number went above a certain threshold, the “horse” would move to another cell. I sometimes weighed different horses with higher probability. I started adding wagers and added or subtracted how much I would win. I then started putting in winning odds with higher payouts. And this all started because I automated most of my job with macros and batch scripts. Turned an 8 hour job into 1 hour tops. Good thing they never realized I could do this.
Edit: fixed autocorrect errors.
For anyone who sucks at excel and reading this thread and feeling daunted, check out ExcelisFun on YouTube. His hour long vlookup and pivot table videos are gold. You will be better than most people at the office after those.
Feel free to learn VBA and macros, but honestly I feel like if you want to learn those you might as well learn a programming language. Don’t be deterred by people in this thread telling you to learn VBA. I don’t know it that well and I’m consider myself to be very good at excel. If you want to learn it, there’s also ExcelVBAisFun on YT as well.
Index match instead of lookup btw