If you like the tools discussed below, check out what I’ve been launching at www.sheetswizard.com — including the new flagship app for data analysts everywhere! Click here to trial it You may be wondering where I came up with the idea to write an article titled “What’s New and Exciting…

In my last post I gave the basics on how to hook Apps Script up to Notion, who have a notoriously opaque API. HR folks trying to flex their technical chops have it hard enough, so I wanted to get more content out into the world to make life easier…

Phew — after two days of trying to find a solution for how to accomplish a popular, reasonable set of tasks in Notion’s API, I wanted to do my duties as a Google Developer Expert and blog the solution for others to use. Notion databases are like Google Sheets from…

The greatest trick HR Systems ever pulled was convincing the world they existed… I confess that I am having a bit of an existential professional crisis. One best summarized as “what even is HR?” The distinction between internal admin roles at a company are tenuously held together by spreadsheets and…

Hello my friends in the world of performance reviews! Happy review season. If you’re in a large enterprise, you may be the type to build 9 blocks (or 9 boxes) for use in your performance process — big matrices of talent rated on a performance & potential scale. I got…

They say you only live once, and, with that, you may only once find yourself at a company with a video-game-centric culture. Life at Twitch creates a unique opportunity to bring the magic of gaming to your workday, even when you’re in esoteric corners of the work world such as…

When I teach my Excel to Google Sheets courses, I like to start off with a bang and show new users one of the most overpowered (but complex) formulas in the Sheets arsenal, IMPORTRANGE. Why IMPORTRANGE? It allows you to query data from any other Sheet in your company. This…

How to build a more perfect workflow for data updates and changes by coding in Apps Script between the Sheets Update Dec 2021: I am gearing up to teach a course on People Analytics to help others break into this world and grow — please fill out this form to…

Quick tech tips and cultural nudges to reduce burnout in this meeting-fueled work-from-home era. As far back as 2006, the scions of work at Basecamp knew that meetings were “toxic”: We all agree and yet we all let them keep happening. And that was…