Member Since: 9th Jul 1997
Simon Hurst is the founder of technology training consultancy The Knowledge Base and is a past chairman of the ICAEW's IT Faculty.
The Knowledge Base
10th May 2018
Learn how to automate Excel calculations through the use of logical functions such as IF(), AND(), OR(), NOT() and IFERROR(). Simon Hurst...
27th Mar 2018
Simon Hurst looks at advanced merges in Power Query, including joins that involve more than a single field and approximate lookups, using...
8th Feb 2018
Objective: To extend the range of Excel problems that can be solved using Excel's lookup functions and to reduce the number of VLOOKUP()...
19th Dec 2017
Over the course of the year we have looked at a variety of uses for the Power BI tools and the separate Power BI application. But this time...