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 and the author of "The Ink and Blood Dueling Society Doesn't Exist." You can find more of his articles on MuckRack.
Additional Resources:
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
Learn how to use the COUNTIF and COUNTIFS functions in Microsoft Excel to count cells based on specific criteria. This step-by-step guide will help you master these useful functions and
To make a rental properties spreadsheet in Google Sheets, follow my guide. I’ll show you how to use it to manage income and expenses. I also provide a free rental
Have you ever wanted to move rows in one worksheet based on the status of another? Here’s how to do that in Excel. I’m including my Visual Basic code, which
To highlight duplicates in Google Sheets, use conditional formatting and the COUNTIF function. My guide below covers this in detail. Specifically, I’ll show how to use conditional formatting to highlight
If you want to highlight errors in Google Sheets, consider the ISERROR function. I’ll show you how to use it with conditional formatting to highlight an entire row when it
