A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Excel might be the world's most widely used programming language; Microsoft is on a journey to turn it into a better and more powerful programming language, without losing what makes it Excel.

Microsoft, which calls its Excel spreadsheet a programming language, reports that an effort called LAMBDA to make it even more of a programming language is paying off, recently being deemed Turing ...

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.

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 ...

Knowing how to use Excel's variables gives you the ability to make your formulas – and by extension the spreadsheets containing those formulas – much easier to understand. For example, the formula ...