Tuesday, April 13, 2021

This category will contain a growing number of free downloads of workbooks discussed on this site. But I need to set up each download. If you don’t see a download you need, drop me a note and I’ll move it to the top of my list.

Charley

### Compare Loan Payment Options in Excel

When you’re comparing your payment options for mortgage loans, your choices can be overwhelming... When in St. Ives, I found a home, Then looked at seven...

### XLOOKUP vs VLOOKUP vs INDEX-MATCH vs SUMIFS

SUMIFS? Really? Why is SUMIFS included among those lookup methods? I'll explain in a few minutes. But first, let's look at the lookup methods shown in...

### How to Create Cycle Plots in Excel to Chart Seasonal Sales Data

If your company's sales are seasonable, you've probably seen a chart that looks something like the first one below. This Excel chart shows the continuous...

### Fun with XY (Scatter) Charts in Excel

Because I’d been working hard on a project for many months, I once decided to take a break and play around with XY charts…which...

### How to Use Array Formulas to Report Groups of Accounts

Often, in accounting, marketing, and other departments, we'd like to report and analyze groups of items rather than one item at a time. In Part...

### How to Set Up an Automatic Error-Checking System in Excel Reports

Decades ago, I worked as a cost accountant for a large company. But because our department received terrible reports, I wrote my own reports...using...

### How to Stack and Shelve Dynamic Arrays

While using Excel 365 recently, I needed to create one dynamic array that would consist of two arrays, with one stacked on top of...

### How to Report Top and Bottom Results Using Dynamic Arrays in Excel

In How to Use Excel’s LET Function, I showed several examples of a powerful function that Microsoft added to Excel 365 in the summer...

### How to Report Top and Bottom Results Using Dynamic Arrays in Excel

In How to Use Excel’s LET Function, I showed several examples of a powerful function that Microsoft added to Excel 365 in the summer...

### How to Use Excel’s LET Function

In the summer of 2020, Microsoft introduced the LET function for Excel 365—one of the most-significant new worksheet functions that Microsoft has introduced in...

### How to Set Up an Automatic Error-Checking System in Excel Reports

Decades ago, I worked as a cost accountant for a large company. But because our department received terrible reports, I wrote my own reports...using...