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

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

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

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

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

While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such cases, Excel's LOOKUP function can be extremely useful. It allows you to ...

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

The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. If you are ...

The Excel IMSUB function is an Engineering function and its purpose is to return the difference between two complex numbers. The formula for the IMSUB function is IMSUB(inumber1, inumber2). The syntax ...