Jim creates systems that are easy to understand and use. He is the winner of the 2021 Max Gladstone Special Judge's Choice Award (Golden Cobra Challenge), where he was praised for designing straightforward rules and accessible experiences that work perfectly online.
At Spreadsheet Point, Jim applies this same focus on clarity and accessibility to technical guides, ensuring that even the most complex formulas are easy for beginners to pick up.
Beyond data, Jim is the creator of the competitive writing event Ink & Blood, the podcast Frugal Living, and the author of "The Ink and Blood Dueling Society Doesn't Exist." You can find more of his articles on MuckRack.
Additional Resources:
The best error handling function is IFERROR (in Excel). Let’s explore its applications. To show how much this can impact the readability of your workbook, I’ll focus on a specific example
There are several dynamic ways to convert currency using Excel. Whether you’re looking to convert USD to EUR or any other currency pair, Excel provides powerful tools to help you
This guide shows you how to use the Excel FILTER function. I break down the syntax, provide practical examples, and share a video that demonstrates the process. You can also
This guide explains the =SWITCH() function in Excel. I share what it does and when it is most helpful. I’ll also share some practical examples of its use. The Excel
Let’s talk about the Excel CHOOSE function. We will cover its syntax, how it works, and ways to make the most of it. As always, I’ve also made a video
Let’s delve into one of Excelโs powerful functions โ the NOT function. I’ll discuss syntax first, then examples. By the end of this tutorial, you’ll understand how the NOT function
Excel macros can turn a 20 minute routine into a one click workflow. This guide shows you how to record a sorting macro, build a formatting macro, and run both from simple buttons.
To calculate running totals, Excel’s SCAN function handles everything in a single formula. This guide includes a video and step-by-step instructions. Learn how to easily calculate a running total in
Enhance your Excel workbooks with interactive buttons. In this guide, I’ll show you how to create buttons in Excel using two different methods. Whether you’re a novice or an experienced
