To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

When working with multiple sheets in an Excel workbook, you may need to reference data from one sheet to another for calculations, analysis, or to keep your workbook organized. Here are a couple ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.