Jim Markus

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

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

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