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.

To create a pivot table, navigate to the ‘Insert’ tab in Excel. From here, you can choose to place your pivot table in a new or existing worksheet, depending on your preferences and the layout ...

Microsoft Excel makes it possible for users to create 3D Maps from Tables. This tutorial will explain all you need to know.

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

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Learn how to easily set up your own search field in Excel to find and filter content within a table.

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

Is your chart boring? Try Excel’s people chart to liven things up. Susan Harkins shows you how. A people chart is an infographic, which leads me to a second definition. An infographic tells a ...

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.

On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a ...

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.

You can delete a pivot table in Excel with a few clicks on a Mac or Windows PC. Here are two ways to do it.