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

The new user interface in the latest version of Microsoft Excel changes all the rules. Here's how to find your way around and get the most out of Excel 2007.

How to Use the IF Function in Excel 2007 With Absolute References. Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's ...

How to Create Maps in Excel 2007. There are several ways to create maps in Microsoft Excel 2007. While you can always paste map images into a worksheet or even draw your own maps using the shape ...

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

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 cell styles are easy to implement. Knowing they exist and how to determine what’s in use and how to modify a style are the keys to using them efficiently.

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.