Cleaning up an accounts file with Power Query

One of the most common tasks faced by accountants and office workers is that of data cleansing i.e. removing the extra blank columns , sub totals, blank rows so beloved of accounts packages but which all need to be removed before any sort of Excel analysis can be done...

Faster Filtering with Filter()

Filter() is one of the new dynamic array functions in Excel. So what does that mean? If you have used Excel you will know that generally it has made like a single celled organism – create your formula in ONE cell and then copy it down or across. The new range of...