Power BI
Article
9th Nov 2016
10
Simon Hurst expands his ExcelZone series to explore the revolutionary new Excel feature that Microsoft did their best to conceal. In the...
istock_vm
Article
17th Nov 2016
3
Simon Hurst revs up his Excel Zone mini-series by using Power BI to tackle dodgy dates, numbers that don't add up and duplicates...
Steel with sparks
Article
9th Dec 2016
14
This is the second part of a series of articles that looks at how Excel's Power Query/Get & Transform tools can be used for a great...
welding
Article
30th Dec 2016
In the third part of a series of articles, Simon Hurst looks at how Excel's Power Query/Get & Transform tools can be used for a great...
Formula one wheelspin
Article
3rd Feb 2017
This is the fourth part of a series of articles that looks at how Excel's Power Query/Get & Transform tools can be used for a great...
Power tool
Article
2nd Mar 2017
2
Simon Hurst continues his series of articles that looks at how Excel's Power Query/Get & Transform tools can be used for a great deal...
Factory manufacturing
Article
11th Apr 2017
2
Simon Hurst brings together all the techniques covered in the five previous parts of the series and shows how to combine trial balance...
Using a sliding compound mitre saw
Article
19th Apr 2017
6
Simon Hurst concludes his two-part series on automating management accounts. The plan In the first part, we went step-by-step through the...