This is not my typical #TipTuesday blog. I’ve missed the
last 2 Tuesdays, and I promise to get back to a regular schedule by end of this
In its place is my take on what I look for when considering who to vote for in the GPUG All*Star awards voting process plus a little bit about the difference between a Microsoft MVP and GPUG All*Star.
So, let’s get to it! It’s that time of year again – GPUG All*Star voting time! First, here is some background information for those of you who may not yet be familiar with these programs and awards.
Continue reading “GPUG All*Star 2019 Voting”
#TipTuesday is yet another Excel tip. This one is about navigation, and some
tips around things I use every day when I’m working in Excel. Some of these are
particularly useful if you are using Excel to get a set of data ready for an
integration, which often is the world I’m living in. Sometimes I’ve integrating
right from Excel and sometimes I’m working with something where I need to “save
as” and I need to make sure I don’t inadvertently have blank rows or columns in
my data. That, in a nutshell, is the background for this post and set of tips.
Continue reading “Excel Navigation tips”
Today’s #TipTuesday is yet another Excel tip. Can you tell I’ve been working with spreadsheets a lot lately? My blogs tend to follow my work and these last 3 weeks have been no exception. As I run into things or use something I haven’t touched in a while, I tend to blog about it!
This tip is about what I believe to be a hidden gem in Excel and that is the IFERROR formula. Over the years, I have seen many people do many funky workarounds to “pre-check” if they will get an error when there is a formula that will help you out much more easily!
Continue reading “Excel’s hidden gem: IFERROR”
Have you ever tried a VLOOKUP formula in Excel where you’re looking up something that is numeric but stored as text, or vice versa? So annoying, when you seem to have one set of data one way and the lookup in another, right? Today’s #TipTuesday is all about helping you with a couple of formula tweaks to make this a bit easier.
Continue reading “Excel VLOOKUP – numbers as text & vice versa”
Today’s #TipTuesday post is a little Excel tip. It’s one of those things that I assume most people know it, and then I work wth someone and watch them use Excel and end up teaching it to someone. I call it corner copy but I’m sure there’s some official name!
There are 2 parts to this tip really: one is the copy via double clicking on the lower right corner and the bigger tip is the little pop-up window that gives you options on how that command is executed. That little pop-up window is the *gem* of this tip in my opinion as it appears in numerous instances of doing things in Excel.
Continue reading “Excel tip – “corner” copy”
I’m thrilled to announce that I’ve been renewed as a Microsoft MVP in Business Applications (Dynamics GP focussed) for the next year, through to July 1, 2020.
Continue reading “MVP Renewal for 2019/2020”
Today’s #TipTuesday is a post about Office 365 and Dynamics GP and is specific to email functionality such as emailing Purchase Orders, EFT Remittances and Sales Documents. Rest assured that most other functionality other than email seems straight-forward and works no matter what (like exporting from Smartlist). (At least that’s my experience although there may be exceptions I am unware of!)
Continue reading “Dynamics GP & Office 365”
A little while ago, I was trying to add one of my Office 365 email accounts back to Outlook and it wasn’t working. I forgot that I needed an app password because I have MFA (Multi-factor authentication) enabled on my domain/tenant. I initially put in my “regular” password and was expecting it to kick back and let me try again; however, it didn’t do that.
Continue reading “Outlook credentials issue”
There’s no #TipTuesday today since I had website issues over the weekend and was unable to access it to prepare something. So, this will be a form of a tip in lieu of another topic!
There will be no mid-year tax update for Canadian Payroll for Dynamics GP this year, zippo, nada, zilch! Imagine that, not a single jurisdiction has a tax change this mid-year. That’s got to be a first!
So, enjoy your July 1st without a tax change!
There’s an expression “you can take the girl out of consulting but you can’t take the consulting out of the girl”. OK, so that’s not really how that goes, but it fits the situation!
As of June 1st (2019), I’m resuming my consulting business – Kuntz Consulting Inc. – and am back to being a Microsoft partner and independent consultant. This is so new that I haven’t even had a chance to update my website; so, depending on how quickly you read this post and click on that link, you may see the old message “no longer taking on clients”! Rest assured, I’m working on the updates as you read this.
Continue reading “Back to consulting!”