For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...

In Excel, you can create relationships between two tables based on the matching data within the table. Learn how to create relationships between tables in Excel.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Here's a quick tip for creating a Microsoft Excel drop down list from another tab.