When you’re creating an application in Microsoft Excel often times you will want to give your user a way to enter values in a cell that does not involve them having to type them. Spinners and ...

Excel 2007's secondary axis feature enables you to view two different data series with two distinct scales, all on the same chart. Use this feature to view your business' sales and inventory figures ...

Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.

If you work with multiple Excel files over the course of a workday, and especially if you use a dual-monitor setup, you might wonder how you can launch each Excel file in its own window so you can ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel. Spreadsheets’ greatest ...

In Microsoft Excel, a function is a predefined formula that makes calculations using specific values called arguments in a specific order or Structure. In this tutorial, we will explain how to use the ...

Over the last few months, I’ve written several articles about Excel’s newish dynamic array functions. In many cases, they can replace older, more complex expressions. The new functions do all that ...

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