Category: Microsoft Office

  • Dynamics GP Email – Login Failed error

    ,

    Troubleshooting the error “Login Failed: check your login information and try again”, for the Exchange Log On prompt in Dynamics GP. (continue >)

  • Remove all notes in PowerPoint

    This post contains a tip about how to remove all notes from PowerPoint slides instead of removing them one at a time. (continue >)

  • Issues with Word Templates

    ,

    Recently, there have been issues with Dynamics GP and Word Templates, due to some changes to the most recent Microsoft Office build releases. Specifically, documents generated in Word Templates cannot be opened in Microsoft Word, for environments running a build of Microsoft Office from Sept 8/9th or newer. Today’s post is an attempt to clarify… (continue >)

  • Excel – where did my workbook go?

    ,

    A #TipTuesday post about Excel and hiding workbooks. (continue >)

  • Excel Background Refresh & Pivot Tables

    , ,

    A post about Excel and the Enable Background Refresh setting as it relates to Pivot Tables. (continue >)

  • Excel tip – is X in the list?

    ,

    Today’s #TipTuesday is a detour from my recent SmartList tips for Dynamics GP, and I’m going back to Excel for this one. I have been working on a project recently where some data validation is needed to ensure that user-entered data on some forms is valid. I want to have some visual validation for Accounting… (continue >)

  • Excel Navigation tips

    ,

    Today’s #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 for Excel users to get a set of data ready for an integration, which often is the world I’m living in. Sometimes I’ve… (continue >)

  • Excel’s hidden gem – IFERROR

    ,

    This #TipTuesday post explains the fantastic formula IFERROR and how it can help return meaningful data to users. (continue >)

  • Excel VLOOKUP – numbers as text & vice versa

    ,

    This #TipTuesday is about looking up numbers in text and text in numbers when the data types are not matching. (continue >)

  • Excel tip – “corner” copy

    ,

    This #TipTuesday post is about one of my favourite shortcuts in Excel: “Corner Copy”. (continue >)

  • Dynamics GP & Office 365

    ,

    This #TipTuesday is a post about converting from Office 2016 to Office 365 and some of the issues one might experience with email functions in Dynamics GP. (continue >)

  • Outlook credentials issue

    This post is about credentials in Outlook for Office 365 and having difficulties with Outlook recognizing my email address. (continue >)

  • Excel Paste Special – Operations

    ,

    This #TipTuesday post is how to Paste Special with a multiply or divide operation to quickly change the sign on a set of data. (continue >)

  • Excel tip – copy & paste unique values

    ,

    This #TipTuesday is for Excel users, and it is a tip about how to copy and paste only the unique values from a list. (continue >)

  • Flash Fill in Excel

    ,

    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 users could use this in a pinch in GP from an exported Smartlist, at the end of this post! Flash Fill came out in Office 2013 (as far as I… (continue >)

  • Upload Pending issue in Excel with OneDrive

    ,

    This post is about the annoying “upload pending” issue in Excel with OneDrive. (continue >)

  • Cool Excel Tip – dates without holidays included

    ,

    Have you ever wanted to put a schedule together in Excel with planned dates for something over a period of time, and then manually reviewed the formula, to change dates so they didn’t fall on a holiday? A client of mine prepares a billing schedule a year in advance where they have to incorporate certain… (continue >)