by admin | Feb 2, 2016 | Random
As always, I hope you are well. As per my earlier blog post I am going to be offering two segments here: Excel Novice 5 min tip Todays’s 5 minute tip is , this week, to learn 2 keyboard shortcuts for things you do most often. Repeat the same thing next week. In...
by admin | Jan 29, 2016 | Random
One of the areas that fascinates me as a trainer is how people learn. One of the big ideas over the last few years has been the idea of “deliberate practice” as outlined by Malcolm Gladwell in his book Outliers. In this book, he argues that it takes 10,000...
by admin | Jan 4, 2016 | Random
Well, as we start 2016, I know that some of you might be thinking of looking for a new relationship in this year and yes, Excel can help you. Paul McKenna (the celebrity hypnotist) says he chose his fiancee using an Excel spreadsheet. If this is something you want to...
by admin | Nov 27, 2015 | Case Studies - How To
Hope you are well. In this tutorial I want to show you how to clean up a data set with a view to analysing it. During the year I participated in my first 8k race and I found myself curious as to how people did etc. So I asked the organisers for the raw data which...
by admin | Nov 10, 2015 | Random
Am thrilled that one of my tips got used in MrExcel’s latest Excel book: The 40 greatest Excel tips of all time. (This is the Amazon.co.uk link). This is MrExcel’s 40th book. It’s actually a beautifully produced colour book full of illustrations,...