An optimization problem is one where you have to make the best decision (choose the best investments, minimize your company’s costs, find the class schedule with the fewest morning classes, or so on).

A popular add-on for helping Excel users creating optimization models has made its return to Excel 2008. Solver for Excel had been among the casualties of Microsoft’s decision to drop Visual Basic for ...

In the first part of this blog, Using Solver in Excel, Part 1, we started looking at what we can do with the Solver add-in to the Excel spreadsheet program. We looked at using Solver for the design of ...

The new experimental add-in will allow Excel users to type in prompts directly in a spreadsheet grid. The generative AI feature will then create an answer to the prompt, also in the grid. A few weeks ...

Stratified mean-per-unit sampling is a key tool used by auditors. The popularity of this statistical procedure arises from its unique ability to produce trustworthy ...

We all can admit that Microsoft Excel is the best tool in its class, but there are ways to improve it with some cool and free Excel add-ins from the store. Some of these add-ins do basic things, while ...