The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

How to Increment a Number in Excel. Product IDs, serial numbers and other reference numbers require a unique identifier to avoid confusion when referencing a product or specific data point.

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you ...

If you want to find and fix Circular References in Microsoft Excel, then this guide will help you get the job done with ease.

Excel’s INDEX function allows users to reference values in a range of data (or array of data) by their column and row number position within that range. As a simple example, the formula =INDEX (A1:F10 ...

How to subtract in Excel using cell references You don't have to subtract numbers in a single cell; you can also set up a formula that will subtract the values stored in multiple cells.

How to return a set number of consecutive numbers in Excel By combining ROW () and ROUND () with a couple of input values, you can create a very flexible consecutive numbering function.

Type an apostrophe before entering or pasting two numbers separated by a hyphen in Microsoft Excel to keep the numbers from being converted to their month and date equivalent.