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 ...

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 ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

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.

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.