This article will teach you how to use the MATCH formula in Excel to find data entries that are partially linked to one another. How to perform a partial cell match on Excel? The below example shows ...

This tutorial will explain how to find a value in an Excel column using the Find function in VBA. Excel will highlight all of the cells that correspond to your search. How to search data using the ...

Text in a cell in Excel is called a text string. Excel provides a number of built-in functions enabling you to select and manipulate text strings in cells. The easiest way to identify or extract a ...

How to Calculate Multiple Cells in Excel. Microsoft Excel is a spreadsheet program used to store and analyze data. While Excel is able to hold both text and numerical data, most of the pre ...

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

You can subtract multiple cells from one cell in Excel by using Minus sign, SUM function and Paste Special feature. Here is a tutorial on this.

To insert an image in a cell in Microsoft Excel, click the Insert tab, select the Illustration button, then select Picture. It's so simple!

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

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.

Safeguard your Excel worksheets from accidentally deleting formulas or data sets by locking important cells, while leaving the rest of the worksheet editable.