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

As you use Microsoft Excel more and more, you'll find that the VLOOKUP function is a very popular tool for dealing with large Excel directories or databases. It allows the user to quickly find ...

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