You might have heard the idiom about the guy with his feet in a freezer and his head in an oven: on average, he's perfectly comfortable. In Excel, we do this with our data every day. Averages are ...

Variance is a measurement of the spread between numbers in a data set. Investors use the variance equation to evaluate a ...

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?

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