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.

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you. If you regularly work with Excel spreadsheets, you probably find yourself repeating ...

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

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

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

Launch Excel Enter data or use existing data. Enter a formula into the cell. Press Enter. See result. Launch Microsoft Excel. If you type the ratio 0.5 into the cell, then enter the formula in the ...

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