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 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,...
by admin | Oct 9, 2015 | Random
One – Learn how to enter data into Excel A big big chunk of working effectively with Excel is getting your data set up right. So basically that means, if you have repeating data e.g. training records, invoices, transaction, they should be entered as a single big...
by admin | Sep 18, 2015 | Random
Excel is becoming somewhat like the Irish diaspora of the IT world. No matter where you go, you will find an Irish person and Excel – sometimes even together! In the article below there are a number of views from various Excel gurus and generally the view is...
by admin | Jul 30, 2015 | Random
You know the movie Jerry Maguire where Renée Zellweger says to the Tom Cruise character..”you had me at hello”…well when you arrive in late to my class, I feel exactly the opposite. You arrive in late – 5 minutes, 10 minutes, 20 minutes....
by admin | Jun 8, 2015 | Random
First of all, if you don’t recognise the allusion in the title – here’s the Michael Bublé version…. MrExcel (the leading Excel publisher) and I have collaborated to create some Excel tipsheets. These would be useful for trainers, or for...