How to Use The Excel CHOOSE Function
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
Jim Markus
September 5, 2024
Jim Markus
About Jim Markus Jim Markus is an Independent Journalist and Award-Winning Game Designer serving as an Editor for Spreadsheet Point. At Spreadsheet Point, he builds spreadsheet templates and specializes in data visualization in Google Sheets.
Highlights
- Director at Spreadsheet Point and an award-winning game designer and sales professional.
- Renowned for hosting the popular personal finance podcast Frugal Living and writing for platforms like Hackr.io and KDnuggets.
- Recipient of The Max Gladstone Special Judge's Choice Award at the Golden Cobra Awards and a Dale Carnegie-trained public speaker.
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. He also runs Autumnal Games.
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:Recent Articles
Understanding the Excel NOT Function: A Comprehensive Guide
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
Jim Markus
August 27, 2024
How to Make Excel Macros
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.
Jim Markus
February 12, 2026
Calculate Running Total with the SCAN Function in Excel
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
Jim Markus
August 13, 2024
How to Create Excel Buttons
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
Jim Markus
August 2, 2024
How to Use the COUNTIF Excel Function
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
Jim Markus
July 31, 2024
Google Sheets Tips
Rental Property Spreadsheet: Track Income and Expenses
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
Talha Faisal
November 27, 2024
How to Move Rows Based on Cell Status in Excel
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
Jim Markus
June 6, 2024
Google Sheets Tips
How To Highlight Duplicates in Google Sheets
Highlighting duplicates in Google Sheets takes one formula and a conditional formatting rule. This guide shows how to do it in a single column, across multiple columns, and for entire duplicate rows, including how to flag only the second occurrence, combine multiple conditions, and fix the two most common reasons the formula stops working.
Sumit Bansal
February 23, 2026