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...
Five Ways to Make Your Excel Reports Incredibly Popular
Years ago, I was the young CFO of a small company that was purchased by a Fortune-200 company. Within days of the sale, I...
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,...
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...
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...
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...
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...
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 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...
Five Ways to Improve Business Insight in Your Excel Reports
Is there a systematic way that you can help your readers to gain more insight from your Excel reports? There just might be.
The November,...