Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

Diarmuid Early won first place in the 2025 Microsoft Excel World Championship. He has some pointers for using Excel at work.

In this video, we explore the new COPILOT function in Excel, which requires a Microsoft 365 Copilot License. This feature allows users to replace complicated formulas with simple prompts, such as ...

Custom pharmacy functions enabling a user to calculate patient metrics, lab values, and drug dosing. With the Pharmacy Function Library, you can perform commonly used clinical pharmacy calculations.

This project is a port of the excel-formula library to ES6. It contains a set of functions that can be used to pretty print Excel formulas and convert them into JavaScript, C# or Python code.

Have you ever felt like Excel is both your greatest ally and your most frustrating challenge? For decades, this spreadsheet giant has been the backbone of countless workflows, yet its complexity often ...