by admin | Oct 30, 2015 | Case Studies - How To
Well, in this blog post I am going to cover a very common scenario – not having your data the right way around to do something with it i.e. make a pivot table from it. However I am going to show you how to do that with a not (as yet) well known add-in for Excel...
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 | Aug 31, 2015 | Tracking Training Records in Excel
Do you have to track who is up to date with their certification across a number of courses and departments ? This blog post should help. Recently I was working in an organisation and one of the users – new to Excel – who had been on a course I had given,...
by admin | Aug 25, 2015 | Tracking Training Records in Excel
Suggested revised formula. A while ago I posted a blog post with a suggestion from a reader about how he quickly formatted batches of dates and times. He saw the post and came back with a revised formula – using TimeValue. He had originally suggested...
