August 14, 2011

Andrew's Excel Tips is moving

Andrew's Excel Tips is moving!

The new blog can be found here.


Posted by andrewe at 10:07

August 03, 2011

Excel Power Analyst Boot Camp

Mike Alexander of DataPig Technologies is holding a seminar at Alexandria, VA (near Washington the city, not the state), from September 19, 2011 (Monday) to September 20, 2011 (Tuesday).

Topics include

  • Analysis
  • Reporting
  • Sourcing External Data
  • Bacon Recipes (one can only hope)

    Click the pig to check it out!


    Oink! :-)

  • Posted by andrewe at 18:52

    July 03, 2011

    Excel Everest

    Recently I was asked by Excel Everest for a review of their training.

    First off – I like their approach of using Excel itself to present the training.

    And I liked how they make it fun. (Watch out for the bear and other hazards!)

    What’s most important is that the available courses cover a lot of useful, hands-on material that is simple to follow and version specific.

    Learning Excel can be an uphill battle, but Excel Everest will help you climb your way to the top ;-)  
    Posted by andrewe at 10:51

    February 07, 2010

    Capturx For Excel

    I’ve been meaning to write about this for a while but things have been busy :-)

    Last year I was asked by the Adapx company to try out their Capturx add-in for Excel.

    Using their digital pen, you can write on their forms when printed on paper, then upload the written data recorded by their digital pen to your computer and show it in Excel.

    Pretty neat idea I thought, and I can see a whole lot of uses for it. Anybody who works away from a PC can upload their data at their convenience without the hassle of inputting pen written data on a computer manually (typing).

    After some minor difficulties, I got things set up and gave it a whirl.

    Here is a picture of the form showing hand written data that was uploaded. I must point out that I really do write like this, it’s not exaggerated. (I used to write neatly but then PCs appeared, my typing speed got a lot better though)

    And here is a shot of the inputted data. Note the comments still show hand written data.

    It works quite well - the only problem I came across was the date formatting. I guess that can be worked around with neater hand writing?

    My impression – if you employ people who write stuff on paper forms, consider using this. It will save time and keeping records on a PC will become a lot easier. The pens are not cheap but the money saved with time should make up for that and efficiency will definitely get a lot better.  
    Posted by andrewe at 08:38

    December 30, 2008

    Goodbye 2008

    How time flies when you are having fun. I'm in the middle of my first real vacation since I came back to Australia and it was certainly worth the wait.

    Anyway, this year has been a good year for me but it can always be improved. I've made my New Year's resolution for this blog in 2009 but it's still a secret. With a bit of hard work, maybe it will come true.

    See you in the new year :-)  
    Posted by andrewe at 09:00

    April 19, 2008

    I'm Back!

    Finally, my main site is back up again. And I've got stuff I've been working usual. To be uploaded soon so please be patient ;-)

    (Other stuff that was not downloadable is up again too, so please go for it!)  
    Posted by andrewe at 09:06

    March 16, 2008

    Excel Thunder Down Under

    Last week I had the pleasure of meeting some old friends and making some new ones in Sydney at the Excel User Conference.

    From left to right, Dick Kusleika, Charles Williams, some dude and Damon Longworth. (Oh yeah, that dude is me)

    The presentations were excellent and I had a great time. I sure hope I can go again :-)
    Posted by andrewe at 20:56

    February 24, 2008

    JMT Excel Utilities Updated

    I have been updating my main utilities again. I have not added anything new, just improved (debugged) some that I found that were not working properly with Excel 2007. I do intend to add some more utilities at a later date though.

    Here's the download link. I've also done a little work on the Excel 97 - 2003 version, you will find it included in the same zip file. Don't forget they are free :-)  
    Posted by andrewe at 10:06

    January 20, 2008

    Excel User Conference in Sydney

    Excel Thunder Down Under!

    That's what the Excel User Conference web site says will happen in March this year and considering who is coming, I well and truly believe them!

    Dick Kusleika, Charles Williams and Damon Longworth - that's 3 Excel household names - coming to Sydney and presenting a broad range of important Excel subjects over a 3 day period.

    If you can attend, do yourself a favor and do so! I'm going to drop in too ;-)

    Here's a link to the main event!
    Posted by andrewe at 18:19

    December 24, 2007

    'Twas the day before Christmas

    Tomorrow is Christmas again, the 4th since I started blogging. This year has been particularly busy, so I have not been as active as I would have liked.

    But I am still around and there is always next year. I'll do my best to make up it for it then...

    Until that time, Merry Christmas and a Happy New Year folks. Hope it's a good one ;-)  
    Posted by andrewe at 12:41

    November 16, 2007

    JMT Excel Utilities - Free Again

    Shortly after becoming an MVP this year, I made my most popular add-in into shareware. And I have felt guilty ever since.

    So, I talked with Colo. We decided we can help a lot of people by making JMT Excel Utilities freeware again. And so we have.

    Here they are again, for free. Enjoy! :-)  
    Posted by andrewe at 21:28

    October 04, 2007

    JMT Utilities for Excel 2007

    Finally ready for download - JMT Excel Utilities for Excel 2007!

    Note that the both the 97 - 2003 version and 2007 version are included in the same price. (If you have previously bought the 97 - 2003 version, write me an email and I will send the 2007 version to you free of charge)

    You can download both versions here.

    Posted by andrewe at 13:24

    September 24, 2007

    My Son Ryan

    A new addin addition to the family was downloaded delivered on Sunday morning.

    Ryan was born at 33 weeks so he needs a little extra care for a while but he seems okay, his mum is doing fine too.

    And I'm a dad. Wow! :-)
    Posted by andrewe at 17:13

    March 18, 2007

    MVP 2007 Global Summit

    Just back from the Microsoft 2007 Global Summit, I'd like to thank all of the other Excel MVPs who were I thought were a really nice bunch of people.

    Here's a photo of some of us at a local bar shortly before we were asked to relocate! (Left to right are Ken Puls, myself, Dick Kusleika, Stephen Bullen, Damon Longworth, Bob Phillips, Nick Hodge, John Walkenbach, Jon Peltier, Tushar Mehta, Zack Barresse and Masaru Kaji (aka Colo)

    Not in the photo but also great to meet were Debra Dalgeish, Curtis Frye, Ron Coderre, Niek Otten, Bill Jelen, Shane Devenshire, Bill Manville, Chip Pearson, Bob Umlas, Ashish Mathur, Toru Tanaka and Carson Cheng.

    Yep, this is what the summit looked like...

    Well, I'm not such a great photographer ;-)

    Actually I notice my pal Ken Puls has quite a few photos on his blog, as you can see at Damon Longworth's site too. Please have a look at my friend Colo's site to see his collection.

    Anyway, I was glad to get a hold of this gem, these guys are why I started blogging in the first place...

    And a nice shot of Colo and me. Cool huh?

    Here's hoping we can all meet for the next one!  
    Posted by andrewe at 14:29

    February 12, 2007

    Home Sweet Home

    Yep, I'm back in the land of Oz at last.

    And life is pretty hard... here is a shot of my new office (as you can see, I have to rough it outdoors...)

    Actually I am staying with relatives at the moment, but we are looking for a place near the sea too.

    I'm looking forward to getting used to this ;-)
    Posted by andrewe at 20:38

    January 09, 2007

    JMT Excel Utilities

    At last, they are finally ready - JMT Excel Utilities - the professional version of my former addin, Andrew's Utilities.

    A great deal of the code has been rewritten to offer increased efficiency and less chance of error. At the same time, some entirely new utilities have been added that did we think will come in very handy.

    As mentioned on a previous occasion, these utilities are no longer free. But I hope you will find them worth the small price we ask. If you consider the time you can save using them every day, we think you will find they are a very good bargain indeed.

    Note: The code is also available for a price. Once you access the download link, please keep in mind that updates are absolutely free.

    The download page is here.  
    Posted by andrewe at 21:48

    January 05, 2007

    Happy New Year - I'm an MVP!

    This year is off to a really good start...I'm very pleased to announce that I have been made a Most Valuable Professional (MVP) for Microsoft Excel.

    Amongst other things, this means I can attend the upcoming Global Summit at Microsoft in March of this year, where I can meet some great friends who have given me their support since I first started writing on this blog. It really is a dream come sincerest thanks to one and all!

    You can find more information on Most Valuable Professionals for Microsoft here.
    Posted by andrewe at 13:06

    September 27, 2006

    Coming Soon

    Sorry for my infrequent posting of late.

    Colo and I are working on a shareware version of my utilities. They should be ready sometime in November - there is quite a lot of changes we are making and they will be a lot better than before.

    Did manage to add a right-click menu to Rounded Comments that allows you to Cut, Copy and Paste inside and outside the textbox. Here's a pic.

    It's just as easy to use short cut keys - Ctrl + X for Cut, Ctrl + C for Copy and Ctrl + V for Paste. There are those times when you might be on the phone or something and don't have both hands free... at least I have the phone on the left and it's pretty hard to use the short cut keys with my right hand, the mouse is quite handy though.

    Back to work, bye for now :-)  
    Posted by andrewe at 19:00

    June 27, 2006

    Time Off

    I'm making a trip to Australia next week, this week I am getting ready packing and taking it easy...

    Here is where I am headed, Redcliffe, a small seaside town near Brisbane.

    Last time I went back was...about twelve years ago? I forget exactly, but I sure hope this trip will be one to remember :-)

    See you when I get back. I'll be doing a little travelling here in Japan too so let's make it late August ;-)  
    Posted by andrewe at 18:51

    September 06, 2005

    JMT Consulting

    Colo and I have been talking about this for some time.

    Colo has already been doing consulting work for quite a while now but it's a new experience for me.

    And experience is what I am after - most of the time that I use Excel is at my job, and as the company is quite small, there is only so much that I can really learn from working there.

    So this is a good opportunity for me to see what people at different companies are doing and how it can be solved.

    I'm hoping that learning new things will help me to write and make better stuff, so from the both of us - we would really appreciate your support. Quoting is free, final work is approved by Colo so you can rest assured that you will be getting top level help.

    Just click the image link above and you will be taken to our site.  
    Posted by andrewe at 20:09

    May 15, 2005

    Excel Heaven

    This really makes my day...

    Dick Kusleika from Daily Dose of Excel wrote about it in Daily Dose Headlines.

    And John Walkenbach (aka J-Walk) made this very convenient link to show how it's done.

    Mark Wielgus of AutomateExcel fame has also written about it and shows a nice way to make your own.

    Meanwhile, Colo has added the JMT Forum feed to make his own version.

    This just keeps getting better and better... Thanks guys!  
    Posted by andrewe at 19:49

    April 06, 2005

    Site Upgrades

    Just a couple of quick announcements.

    Colo has restyled his site, Colo's Excel Junk Room. Honestly speaking, his talent at design never ceases to amaze me, not to mention his skill at Excel of course. I wonder if there's a connection between the two? My artistic skills need some work, that's for sure ;-)

    At the same time, the JMT Microsoft Excel Forum is being upgraded also. Unfortunately some former information and posts were lost. It's probably better that this happen sooner than later, some of the new features should prove worth it in the long run.

    Please show us your support and join us there. You're always welcome!  
    Posted by andrewe at 22:45

    March 29, 2005

    New Look

    Yes, there's a new look for my main site, courtesy of my buddy Masaru Kaji, Microsoft Excel MVP (or more commonly know to his fans and friends - Colo, the VBA Guy!)

    It started like this...Gareth, co-conspirator of the JMT Forum asked for new logo suggestions for his site, The Excel Maniacs.

    Hmm, about this?

    In the meantime, Colo was working on his own logo as you can see in the top right hand corner of the already updated "Maniacs" link.

    Well, waste not, want not... now look what happened...

    First an addict, and now a maniac, things are really looking up! ;-)  
    Posted by andrewe at 19:25

    March 15, 2005

    New Excel Forum

    There's a new Excel Question and Answer forum in town...(well, maybe not so new, but the site itself is new)

    As you can see, it's run by Colo aka Masaru Kaji (from Colo's Excel Junk Room), Gareth Lombard (from The Excel Maniacs) and starting from yesterday, myself also. Somehow I got chosen as the moderator for "Excel General Questions". (gulp)

    Anyway, it's a forum that Colo and Gareth have run for the last couple of years, doing their best to help people solve problems of all levels, so please show them (us) your full support. Anyone can join, feel free to ask or answer any questions you like ;-)  
    Posted by andrewe at 21:02

    September 06, 2004

    Formulas, Formats and Shortcuts

    Today I finished a new section of my site called Formulas, Formats and Shortcuts.

    The tips shown are the same as what are available on my Download Tips and the same rules apply.

    1. Not all of them are mine. I try to give credit wherever possible.

    2. I apologize for some of my "sillier" formulas, but sometimes writing them helps me learn. I appreciate any suggestions or corrections.  
    Posted by andrewe at 00:36

    August 01, 2004

    Download My Tips

    Over the last couple of weeks, I have been putting together a bunch of tips that can be downloaded from my site.

    Help Me to Help You
    A lot of these tips are my own, but some are tips I have come across elsewhere.

    If you have any tips that you would like to share, please email me and I will include them in future updates. (subject to approval)

    Also, credit will be given where it can be proven. If you want credit, please provide some proof that you are the originator.

    Here's the Tips file. Please note that it uses Treepad software (supplied with the tips).  
    Posted by andrewe at 19:06

    June 20, 2004


    Today my new site is officially open.

    I've been getting it ready over the last few days, thanks largely due to my good buddy Colo.

    I hope you like the new look. (Please excuse the photo on the left, I'm a lot better looking once you've had a few beers)  
    Posted by andrewe at 03:29

    April 23, 2004


    Hi there. I'm starting up this blog to give some tips on Excel (Microsoft Spreadsheet Program). My level now is intermediate but hopefully my tips might be useful to some other people who use Excel. This idea was suggested to me by my new friend, Masaru Kaji (aka Colo) who is a Microsoft MVP. This stands for Most Valued Professional and is awarded by Microsoft to people who have made major contributions to their field of speciality. You can see his site at this link - Colo's Junk Room Thanks Colo, hope to meet you soon :)  
    Posted by andrewe at 18:14