The ability to automate tasks in Excel for the web has been a long wait—but it’s finally here, and it was worth the wait.

A check mark box in an Excel spreadsheet is handy for ticking off items, but it can go much further. Excel check boxes can trigger calculations and provide visual indicators. For example, in ...

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.