The simplest way to start documenting Excel formulas like a coder is by using the N () function. Although its primary job is to convert non-numeric values into numbers, it has a hidden quirk: because ...

When you first start writing scripts, modularity, reusability, and best practices may not be top of mind. As your scripts become more complex, however, creating reusable elements becomes essential. By ...

If you've ever tried building a product catalog in Excel, you know the headache — images float over cells, they don't move ...

Take advantage of Azure Functions to run small pieces of code that can be triggered by events in the Azure cloud. Azure Functions is the serverless compute offering in the Microsoft Azure cloud.

Programming is a constant game of mental Jenga: one line of code stacked upon another, building a tower of code you hope is robust enough not to come crashing down. But it always does, as code never ...

Writing good code requires close attention to detail and lots of will power and discipline. Good habits are half the battle. Last week, I talked about the relationship between polishing forks and ...