How to Use SUMIFS with Criteria Lists, Summarizing Sales
With one exception, SUMIFS is a very powerful function. And it's very fast.
To understand the one exception, suppose you have a table of sales...
How to Create a Rolling Forecast of Seasonal Sales in Excel
The Excel chart below shows the typical saw-tooth pattern of seasonal sales.
Seasonal sales have about the same pattern every year, every week, or both. In...
How to Set Up a Pivot Table as an Excel-Friendly Database
You can use a Pivot Table as a database in the same way that you can use Excel Tables and other Excel-Friendly Databases (EFDs).
In...
How to Save Multiple Excel Reports to One PDF File
A great way to distribute your Excel reports is to save them in a PDF file and then distribute the file.
People who receive your...
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,...
Excel’s Fastest Lookup Methods: The Tested Results
This article presents the results of my tests to find Excel’s fastest lookup method.
I discussed the report workbook in A Volatile Workbook to Test Calculation...
Read a Text File with VBA in Excel, and Write the Text to a...
"I need to write a text file into one row of my Excel spreadsheet, cell by cell, 20 characters at a time. It's urgent....
Map Your Financial Health With an Excel DuPont Dashboard
Management reporting is all about communication. Reporting Return On Equity (ROE) is a case in point.
The ROE financial ratio is a key measure of...
How Excel’s MIRR Function Can Fix the IRR Function
The calculation of an Internal Rate of Return is very appealing...at first glance.
When you know the IRR of a prospective investment, you seem to...
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...