Saturday, February 27, 2021
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....
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...
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...

Latest Articles

The LET function is the most powerful function that Microsoft has released for Excel in years. Here's an introduction to its features.

How to Use Excel’s LET Function

In the summer of 2020, Microsoft introduced the LET function for Excel 365—one of the most-significant new worksheet functions that Microsoft has introduced in...
You can ratchet down errors in your Excel reports by using an Error Summary Table that uses conditional formatting to alert you to errors.

How to Set Up an Automatic Error-Checking System in Excel Reports

Decades ago, I worked as a cost accountant for a large company. But because our department received terrible reports, I wrote my own reports...using...
Here's how to create an Excel array from two others, with the arrays stacked either one on top of the other, or side-by-side, like books on a shelf.

How to Stack and Shelve Dynamic Arrays

While using Excel 365 recently, I needed to create one dynamic array that would consist of two arrays, with one stacked on top of...
Advertisement
Advertisement