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....
Predict Business Bankruptcy Using Z Scores with Excel
"General Motors Corp. and Ford Motor Co., the two biggest U.S. automakers, have about a 46 percent chance of default within five years, according...
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...
Map Costs and Sales in Excel with a Classic Breakeven Chart
When I worked as a CFO, my monthly reports always included a breakeven chart. It was one of the most popular reports I produced.
But...
Manage Periodic Payments with an Excel Cash Calendar
Most companies must write checks periodically to companies that don't send invoices. Often, their accounting systems provide little help in keeping track of these...
How to Make Top-Ten Charts Easier to Read
Managers need to know where the greatest opportunities and the worst problems can be found. This is why top-item figures are so popular.
These figures...
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...
How Your Company Can Work Without Limits in Excel
"CFOs at companies including P.F. Chang’s China Bistro Inc., ABM Industries Inc. and Wintrust Financial Corp. are on a similar drive to reduce how...
How to Use Conditional-Format Formulas to Change Background Colors
"I have an Excel table with a column that will be filled with 'yes' or 'no. When a user enters 'yes' to a cell,...
How to Sort Data in Reports Automatically Using Excel Formulas
Many Excel reports include tables that show sorted results. Usually, these tables were sorted manually in Excel, using the Data, Sort command. However, reports...
Latest Articles
Getting Radical with Excel
It's time to think about Excel in a radical new way—when we use it to work with business or economic data.
It's time, in fact,...
How Fast Is Too Fast?
(Originally published in Inc Magazine.)
What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...
How to Smooth Data by Using the TREND Function
Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...
Advertisement