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

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to combine columnar values into a single cell using Microsoft Excel’s ...

A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

If you come across a table on the web or in another source that you want to import into Excel, there's an import feature that does the work for you.

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