Google launched an updated version of its Sheets Web app for spreadsheet editing on Monday, adding new capabilities that the company hopes will lure people away from Microsoft Excel.

The updates include a feature that lets users preview the results of formulas as they type, so they can troubleshoot problems without leaving the cell they’re editing. Google says the new capability is exclusive to Sheets, and comes alongside other capabilities like the ability to filter data by conditions including “greater than” and “text contains.” A new “GETPIVOTDATA” function makes it easier for users to pull information out of a pivot table, as well.

To read this article in full or to leave a comment, please click here

…