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

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

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.