Here’s a conundrum for you. You want to find out the time in another time zone. Let’s say New York. Your local time in sunny Queensland, Australia right now is 4:00 AM (the sun is just coming up). You know your local time is GMT+10, and you know that the time in New York is [...]
September 2011
With a family of 4 fussy eaters to feed (well actually, 3 fussy eaters and myself) I do a lot of research on the internet for new recipes. The problem is I often find great recipes but they’re in imperial measurements and I have to convert them. Actually, it’s not that big a problem ‘cause [...]
The other day I was in an Excel forum helping answer some questions. I like to help, because….well, I like to help, plus I like a challenge and it gives me ideas for things I can share with you. Anyway, I came across this tip (posted by someone else) and I had to read it [...]
How often do you work with tabular data sets? You know, like this one below where you’ve got column labels and then each row is a record: When you work with data like this Database Functions are your best friend. Why, because they’re so simple, yet they’ll do most things an array formula will do, [...]



... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses


