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 ...

The Solver add-in for Microsoft Excel is one of the most important, so we can understand the frustrations when users cannot get it to work as they hope. In older versions of Excel, folks had to ...

Track stocks like a pro with a free Excel add-in Your email has been sent Retrieving up to date stock market prices for Excel is a snap with the free Stock Connector add-in. Here's a walkthrough of ...

Ever wish Word had an encyclopedia you could tap, or Excel could generate some dummy numbers? Office add-ins provide this kind of added functionality to Word, Excel, PowerPoint, and other Microsoft ...

Solver allows you to use an Excel spreadsheet to easily solve problems with multiple variables. We'll look at a couple of examples to see what Solver can do and how easy it is to use. Solver is an add ...

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).

Many of them are backward- and forward-compatible, but check the system requirements before you download anything. Note that newer isn’t always better: Many of the ...

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 ...

We’ve long been warned that the use of Excel spreadsheets throughout the enterprise line of business seriously hampers many compliance and auditing efforts. The lack of controls and change management ...

Let’s face it—Microsoft Excel is one of those tools we all seem to need at some point, whether it’s for managing budgets, organizing data, or tackling that last-minute project. But if you’ve ever ...