Monday, March 1, 2021
The SUMIFS function returns a sum for nearly any number of single criteria. But with SUMPFODUCT you can return the sum for many criteria listed in a Criteria List.

How to Use SUMIFS with Criteria Lists, Summarizing Sales

With one exception, SUMIFS is a very powerful function. And it's very fast. To understand the one exception, suppose you have a table of sales...
These keyboard shortcuts will help you to things in Excel that are difficult or time-consuming to do any other way.

Five Really Useful Excel Keyboard Shortcuts

Most Excel users use some of Excel's shortcuts frequently, like F9, Ctrl + C and Ctrl + V. However, Excel offers other shortcuts that are nearly as useful....
When you include recessions and economic downturns in your charts, you can show your company's performance in a much better context. Here's how to set up your Excel charts to display those recessions and downturns.

How to Show Recessions in Excel Charts

I showed you the following figures in Chart Your Rate of Change to Reveal Hidden Business Performance. The line in the first chart below shows Apple's...
When you combine conditional formatting with charts you can create detailed chart legends that match the relative positions of the lines in your chart.

How to Create Dynamic Chart Legends in Excel

When I saw a chart designed like the ones below in the Wall Street Journal, I knew I had to create one just like...
Spreadsheet users in businesses have distributed management dashboard reports for more than 30 years. Here's an example from the early days of spreadsheets.

The First Spreadsheet Dashboard: Mini-Graph Reports in Lotus 1-2-3

This is the first dashboard report ever created with spreadsheets. I worked on this reporting technique in the early 1980s, then included this report...
An Excel-Friendly Database is defined as an organized collection of data from which worksheet formulas can return values. Here are five Excel-friendly databases.

Introducing Excel-Friendly Databases

The most productive way to flow data to your Excel reports and analyses is to use Excel formulas to flow data from an Excel-Friendly...
Excel can be the key component of a powerful and inexpensive Business Intelligence (BI) system. Here are some ideas to get you started.

Excel Is Great for Business Intelligence!

With the right access to data, Excel can become an outstanding Business Intelligence (BI) system. Business Intelligence (BI) is the systematic use of information about...
By charting the annual Rate Of Change (ROC) of key measures, you can uncover significant information about your time-series data. And by using the right recession measure, you can put that information into better context.

Chart Your Rate of Change to Reveal Hidden Business Performance

What insights can you gain from the following Excel chart of Apple's quarterly revenues over the past 18 years? I see three things. First, their...
Your Return On Equity ratio is a key indicator of financial health. This report lets you show the components of that ratio in a unique Excel display.

Map Your Financial Health With an Excel DuPont Dashboard

Management reporting is all about communication. Reporting Return On Equity (ROE) is a case in point. The ROE financial ratio is a key measure of...
The Internal Rate of Return calculation has very real problems, no matter where it's calculated. But with its MIRR function, Excel could offer a solution.

How Excel’s MIRR Function Can Fix the IRR Function

The calculation of an Internal Rate of Return is very appealing...at first glance. When you know the IRR of a prospective investment, you seem to...

Latest Articles

The LET function is the most powerful function that Microsoft has released for Excel in years. Here's an introduction to its features.

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...
You can ratchet down errors in your Excel reports by using an Error Summary Table that uses conditional formatting to alert you to errors.

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...
Here's how to create an Excel array from two others, with the arrays stacked either one on top of the other, or side-by-side, like books on a shelf.

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...
Advertisement
Advertisement