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