Hello all and welcome back to the Excel Tip of the Week! This week we have a Developer level post in which we are taking a look at how to create your own custom functions in Power Query.
David Lyford-Tilley
ICAEW
Article
22 March 2022
I have been working on a project recently for which I wanted to include a set of refreshable Excel Tables in a control worksheet to highlight exceptions in the underlying data. Generally, the best way to avoid Tables clashing with each other as they expand and contract is to keep them on their own, separate, worksheets. In this case, I wanted to create a single workbook that would highlight potential errors at a glance, and the Tables concerned were only likely to generate a few rows each. The following examples demonstrate some of the considerations involved.
Simon Hurst
ICAEW
Article
17 March 2022
Hello all and welcome back to the Excel Tip of the Week! This week we have a Creator level post in which we’re taking a timely second look at the biggest change to Excel formulas in recent years, the nifty dynamic array formulas.
David Lyford-Tilley
ICAEW
Article
15 March 2022
Hello all and welcome back to the Excel Tip of the Week! This week we are taking a deep dive into a very annoyingly necessary data cleaning task – removing excess spaces.
David Lyford-Tilley
ICAEW
Article
08 March 2022