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

We show you how to import data from Access Data Database into Micrsoft Excel. Access is the primary tool for managing a database.

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

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.

Web queries offer a handy way to import data from selected tables into a worksheet--but Excel isn't as accommodating as it should be, especially when it comes to parameters. These tricks will let ...