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

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

How to Have Three Secondary Axes on Excel 2007. 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 ...

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.

Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

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.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

Follow these steps to set up a general ledger accounting system in Excel. A small business can use Excel as a substitute for expensive accounting software.