• 1 Post
  • 83 Comments
Joined 1 year ago
cake
Cake day: July 2nd, 2023

help-circle
rss






  • Or you type into Google “what’s the song that goes dun dundun dooo dodododo dooo” and you somehow get the right result because some other monkey asked the same question on a message board and by some stroke of luck got an answer.

    This worked for the funeral dancing song because I couldn’t remember what it was from but it was stuck in my head for a week.








  • I’m not a programmer by trade but I learned some python and VBA to automate some of the things I do every day. Any time you’re doing some manual shit and think “there’s gotta be a better way” there probably is - just Google how to do that one thing and you’ll build up your knowledge over time.

    It’s up to you to decide if you tell your boss or not. I chose to and took on some extra duties along with extra pay so it worked out for me but it’s a small business with a high value on productivity.


  • Good God please use xlookup. We have some old school people that still use vlookup and refuse to convert their ranges to tables, it drives me crazy.

    I still use index/match for multiple lookup returns (or is it sumifs I can’t remember?) But I do a lot of work in BI and it’s much more intuitive for me in DAX/M.