Recent Content
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...
Featured Articles
How to Report GL Account Groups in Excel
Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks.
In fact, this income statement illustrates a...
Learn How to Use Excel to Track the US Recovery from the Covid Recession
The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...
Track Key Economic Indicators Every Weekday with this Excel Dashboard
You can update this Excel dashboard report every weekday—with one command—if you have Excel 2016 or above.
This report of current economic data introduces you...
What the Heck is an Excel Database?
You can raise your Excel productivity significantly and slash your Excel errors—if you keep your data in an Excel database.
Microsoft, Oracle, IBM, and others...
Find Leading Indicators Using Automated Cross Correlations in Excel, Part 1
It all seems so simple...
To improve your forecasts of sales or other measures, you simply need to find leading indicators...measures that are highly correlated...
Blog
Add Low-Overwhelm Context to Your Line Charts
The data you display in charts often takes on new meaning when you display it in the context of other data.
One way to add...
Business & Economics
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...
Formulas & Functions
Two Business Uses for Excel’s New Chart Feature
For decades, I've been whining about the need for Excel to have some way for our formulas to specify a gap in line and...
Excel Methods
How to Debug INDEX in Excel
"I'm not a very experienced Excel user. Why does = INDEX(...) sometimes work and sometimes not.... :-)?" -- Suzan G.
Probably the best way to...
Popular
Why INDEX-MATCH Is Far Better Than VLOOKUP or HLOOKUP in Excel
(Download the workbook.)
Excel’s VLOOKUP function is more popular than the INDEX-MATCH function combination, probably because when Excel users need to look up data then a "lookup" function...
An Introduction to Excel’s Normal Distribution Functions
(Download the workbook.)
When a visitor asked me how to generate a random number from a Normal distribution she set me to thinking about doing statistics...
How to Delete Blank or Unneeded Rows, Method 1
When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. Often, you’ll want...