How to Select Values from a Validation List in Excel
Excel provides two ways to select a value from a list of values. I often use this feature in interactive Excel reports to select dates,...
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...
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 Structure Your Report Workbook
In Weekly & Monthly Top-Ten Activity Reports I introduced two Excel dashboard reports created by Chris Helfrecht. In this post, I’ll describe a critical aspect of...
An Introduction to Excel Data Plumbing
Would you like to:
Create your new reports, analyses, forecasts, and other Excel work quickly?
Update your Excel work with one command, without using...
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...
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...
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...
Interactive Excel Reporting
Several years ago, a reader asked me to help him with an Excel-reporting challenge that might sound familiar.
His challenge, he said, was that he...
The Excel-Friendly Database Strategy
Here's the key to slashing both your Excel errors and the time it takes you to create and update your Excel reports...
Get your plumbing...