This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Specifically, you can use Power Query to import a single dataset like an Excel workbook, a table from a website, or a database. Alternatively, you can import multiple datasets from worksheets in an ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

How to populate a dropdown with data from another sheet in Excel Your email has been sent If your list and dropdown are on different pages, you’ll need to know this trick to make the dropdown ...

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.

Susan Harkins shows you how to format and unlock input cells in Excel at the same time by assigning a modified style.

Microsoft is bringing its AI directly into Excel formulas with the Copilot function. It is designed to automatically analyze, ...

In March 2019, Microsoft announced a new innocuous-sounding Excel feature called "Insert Data from Picture" to the Excel for Android mobile app. That capability -- which could revolutionize how ...