Simon Hurst
Member Since: 9th Jul 1997
Likes: 0
Thanks: 63
Simon Hurst is the founder of technology training consultancy The Knowledge Base and is a past chairman of the ICAEW's IT Faculty.
Partner The Knowledge Base
24th Apr 2015
Link to a chosen workbook in Excel
A recent question asked Is it possible to have an excel link to a different dated excel file . In essence, the requirement was to be able...
Tech pulse
20th Mar 2015
Ultimate Excel options: Part two
Last time we looked at some Excel options that could be very useful if you intended to use them, but could also be very troublesome if they...
Excel
6th Feb 2015
Excel options that can ruin your day
Setting your Excel options correctly can make a positive contribution to how efficiently you work with spreadsheets. But sometimes an...
Excel
12th Jan 2015
Excel Tip: Returning multiple rows
In a recent Any Answers question , Rikos asked for help with the following requirement: " I want to return multiple rows of data from one...
Excel
10th Dec 2014
Excel summary functions 3: DSUM(), GETPIVOTDATA() Etc
This sequence of tutorials has looked at different Excel functions and features that can be used for adding up and otherwise evaluating...
Excel
9th Oct 2014
Power BI redefines the spreadsheet
More advanced versions of Excel 2013 offer extra analysis and viewing tools that take the spreadsheet into the realm of analytical...
Excel
19th Sep 2014
Excel summary functions: Conditional sums
In the second instalment of his overview of Excel’s summary functions, Simon Hurst delves further into the different capabilities of SUMIF...
People
22nd Aug 2014
Excel summary functions: A summery summary
Simon Hurst gets his teeth into the different characteristics of Excel's aggregate and summary functions. Adding up is one of the most...
Excel
4th Jul 2014
Analysis: ICAEW principles for good spreadsheet practice
Simon Hurst, one of the members who worked to assemble the publication, examines ICAEW's 20 principles for good spreadsheet practice. For...
Excel
17th Jun 2014
Working with text in Excel
As well as numerical data, text often finds its way into spreadsheets. Simon Hurst explains different ways you can deal with it. Sometimes...
People