At the Build 2018 developer conference that's taking place these days in Seattle, USA, Microsoft announced support for custom JavaScript functions in Excel. What this means is that Excel users will be ...

In the well-established Office Ready-Fire-Aim tradition, Microsoft adds two new “features” that beg to be abused. Details appeared at Build, and the bad guys already have their keyboards primed. Once ...

Excel has native regex support, and it works exactly how you'd expect.

Have you ever followed a YouTube tutorial, carefully copied an Excel formula, and hit “Enter,” only to be met with an error or baffling results? It’s a ...

Have you ever stared at an Excel spreadsheet, overwhelmed by its complexity, and thought, “There must be a better way to do this”? You’re not alone. Despite being one of the most widely used tools for ...

Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not.