We’re coming upon the release of Office 2010 technical release. Although it’s exciting, it means the start of a lot of work for anyone who has to update a book, a website, or any other type of training material.
I’ve always told people that it takes me an average of one hour per page when writing. Do I have A.D.D? Yes, but that’s not the reason it takes me so long.
It’s the sample files. Creating sample files takes so much longer than anyone can suspect. The difficulty comes in finding the balance between creating scenarios in the vacuum of your training scope while making sure your examples fit reasonably in a real-world scenario. Core to this requirement is solid sample data.
If you’ve ever tried to create sample data from scratch, you’ll know that it’s mind-numbing work. Especially if you’re creating some sort of sample database where keys and joins have to make sense. It sounds easy, but it’s not. Try it some time (without using actual client data).
Luckily, a few months ago, Dick Kusleika (Daily Dose of Excel) told me about an add-in he has been helping Jimmy Peña (Code for Excel and Outlook) finalize. This add-in creates random sample data automatically.
I’ve tried it and I must say it’s the SHIZNIT! If you’re not keeping up with the cool slang, that means it works extremely well.
This will save me an obscene amount of time – especially since I’ve been wanting to update the stale datasets in the older versions of my books.
If you are an Excel or Access trainer who constantly finds the need to create sample datasets, you have got to try this. I think you’ll be very happy.
You can find the add-in at Jimmy’s site Here.
As a bonus, he’s got an unlocked version so that you VBA gurus can customize it.
I’ve customized mine to change ‘GENDER’ to ‘SEX’. Mainly because my brain-age is 5 and it makes me giggle.