Excel

Excel

Spreadsheet tips and tutorials to boost your knowledge of the world’s favourite accounting tool.

Newsletter updates

Join your peers and be in the know

Get all the latest tax, compliance, business and practice news from AccountingWEB.
Subscribe here
5th Nov 2019
1
Prior to this new functionality, if you wanted to work with ranges, you used to have to build array formulae, where references would refer...
30th Oct 2019
Unlike ourselves, Power BI is completely rational. An unexpected answer is simply a symptom that you need a better understanding of your...
16th Oct 2019
If the “final” versions of Dynamic Arrays highlighted here do not change drastically once they become generally available, there will be...
2nd Oct 2019
Like most questions to do with Power BI, the answer is “it depends”. It depends on what you mean by “learn”. If all that you want to do is...