Recent Content
Using the Hidden Power of Excel’s FILTER Function
When you take the time to explore a new worksheet function, it's amazing what you can discover!
And I won't tell you about the really...
Featured Articles
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 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...
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...
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...
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
This Excel Analytical Charting Strategy Reveals an Economic Warning
With normal charts, you find data and then you plot it. But with analytical charts, you transform your data in various ways to discover...
Formulas & Functions
Excel Charts, Seasonality, & Analysis: Five Lessons from the WSJ
A 2009 article in the Wall Street Journal offered some great advice for Excel users in business. The article, New Light on the Plight of...
Excel Methods
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...
Popular
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...
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...
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...








































