Show Top and Bottom Results in a Chart-Table
The workbook that supports the following figure does a lot of work!
First, it uses Power Query to download the weekly unemployment claims and the...
US National Financial Conditions Using Excel Panel Charts
I’ll explain the meaning of this chart figure shortly. But first, let’s look at it from an Excel perspective.
(Note: I’ve begun to use economic...
What’s a ‘Deprecated’ Function in Excel?
Wikipedia tells us that deprecation is a status applied to a computer software feature, characteristic, or practice indicating it should be avoided, typically because of being superseded.
Each new generation of...
How to Use SUMPRODUCT in an Excel Table to Filter Any Number of Items
Excel 2007 introduced the powerful Table feature, as illustrated below. Tables allow you to sort and filter your data easily.
However, the filter capability has...
Use COUNTIFS, not FREQUENCY, to Calculate Frequency Distribution Tables for Charting Histograms
Because the Texas and California governors have been bickering over the Texan's attempt to poach California employers, I got curious about the distribution of...
Use Benford’s Law & Charts in Excel to Improve Business Planning
Unless you're a public accountant, you probably haven't experimented with Benford's Law.
Auditors sometimes use this fascinating statistical insight to uncover fraudulent accounting data. But it might reveal...
Use a ‘Visible’ Column in Formulas to Ignore Hidden Rows in Filtered Tables
Excel Tables, introduced in Version 2007, give us the ability to use column filters to hide rows in a Table.
And slicers for Tables, introduced...
Two Ways to Set Up Multi-Criteria Lookup Formulas in Excel
The Excel Table below illustrates a common type of lookup problem…perhaps taken to a slight extreme.
Here, we have a specific manager for each month...
Three Ways to Reduce Errors in Your Excel SUM Formulas
If you aren't careful, simple edits to your reports and analyses can cause significant errors.
Years ago, for example, I heard about an expensive error...
The SUMPRODUCT Function’s Undocumented Method
SUMPRODUCT and SUMIFS are Excel's two most powerful functions for returning filtered data from a table. SUMPRODUCT is more powerful, but SUMIFS is faster.
Unfortunately, Microsoft's documentation about...
Latest Articles
How to Be Significantly More Productive in Excel
The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead...
● You can update them in a few seconds, with...
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...
Advertisement
Advertisement
