Sunday, October 25, 2020
Here's how I created the formula that calculates the breakeven sales volume for a prospective change in product prices.

Should You Raise Prices? Should You Lower Them? Derivation of the Formula For Planning...

The article, Should You Raise Prices? Or Should You Lower Them? These Excel Charts Can Help You Answer Those Questions, introduces the Price-Change formula....
Excel is a great tool for creating business plans. But one massive Excel business plan offers some great ideas about what NOT to do.

How to Audit and Improve Excel Business Plans

A client, who's a business-finance consultant, recently was hired to improve the financial forecast for a major startup company. He recently sent me the...
Which is faster: VLOOKUP? Or INDEX-MATCH? Here are the test results.

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...
You need a volatile workbook to test Excel calculation speeds. Here's how I set one up to test lookup formulas.

A Volatile Workbook to Test Calculation Times for Excel Lookup Methods

In Use Excel VBA to Test Report Calculation Times I described a macro that finds the total time necessary to calculate Excel for a specified number...

Latest Articles

Here's how to boost your Excel output, slash your Excel errors, and improve your Excel reports and analyses—whether you work for a large or small company.

How to Be Significantly More Productive in Excel

The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...
Use this Excel dashboard to track 27 economic indicators of the United States' recovery from the Covid-19 recession.

Learn How to Use Excel to Track the US Recovery from the Covid Recession

The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...
This Excel dashboard report lets you follow key economic trends while showing you how to gain a HUGE increase in your Excel productivity at work.

Track Key Economic Indicators Every Weekday with this Excel Dashboard

You can update this Excel dashboard report every weekday—with one command—if you have Excel 2016 or above. This report of current economic data introduces you...
Advertisement
Advertisement