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

You can reference a list on another sheet, but it takes a bit more work. In this tutorial, I’ll show you how to populate a dropdown with data on another sheet.

This article will teach you how to transfer data from one spreadsheet to another in Microsoft Excel if your copy and paste function is not working. This article will show you three methods of how to ...

How to Calculate Average on Excel From Multiple Sheets. Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook.

How to Format Relative References in Excel. Microsoft Excel relies on two fundamental reference types when addressing other cells. Absolute references -- which are denoted with a "$" -- lock a ...

In Excel, Boolean logic (a fancy name for a simple condition that’s either true or false) is one way to sift specific data or results from a large spreadsheet. Granted, there are other ways to ...

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.

This cheat sheet gets you up to speed on the features that have been introduced or changed in Microsoft 365’s Excel for Windows desktop client over the past few years. (If you’re looking for ...

Our visual guide helps you find the most popular commands on the Ribbon in Excel 2016 and 2019 for Windows, along with keyboard shortcuts for performing each action.