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?

How to shorten references using the hashtag symbol in Microsoft Excel Your email has been sent Referencing can become difficult, especially if you’re using structured referencing. Instead, reference a ...

Have you ever found yourself buried under a mountain of Excel spreadsheets, painstakingly updating formulas every time new data comes in? It’s a common struggle, one that can turn even the most ...

Please note: This item is from our archives and was published in 2021. It is provided for historical reference. The content may be out of date and links may no longer function. Excel’s Analysis ...

Want to get more out of Excel? At Microsoft’s inaugural Data Insights Summit last month, several experts offered a slew of suggestions for getting the most out of Excel 2016. Here are 10 of the best. ...

While Excel's charts are excellent tools for displaying complex data in more understandable ways, sometimes, you might want to quickly visualize your numbers in a simpler way that also takes up less ...

Variance is a measurement of the spread between numbers in a data set. Investors use the variance equation to evaluate a portfolio’s asset allocation.