An curved arrow pointing right. Don't waste time testing different values individually in Excel. Use a data table to show the results for many different possible scenarios at once. Follow BI Video ...

Q. In your November Tech Q&A article on Excel’s Scenario Manager, you mentioned two other “what-if” tools: Goal Seek and Data Table. Can you show how those work like you did with Scenario Manager? A.

Use Data Table for what-if analysis. Old-school Excel came with a forecasting ability that looked at historical data and made forecasts with a high-low numeric range, but it was fairly linear ...

Unlock the power of GROUPBY in Excel! Combine tables, create dynamic fields, and perform scalable data analysis with this comprehensive guide ...

Let’s get started using Scenario Manager using an example. To follow along, download this Excel workbook. A video demonstration is available at the bottom of this article. Note that the following ...

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Excel tables use named columns, allowing for flexible column placement and easy reference. Arrays, on the other hand, reference ranges by position, making them less adaptable when columns need to ...

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.