I live in London. A group of nice American tourists stopped me in the street to ask me how they could get to St Paul’s Cathedral. They had a map of the London...
Philosophy
A variation on the Celebrity Chef Spreadsheet Challenge. Inspired by Alan Murray PowerQuery Challenge. 11/01/2020 Part 1 This restaurant can have up to 100 diners. The...
(With apologies to ‘Have Gun – Will Travel’. I think is was a 60s Western TV series?) There are thousands of YouTube walkthroughs that are a gold mine...
Yesterday Alan Murray posted a tutorial here, and asked the question ‘how would you do it’. I didn’t use PowerQuery. I would have, if it gave me an...
People talk about Add Ins as if it’s some specific determinable item. It’s just a bloody container for code! The code could be relevant, good, bad, buggy,or...
You can download the Excel spreadsheet here (5 January 2020) Friends Expenses Demo (48kb) Save the workbook to anywhere you like. The Scenario A group of Friends often...
If you look back on the history of innovation you will find this pattern. There’s a process that has it’s inherent pains. The pains are generally accepted by...
UX means User Experience. This is now a hot topic as people use apps on smartphones to do things quickly and easily. UX in the context of spreadsheets is also a hot...
Wikipedia This is when something is transmitted by attaching itself to something else that’s travelling. For millennia ‘data’ was transmitted by being...
(This blog has nothing at all to do with Bond25. That’s ‘No Time To Die’. I have a theory that the original intended title of the movie was ‘No...