If you are looking for an easy way to enhance your Excel data analysis and visualizations you might be interested in learning more about the Filter feature available within Microsoft Excel ...

What if you could transform your Excel workflow from tedious manual filtering to a seamless, dynamic process that feels almost magical? For years, Excel users have relied on basic tools to sift ...

The introduction of dynamic arrays triggered the biggest change to how we work with Microsoft Excel formulas in years, if not decades. They allow a single formula to spill multiple results into ...

and only files matching my_test_here would make it onto do_something. I love the while-read pattern, but it just doesn't feel right that there's no simpler, built-in, idiomatic way to write a function ...

Use popular 'grammar of data' syntax to filter and subset your two-dimensional JavaScript arrays and more. Here's how to use Arquero for data wrangling in Observable JavaScript and Node.js. There are ...