FILTER outperforms pivot tables and dropdown filters FILTER works well with other Excel functions like SORT and UNIQUE to create powerful data management combinations. You can nest FILTER inside SUM ...

In the wave of digital transformation, the construction of a knowledge base is often seen as a "nice-to-have". However, few are aware of the complex engineering and organizational pains behind it.

A self-confessed computer geek is off to Las Vegas - to represent Britain in the World Spreadsheet Championships.