Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel 2019 ...

Turn Excel into a lightweight data-science tool for cleaning datasets, standardizing dates, visualizing clusters, and ...

Nothing in your spreadsheet is there by accident.

Please note: This item is from our archives and was published in 2017. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I’ve accepted a job ...

If you have encountered the error message “There’s a problem with this formula” in Microsoft Excel, you are not alone. Many users report this error appearing ...

Q. I usually like Excel PivotTables, but because they don’t allow me to do certain things, such as delete cells or insert new columns or rows, I’m wondering if there is a reasonable alternative? A.

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

Formulas are one of the most important components of an Excel sheet and as such, deserve–warrant–protection. You don’t want users accidentally changing formulas and impacting the purpose of your work.