I didn't think much of LAMBDA helper functions when Microsoft added them to Excel. However, after finally trying them out, they proved to be a revelation. They work with LAMBDA functions, allowing you ...

Spreadsheet software can be incredibly helpful for business owners looking to streamline their data collection and organization. You can use spreadsheet software for various parts of your business, ...

Following on from my blog post a few months ago about cool stuff in the Fabric Toolbox, there is now another really useful solution available there that anyone with Fabric capacities should check out: ...

The new Fabric Graph database is now rolling out and should be available to everyone within the next few weeks if you can’t see it already. The key to learning a new data-related technology is, I ...

Here are some examples on how to add data validation to a worksheet. The following code adds a data validation to a range that only allows integer values between 1 and 5. The following code adds a ...