“Even people who aren’t familiar with Excel can use the feature. It takes complex functionality that someone would otherwise have to build in formulas or code and puts it in the hands of common users.

Spreadsheet programs like Microsoft Excel and Google Sheets can be powerful tools if you're a wizard with formulas, but learning all the ins-and-outs of those apps can be time-consuming. If you ...