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

2] Use Name in formulas You can also let Excel name a range or table cells for you. For this, select the cells in the table you want to name.

You can sum cells across multiple sheets in Excel. This article presents steps for Adding single-cell values or Adding values in the range of cells.

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

When you link a cell in Excel to a cell from another worksheet, the cell that contains the link shows the same data as the cell from the other worksheet.

How to Find Cells With Strikethrough in Excel. For a business leader, Microsoft Excel 2010 can be an invaluable tool for monitoring inventory, recording customer information or keeping track of ...

Do you want to keep important labels and data in view as you scroll through your Excel worksheets? Here are the steps to freezing those columns and rows.