You’d think stock traders, of all people, would have the best data available. But that wasn’t the case when JPMorgan started bleeding billions on bad trades. Investors got worried. The bank dismissed ...

Spreadsheets are absolute. You enter some variables, and a spreadsheet outputs an absolute number, according to whatever logic has been programmed into it. But here’s the problem: While spreadsheets ...

Excel has quietly gained dynamic arrays, XLOOKUP, Power Query, and Python, yet many still work the old way.

While opening an Excel spreadsheet in OneDrive, if you confront an error message saying We ran into a problem completing your request, here is how you can fix it ...

Q. Help! My future value calculations don’t make any sense (see the spreadsheet below). The formula in column D is the same for all rows, but for unknown reasons, it stops working after row 7. What’s ...

They're calling it the "Excel Error Heard Round the World": Kenneth Rogoff and Carmen Reinhart's widely cited paper about the relationship between public debt and ...

If you use simple copy and paste methods to duplicate an Excel drop-down list, you may discover a problem; when you copy a cell that has a drop-down list and press "Ctrl-V" to paste it into a new cell ...