Here’s a cool little Excel tip for #TipTuesday. Have you ever had a column of information in Excel and wanted to get a distinct / unique list of values from one of your columns of data? I learned a new thing last week doing just this, and, surprise, it wasn’t “create a pivot table with that column”!
TL;DR summary: I like it!
I have had the Surface Go for just over 1 week now. I had been interested in it since it came out and did a lot of research on my recent trip to Fargo comparing US prices vs. CAD prices and comparing the “unique” build configuration that Costco was selling vs. what everyone else had.
Yes, I’m one of those…
Today’s #TipTuesday is short, but also related to a post from a couple of weeks ago where I posted what the minimum permissions required were for using GP Utilities. Coincidentally (or perhaps not?), last week a consultant posted a “tip” on this on the GPUG Open Forum, where there was a dangerous suggestion made, that I’m not sure they fully realized the implication of (at least I hope they didn’t think that one through and posted in haste…).
This post really doesn’t have anything to do with Dynamics GP specifically, but more about business process, internal controls or lack thereof and a fun “Twitter Moment” earlier today.
Late last week, Steve Endow, fellow Microsoft MVP, independent technical consultant, and ISV (distributor of some ISV products at least!) posted a tweet, and it’s not the first time I’ve seen something like this from him. If the Twitter link dies, it says “Another Dynamics GP partner paid me by credit card, and then sent me a check 2 weeks later. Methinks this is a common AP control / process / communication issue. Unfortunately, I don’t think software can easily fix this.”
Today’s #TipTuesday post is a Microsoft Excel tip, instead of the usual Dynamics GP tips! I do have a tie-in to Dynamics GP on where you could use this in a pinch in GP from an exported Smartlist, at the end of this post!
Have you ever used Flash Fill? It came out in Office 2013 (as far as I can confirm) and I must say, there are a number of different instances where I’ve found this extremely useful in a pinch to pull data out of some cell that contains more than what you need.
This is post 3 in my series, but it’s the first post where I’m starting to document actual work in PowerApps. Today I have simply started to create the shell of my new app “My Golf Stats” as well as start to get the data layout for what I envision in Excel. This post will just be about the app shell and I’ll dig into the Excel part later.
I can’t believe it’s nearly 6 weeks ago that I posted my first post on this topic! Wow, time flies when you’re having fun! Quick recap: I’m interested in learning PowerApps, but as of the moment, I don’t have a good handle on a business application for it in my company. So, it’s going to be a personal project I’m going to tackle to get a sense of what it can and can’t do.
Today’s #TipTuesday post is around GP Utilities and what permissions are required. If you are going through any service pack install or upgrade, you might have a lot of workstations that need to be updated! In our case, we just upgraded our Dynamics GP and wanted all hands on deck to help with installs, including some IT team members who didn’t have any GP access. Here’s how you do it and what permissions are required.
I’m getting ready to leave Fargo for another year and head home after a long but great week of learning and networking. For those that may have missed my earlier posts, here are the 3 posts I wrote after each day of the Dynamics GP Tech conference:
Today was day 3 at the Dynamics GP Tech Conference. As in other years, the 3rd day is a half day and many people head on their way back home right after the conference is done. For me, it’s a bonus part of a day off to regroup, review notes, check in on email etc. and get ready for 2 more days of training. I’m going to be taking the eOne Solutions SmartConnect bootcamp Thursday and Friday.